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/