Vaccination Database Seminar

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.

Event Website:

https://db.cs.cmu.edu/seminar2021/

For More Information, Contact:

Keywords:

Seminar Series