ABOUT THIS EPISODE
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/
English
United States
IN THIS EPISODE
TRANSCRIPT 🔗
WEBVTT
1
00:00:00.000 --> 00:08:41.000
In this episode of Scaling Postgres, we talk about column performance. Brin when unique and null in parallel distinct. I'm creston. Jameson and this is scaling postgres episode 224. I hope you, your friends, family and coworkers continue to do well. Our first piece of content is column order in PostgreSQL does matter. This is from Cybertechyphenposgresql.com and it's talking about column order. But more specifically, I think it's talking about when you have…
1
00:00:00.000 --> 00:08:41.000
In this episode of Scaling Postgres, we talk about column performance. Brin when unique and null in parallel distinct. I'm creston. Jameson and this is scaling postgres episode 224. I hope you, your friends, family and coworkers continue to do well. Our first piece of content is column order in PostgreSQL does matter. This is from Cybertechyphenposgresql.com and it's talking about column order. But more specifically, I think it's talking about when you have…
SEARCH PAST EPISODES
Search past episodes of Scaling Postgres.
Disclaimer: The podcast and artwork embedded on this page are from Creston Jamison, which is the property of its owner and not affiliated with or endorsed by Listen Notes, Inc.
EDIT
Thank you for helping to keep the podcast database up to date.