Brussels / 3 & 4 February 2024

schedule

Beyond Joins and Indexes


My presentation Explaining the Postgres Query Optimizer covers the details of query optimization, optimizer statistics, joins, and indexes. This talk covers 42 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.

Speakers

Photo of Bruce Momjian Bruce Momjian

Links