Beyond Joins and Indexes

My previous presentation "Explaining the Postgres Query Optimizer" covered 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 enhanced performance. These include merge append, gather, memoize, and hash aggregate. It explains their purpose and shows queries that can generate these operations.

Agenda:
6:30 - Drinks and Networking
7 - Introduction
7:05 - Talks
8:30 - Wrap up/shut down