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.