אודות פרק זה
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/
אנגלית
ארצות הברית
בפרק זה
תעתיק 🔗
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…
הצהרה: הפודקאסט והגרפיקה המוטבעים בדף זה הם מ-Creston Jamison, שהוא רכושו של בעליו ואינו קשור או מאושר על ידי Listen Notes, Inc.