Performance Improvements in PostgreSQL 9.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.

In this talk I'll give an overview of what was changed, how it helped, lessons learned, and the challenges that remain.