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_and_pgbackrest_combined.html
• https://postgresql.life/post/charly_batista/
• https://www.rubberduckdevshow.com/episodes/50-brittany-martin-ruby-on-rails-podcast/