The PostgreSQL Query Planner

Talk Type: 

90 Minute Mini-tutorial

Technical Level: 
Creative Commons - Attribution Only

Why does my query need a plan? Sequential scan vs. index scan. Join strategies. Join reordering. Joins you can't reorder. Join removal. Aggregates and DISTINCT. Using EXPLAIN. Row count and cost estimation. Things the query planner doesn't understand. Parameters you can tune. Things that are nearly always slow. Upcoming features and future work.

The PostgreSQL Query Planner - Drexel.odp121.13 KB