BRIN & Correlation, Poor Partitioning, 10 Beginner Tips, Table & Index Usage

Scaling Postgres

BRIN & Correlation, Poor Partitioning, 10 Beginner Tips, Table & Index Usage | Scaling Postgres 276

Jul 30 2023 | 00:15:57

00:00 / 00:15:57

Hosted By

Show Notes

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:

https://www.scalingpostgres.com/episodes/276-brin-correlation-poor-partitioning-10-beginner-tips-table-index-usage/

Other Episodes

Episode 310

April 07, 2024 • 00:12:55

Andres, Microsoft & Postgres Save Linux? | Scaling Postgres 310

In this episode of Scaling Postgres, we discuss whether Postgres will pull a Redis, remembering Simon Riggs, built-in collation provider and C.UTF-8 in PG...

Episode 47

January 20, 2019 • 00:11:16

pgBouncer, Postgres 11 Gems, DocumentDB, JSON | Scaling Postgres 47

In this episode of Scaling Postgres, we review articles covering pgBouncer, Postgres 11 gems, DocumentDB similarities and JSON capabilities. To get the show notes...

Episode 137

October 26, 2020 • 00:21:14

Toast Impact, zheap Storage, More Performance, pg_rewind Changes | Scaling Postgres 137

In this episode of Scaling Postgres, we discuss the impact of toast, zheap storage results, more Postgres 13 performance data and changes to pg_rewind....