Boosting Typical Query Patterns: PostgreSQL 18's Performance Enhancements
summary
PostgreSQL 18 introduces concrete, measurable gains: async IO workers default 3 and allow batching multiple page reads so sequential scans improve ~15–25% and some VACUUM runs jump up to 300% faster; skip scan uses multicolumn index as subindexes to avoid full scans for occasional filters; optimizer removes redundant self‑joins and shows a case with self‑join elimination gives 5x speedup; UUIDv7 improves locality with UUIDv7 yields 23% smaller index; parallel GIN builds and richer EXPLAIN buffers round out practical wins.
AI-written summary · about
chapters (12)
- 0:00Introduction and speaker intro
- 4:59PostgreSQL 18 performance overview
- 6:03Async IO improvements
- 17:41Skip scan feature
- 22:13Parallel GIN index builds
- 25:06Optimizer enhancements
- 35:00EXPLAIN improvements
- 37:28UUID v7 benefits
- 40:20Statistics migration tools
- 41:03Real-world benchmark results
- 43:33Key takeaways and summary
- 45:23Q&A session
related talks
19mVacuuming Enhancements in PostgreSQL 18: Faster, Smarter, More Predictable
50mImproving Postgres' Efficiency
26mPostgreSQL 17 vs 18: Side‑by‑Side Performance Wins in Real‑World Queries
25mPostgreSQL performance tips you have never seen before
25mScaling PostgreSQL Beyond Query Optimization
34mPostgres 10, Performance, and You
56mPerformance Improvements in PostgreSQL9 2
17mThe Evolution of Postgres Performance