PGCon2011 - Add 4 Video (2015.09.18)

PGCon 2011
The PostgreSQL Conference

Tom Lane
Day Talks - 1 - 2011-05-19
Room DMS 1120
Start time 16:30
Duration 01:00
ID 350
Event type Lecture
Track Hacking
Language used for presentation English

Hacking the Query Planner

What does the planner do and why does it do it? How can it be improved?

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.