PGCon2013 - Final Release
PGCon 2013
The PostgreSQL Conference
Speakers | |
---|---|
![]() |
Robert Haas |
Schedule | |
---|---|
Day | Talks - Day 1 - 2013-05-23 |
Room | MNT 202 |
Start time | 15:00 |
Duration | 01:00 |
Info | |
ID | 557 |
Event type | Lecture |
Track | Performance |
Language used for presentation | English |
Query Planning Gone Wrong
An analysis of common query planner failure modes

The PostgreSQL query planner does an excellent job with most queries, but no query planner is perfect.
In this talk, I'll analyze some of the commonly-reported cases where it fails to produce an acceptable plan, based on posts to pgsql-performance and other cases I've encountered on the job.