Solving PostgreSQL Wicked Problems
summary
An extension implements a new table access method that moves old row versions into an undo log, replaces page-lookup metadata with in-tree pointers (anti-buffering), and isolates index updates so write amplification drops dramatically — benchmarks show roughly 3x throughput on index-heavy updates and about 50% gains when bypassing the filesystem to block devices. It runs as a v15-compatible extension on GitHub, avoids regular VACUUM by design, and collects reproducible tests and over a thousand stars while upstream hooks are proposed.
AI-written summary · about
chapters (17)
- 0:00Start
- 1:22ORIOLE
- 1:35ALEXANDER KOROTKOV
- 3:04WHY OPEN-SOURCE...
- 3:45WHY POSTGRES...
- 6:07OPEN-SOURCE POSTORES FORKS
- 9:24UNDO LOGS
- 20:01BUFFER MAPS RE-IMAGINED
- 30:58WRITE-AMPLIFICATION STABLE WRITES. CONSISTENT BANDWIDTH
- 33:57STORAGE EFFICIENCY
- 34:13OPTANE BLOCK STORAGE IOPS IMPROVEMENTS
- 38:23TRACKING POSTGRES
- 39:01UPSTREAM POSTGRES
- 40:04GITHUB REPO
- 40:33EDUCATION
- 41:38SANDBOX PLATFORM
- 43:35BENCHMARKING PLATFORM
related talks
53mFuture of table access methods
50mTame the growth of your database
25mPostgreSQL performance tips you have never seen before
56mPerformance Improvements in PostgreSQL9 2
19mVacuuming Enhancements in PostgreSQL 18: Faster, Smarter, More Predictable
52mBoosting Typical Query Patterns: PostgreSQL 18's Performance Enhancements
43mPostgreSQL 17 and beyond
42mPostgreSQL is Nowhere Near Ready