Learn more about PostgreSQL and performance tuning with core member Bruce Momjian

This talk is designed for PostgreSQL users who want to maximize performance of their database stack. Topics covered include:

• How the PostgreSQL query optimizer works and makes execution decisions
• How to read and interpret EXPLAIN output to analyze query performance
• The role of optimizer statistics, joins, and indexes in query planning
• Practical techniques to improve query execution and database performance
• Insights into 42 advanced execution operations such as merge append, gather, memoize, and hash aggregate
• How PostgreSQL handles complex queries and large datasets under the hood
• Real-world examples of how different execution strategies impact performance
• Bruce will also provide a short outlook on how PostgreSQL supports AI workloads with features like pgvector.

You’ll gain concrete skills to troubleshoot and improve PostgreSQL performance – from tuning configuration files to rethinking problematic queries.

About

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.

Agenda

14:30 Doors open

15:00 Welcome and introduction

15:15 Bruce Momjian

16:30 Drinks

17:00 End