Name: Beyond Joins and Indexes
Start: 2023-01-09T19:00:00-05:00
End: 2023-01-09T20:30:00-05:00
Location: Vector Solutions

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

Stephen Frost

DC PostgreSQL Users Group

PostgreSQL

LiveSafe

The United States PostgreSQL Association (PgUS) sponsors this meetup.

United States PostgreSQL Association

Technology

Database Development

Database Professionals

Data Management

Big Data

Data Mining

Business Intelligence

Web Analytics

Open Source

Bruce Momjian is co-founder and core team member of the PostgreSQL Global Development Group, and has worked on PostgreSQL since 1996. He has been employed by EDB since 2006. He has spoken at many international open-source conferences and is the author of *PostgreSQL: Introduction and Concepts,* published by Addison-Wesley. Prior to his involvement with PostgreSQL, Bruce worked as a consultant, developing custom database applications for some of the world's largest law firms. As an academic, Bruce holds a Masters in Education, an honorary doctorate, was a high school computer science teacher, and lectures internationally.

https://momjian.us/main/resume.html



Bruce Momjian