PGCon2010 - Final Release III
PGCon 2010
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Robert Haas |
| Schedule | |
|---|---|
| Day | Talks - 1 - 2010-05-20 |
| Room | DMS 1150 |
| Start time | 16:30 |
| Duration | 01:00 |
| Info | |
| 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.