Schedule - PGDay Chicago 2024

Beyond Joins and Indexes

Date: 2024-04-26
Time: 15:30–16:15
Room: Forum
Level: Intermediate

My presentation "Explaining the Postgres Query Optimizer" covers the details of query optimization, optimizer statistics, joins, and indexes. This talk covers 40 other operations the optimizer can choose to handle complex queries, large data sets, and to enhance performance. These include merge append, gather, memoize, and hash aggregate. It explains their purpose and shows queries that can generate these operations.


Bruce Momjian