Explaining the Postgres Query Optimizer
March 27, 2023
11:00am ET
The query optimizer is considered the brain of the Postgres database, interpreting SQL queries and determining the optimal method of execution. In this webinar, Bruce Momjian, Postgres Evangelist will cover how the query optimizer interprets queries using the EXPLAIN command. Join this webinar to better understand how you can improve querying behavior using the optimizer.
This webinar will cover:
Query optimization basics
Optimizer statistics
Join methods
Scan methods, including indexes
EDB
Vice President, Postgres Evangelist
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.
EDB is trusted by top companies everywhere.