Search


	Podcast:		Scaling Postgres
	Episode:		Episode 224 Column Performance, BRIN Win, Unique and Null, Parallel Distinct
	Category:		Technology
	Duration:		00:13:58
	Publish Date:		2022-07-18 00:14:56
	Description:		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/
	Total Play:		0