The PostgreSQL Query Planner
90 Minute Mini-tutorial
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.odp||121.13 KB|