Scaling Postgres

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