PGCon2013 - Final Release

PGCon 2013
The PostgreSQL Conference

Robert Haas
Day Talks - Day 1 - 2013-05-23
Room MNT 202
Start time 15:00
Duration 01:00
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.