PGCon2011 - Add 4 Video (2015.09.18)

PGCon 2011
The PostgreSQL Conference

Tom Lane
Day Talks - 2 - 2011-05-20
Room DMS 1160
Start time 13:30
Duration 01:00
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.