PGCon2013 - includes video

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
Feedback

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.