Episode 216 PG 15 Beta 1 Release, Query Breakdown, Sort Performance, Prepared vs. Partitioned

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <ul> <li><a href= "https://www.postgresql.org/about/news/postgresql-15-beta-1-released-2453/"> https://www.postgresql.org/about/news/postgresql-15-beta-1-released-2453/</a></li> <li><a href= "https://www.crunchydata.com/blog/postgres-query-optimization-left-join-vs-union-all"> https://www.crunchydata.com/blog/postgres-query-optimization-left-join-vs-union-all</a></li> <li><a href= "https://www.citusdata.com/blog/2022/05/19/speeding-up-sort-performance-in-postgres-15/"> https://www.citusdata.com/blog/2022/05/19/speeding-up-sort-performance-in-postgres-15/</a></li> <li><a href= "https://amitlan.com/2022/05/16/param-query-partition-woes.html">https://amitlan.com/2022/05/16/param-query-partition-woes.html</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-partition-pruning-prepared-statements-generic-vs-custom-query-plans"> https://pganalyze.com/blog/5mins-postgres-partition-pruning-prepared-statements-generic-vs-custom-query-plans</a></li> <li><a href= "https://www.ongres.com/blog/solving-postgresql-statistic-corruption/"> https://www.ongres.com/blog/solving-postgresql-statistic-corruption/</a></li> <li><a href= "https://www.craigkerstiens.com/2022/05/18/unfinished-business-with-postgres/"> https://www.craigkerstiens.com/2022/05/18/unfinished-business-with-postgres/</a></li> <li><a href= "https://ptc-it.de/collate-docker-postgres-bug/">https://ptc-it.de/collate-docker-postgres-bug/</a></li> <li><a href= "https://geopet85.github.io/2022/05/15/rds-partitioned-tables-export.html"> https://geopet85.github.io/2022/05/15/rds-partitioned-tables-export.html</a></li> <li><a href= "https://www.crunchydata.com/blog/instant-heatmap-with-pg_featureserv"> https://www.crunchydata.com/blog/instant