Presented by:

7d77db0dcd8171371133a72176bc3287

Richard Guo

OpenPie
No video of the event yet, sorry!

This talk will focus on how the planner works from a developer’s view and elaborate on the process of converting a query tree to a plan tree in details.

We can divide the planning process into 4 phases: preprocessing, scan/join planning, post scan/join planning and postprocessing. In this talk, I will explain what stuff is performed in each phase and what is the motivation to perform that. Topics will include: transforming ANY/EXISTS SubLinks into joins, flattening sub-selects, preprocessing expressions, reducing outer joins to inner joins, distributing quals to rels, collecting join ordering restrictions, removing useless joins, join searching process, upper planner path-ification, cost estimation, etc.

Date:
2024 April 17 16:10 PDT
Duration:
50 min
Room:
Almaden
Conference:
Postgres Conference 2024
Language:
English
Track:
Dev
Difficulty:
Intermediate