PGCon2010 - Final Release II

PGCon 2010
The PostgreSQL Conference

Robert Haas
Day Talks - 1 - 2010-05-20
Room DMS 1150
Start time 16:30
Duration 01:00
ID 208
Event type Lecture
Track Performance
Language used for presentation English

The PostgreSQL Query Planner

Why does my query need a plan? Sequential scan vs. index scan. Join strategies. Join reordering. Using EXPLAIN. Row count and cost estimation.

Things the query planner doesn't understand. Things that are nearly always slow. Redesigning your schema. Upcoming features and future work.