Performance Improvements in PostgreSQL 9.2
log in to bookmark this presentaton
Novice / Talk
September 19th 2:30 p.m. – 3:29 p.m.
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.