sqlTipsTricks

SQL Tips & Tricks – PostgreSQL Queries – Part 2

This is part 2 of PostgreSQL Queries Tips & Tricks from performance and overall backend side of your database. In Part 1 we have covered, duplicated, rarely used indexes and general amount of elements in your DB. This time we will dive into the details of tables and indexes. Below you can find 2 queries …

SQL Tips & Tricks – PostgreSQL Queries – Part 2 Read More »

SQL Tips & Tricks – PostgreSQL Queries – Part 1

Database, IT / By Krzysztof Bury

If you are working daily with PostgreSQL database, sometimes you may have a need to get some information or valid stuff that normally are inside of a Database Administrator scope. In this article I will share with you 3 useful queries mainly for working with indexes in PostgreSQL, version 9.6+. Duplicate Indexes When multiple developers …

SQL Tips & Tricks – PostgreSQL Queries – Part 1 Read More »