Episode 224 Column Performance, BRIN Win, Unique and Null, Parallel Distinct

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <ul> <li><a href= "https://www.cybertec-postgresql.com/en/column-order-in-postgresql-does-matter/"> https://www.cybertec-postgresql.com/en/column-order-in-postgresql-does-matter/</a></li> <li><a href= "https://www.crunchydata.com/blog/postgres-indexing-when-does-brin-win"> https://www.crunchydata.com/blog/postgres-indexing-when-does-brin-win</a></li> <li><a href= "https://blog.rustprooflabs.com/2022/07/postgres-15-unique-improvement-with-null"> https://blog.rustprooflabs.com/2022/07/postgres-15-unique-improvement-with-null</a></li> <li><a href= "https://www.percona.com/blog/introducing-postgresql-15-working-with-distinct/"> https://www.percona.com/blog/introducing-postgresql-15-working-with-distinct/</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-unique-constraint-null-parallel-distinct"> https://pganalyze.com/blog/5mins-postgres-unique-constraint-null-parallel-distinct</a></li> <li><a href= "https://postgrespro.com/blog/pgsql/5969637">https://postgrespro.com/blog/pgsql/5969637</a></li> <li><a href= "https://coroot.com/blog/pg-agent">https://coroot.com/blog/pg-agent</a></li> <li><a href= "https://www.timescale.com/blog/state-of-postgresql-how-to-contribute-to-postgresql-and-the-community/"> https://www.timescale.com/blog/state-of-postgresql-how-to-contribute-to-postgresql-and-the-community/</a></li> <li><a href= "https://shekhargulati.com/2022/07/08/my-notes-on-gitlabs-postgres-schema-design/"> https://shekhargulati.com/2022/07/08/my-notes-on-gitlabs-postgres-schema-design/</a></li> <li><a href= "https://pgstef.github.io/2022/07/12/patroni_and_pgbackrest_combined.html"> https://pgstef.github.io/2022/07/12/patroni_and_pgbackrest_combined.html</a></li> <li><a hre