Performance Improvements in PostgreSQL9 2
summary
PostgreSQL 9.2 delivers concrete wins: a fast-path lock manager and cache-splitting reduce cache-line thrash and scale nearly linearly to 64 cores on test hardware, WAL piggybacking and parallelism plus group-commit push throughput to about 13,000 commits/s in microbenchmarks, the visibility map crash-safe enables index-only scans that show 5x speedups in one test (up to 700x in others), clog cache grows from 8 to 32 buffers, and perf and pgbench are used to find and fix regressions.
AI-written summary · about
chapters (14)
- 0:00Introduction
- 2:11Performance Improvements
- 8:26Linear Scalability
- 11:35RightConcurrency
- 15:01Other Performance Improvements
- 22:20Index Only Scanning
- 28:02Parametrized Plans
- 31:27Indexing Improvements
- 32:56Query Planner Improvements
- 39:09Sorting Improvements
- 42:10Power Consumption Improvements
- 45:39Other Improvements
- 47:36Lessons Learned
- 50:55Extreme workloads
