À PROPOS DE CET ÉPISODE
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/
Anglais
États-Unis
DANS CET ÉPISODE
TRANSCRIPTION 🔗
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…
RECHERCHER LES ÉPISODES PASSÉS
Rechercher les épisodes précédents de Scaling Postgres.
Avertissement: Le podcast et les illustrations intégrés sur cette page proviennent de Creston Jamison, qui est la propriété de son propriétaire et n'est ni affilié ni approuvé par Listen Notes, Inc.
MODIFIER
Merci de nous avoir aidé à tenir la base de données de podcasts à jour.