PGCon2011 - Add 4 Video (2015.09.18)
PGCon 2011
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Tom Lane |
| Schedule | |
|---|---|
| Day | Talks - 2 - 2011-05-20 |
| Room | DMS 1160 |
| Start time | 13:30 |
| Duration | 01:00 |
| Info | |
| ID | 382 |
| Event type | Lecture |
| Track | Hacking |
| Language used for presentation | English |
Hacking the Query Planner II
What does the planner do and why does it do it? How can it be improved? PART II
This is a continuation of Tom's talk from yesterday.
This is a follow-on to Robert Haas's planner talk at PGCon 2010. I plan to focus more on why and how the planner works, ie, present a developer's-eye view instead of a user's-eye view of what it does. Topics will include the overall layout of the planner code, preprocessing, join search order, and cost estimation. Hopefully attendees will come away encouraged to hack on the planner and help improve it.