A high-level introduction to the query planner in PostgreSQL
Presented by:
Richard Guo
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