Go offline with the Player FM app!
Column Performance, BRIN Win, Unique and Null, Parallel Distinct | Scaling Postgres 224
Manage episode 442671130 series 2140130
In this episode of Scaling Postgres, we discuss how too many columns in a table can affect performance, at what point BRIN indexes win over btree, and Postgres 15 supporting unique nulls and parallel distinct queries.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/224-column-performance-brin-win-unique-null-parallel-distinct/
546 episodes
Manage episode 442671130 series 2140130
In this episode of Scaling Postgres, we discuss how too many columns in a table can affect performance, at what point BRIN indexes win over btree, and Postgres 15 supporting unique nulls and parallel distinct queries.
To get the show notes as well as get notified of new episodes, visit:
https://www.scalingpostgres.com/episodes/224-column-performance-brin-win-unique-null-parallel-distinct/
546 episodes
All episodes
×Welcome to Player FM!
Player FM is scanning the web for high-quality podcasts for you to enjoy right now. It's the best podcast app and works on Android, iPhone, and the web. Signup to sync subscriptions across devices.