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.com/blog/instant-heatmap-with-pg_featureserv
• https://postgresql.life/post/haki_benita/