Explore the inner workings of database query execution and optimization in this 57-minute talk focused on PostgreSQL. Delve into the representation of queries as trees, examine fundamental query optimization techniques, and gain insights into the Postgres query planner. Through practical examples, learn how the planner utilizes statistics, estimates costs, and determines execution plans. Analyze query plans, identify potential issues, and discover strategies to assist the planner in improving performance. Access accompanying slides for a comprehensive understanding of PostgreSQL query planning processes.
Overview
Syllabus
floy: Introduction to Postgres Query Planning
Taught by
media.ccc.de