Hacking the Query Planner

Tom Lane Red Hat PGCon 2011 1 Hacking the Query Planner Why this talk? One thing I could really use is an overview of what order things get done in the planner. What are the major phases of processing and what's the function of each one? ― R. Haas 2 Agenda • What’s the problem we need to solve? • Structure of the planner • Some key data structures • Cost estimation • Future work 3 Overall backend