Robert Haas: Performance Improvements in PostgreSQL9 2
The upcoming PostgreSQL 9.2 release features a large number of performance enhancements by many different authors, including heavyweight lock manager improvements, reduced lock hold times in key hot spots, better group commit, index-only scans, better write-ahead log parallelism, sorting improvements, and a userspace AVC for sepgsql.
This talk is an overview of what was changed, how it helped, lessons learned, and the challenges that remain.