Monday, June 7, 2021 - 4:30pm to 5:30pm
Location:Virtual Presentation - ET Remote Access - Zoom
Speaker:ROBERT HAAS, Vice Presidet an Chief Databsae Architect https://www.enterprisedb.com/robert-m-haas
PostgreSQL Optimizer Methodology
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.
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.
This talk is part of the Vaccination Database Tech Talk Seminar Series.
Zoom Participation. See announcement.