Scaling Postgres

In this episode of Scaling Postgres, we discuss the Beta 1 release of Postgres 15, optimizing a query by breaking it down, improvements to sort performance and prepared statements for partitioned tables. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/postgresql-15-beta-1-released-2453/ https://www.crunchydata.com/blog/postgres-query-optimization-left-join-vs-union-all https://www.citusdata.com/blog/2022/05/19/speeding-up-sort-performance-in-postgres-15/ https://amitlan.com/2022/05/16/param-query-partition-woes.html https://pganalyze.com/blog/5mins-postgres-partition-pruning-prepared-statements-generic-vs-custom-query-plans https://www.ongres.com/blog/solving-postgresql-statistic-corruption/ https://www.craigkerstiens.com/2022/05/18/unfinished-business-with-postgres/ https://ptc-it.de/collate-docker-postgres-bug/ https://geopet85.github.io/2022/05/15/rds-partitioned-tables-export.html https://www.crunchydata.c