PGCon2012 - Final Release

PGCon 2012
The PostgreSQL Conference

Robert Haas
Day Talks - 2 - Friday - 2012-05-18
Room MRT 218
Start time 15:00
Duration 01:00
ID 416
Event type Lecture
Track Hacking
Language used for presentation English

Performance Improvements in PostgreSQL 9.2

Bigger servers, bigger problems

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.