
Scaling Postgres Episode 216 PG 15 Beta 1 Release, Query Breakdown, Sort Performance, Prepared vs. Partitioned
Get New Episodes Weekly!
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.
Content Discussed
- PostgreSQL 15 Beta 1 Released!
- Postgres Query Optimization: LEFT JOIN vs UNION ALL
- Speeding up sort performance in Postgres 15
- Postgres: on performance of prepared statements with partitioning
- 5mins of Postgres E18: Partition pruning, prepared statements and generic vs custom query plans
- Solving PostgreSQL's planner issues due to statistics missing chunks
- Unfinished Business with Postgres
- Adventures in collating text in Linux, Docker and Postgres
- My experience with exporting Postgres RDS partitioned tables to s3
- Instant Heatmap with pg_featureserv
- Haki Benita