Explaining the Postgres Query Optimizer

Dive into the inner workings of the PostgreSQL query optimizer in this 29-minute conference talk from Citus Con: An Event for Postgres 2022. Explore how the "brain" of the database interprets queries and determines optimal execution methods using the EXPLAIN command. Gain valuable insights into scan methods, join techniques, and query optimization strategies to enhance database performance. Learn from PostgreSQL expert Bruce Momjian as he breaks down complex concepts and provides practical examples. Discover how to better understand and potentially improve query execution in your Postgres databases. Includes a Q&A session with additional insights from Bruce and Marco.

Introduction.
What is the query optimizer?.
Choices the query optimizer needs to make.
Scan methods: sequential, bitmap index, & index.
Join methods & join order.
Conclusion.
Q&A with Bruce & Marco .