Query Planning Gone Wrong
Channel: Andrea Ross
Date: 2013-08-19

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.