PGCon2012 - Final Release
PGCon 2012
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Robert Haas |
| Schedule | |
|---|---|
| Day | Talks - 2 - Friday - 2012-05-18 |
| Room | MRT 218 |
| Start time | 15:00 |
| Duration | 01:00 |
| Info | |
| 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.