In this episode of Scaling Postgres, we discuss the importance of correlation with BRIN indexes, how partitioning can kill performance, 10 tips for beginners and how to track table and index usage.
To get the show notes as well as get notified of new episodes, visit:
In this episode of Scaling Postgres, we discuss how to convert an integer primary key to a bigint, how container resistance is futile, how...
In this episode of Scaling Postgres, we discuss performance improvements related to skip scans, faster backup & restore, benefits of minimal indexes and more...
In this episode of Scaling Postgres, we discuss things I do not do such as use default partitions, play column Tetris, ELT using special...