The PostgreSQL Query Planner
Talk Type:
90 Minute Mini-tutorial
Technical Level:
Intermediate
License:
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.
Attachment | Size |
---|---|
The PostgreSQL Query Planner - Drexel.odp | 121.13 KB |