Article Source

• PostgreSQL Optimizer Methodology

PostgreSQL Optimizer Methodology

• Event Date: Monday June 7, 2021
• Event Time: 04:30pm EDT
• Speaker: Robert Haas [INFO]
• Title: PostgreSQL Optimizer Methodology

Abstract

In this talk, I’ll talk at a high level about how the PostgreSQL query planner approaches join planning, and how it gathers and uses statistics. Without losing sight of the fact that these algorithms generally work, I want to highlight some of the annoying cases where they break down, and the problems that they can cause for users and developers.

This talk is part of the Vaccination Database Tech Talk Seminar Series.

Bio

Robert Haas has been hacking on PostgreSQL since 2008, and using it since 2000. PostgreSQL features which he has authored or coauthored include unlogged tables, fast-path locking, index-only scans, and parallel query. PostgreSQL features written by others which he has reviewed and committed include table partitioning, logical decoding, event triggers, and foreign tables.