Explaining the Postgres Query Optimizer | Citus Con: An Event for Postgres 2022

From the creator

Bruce Momjian explains the PostgreSQL query optimizer in this video of the talk he gave in the Americas livestream at Citus Con: An Event for Postgres. The optimizer is the "brain" of the database, interpreting PostgreSQL queries and determining the fastest method of execution. Bruce’s talk uses the Postgres EXPLAIN command to show how the optimizer interprets queries and determines optimal execution. The talk will assist developers and administrators in understanding how Postgres optimally executes their database queries and what steps they can take to understand and perhaps improve its behavior. 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. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 02:10 What is the query optimizer? ⏩ 03:53 Choices the query optimizer needs to make ⏩ 04:19 Scan methods: sequential, bitmap index, & index ⏩ 12:13 Join methods & join order ⏩ 21:18 Conclusion ⏩ 23:22 Q&A with Bruce

Published 2022-04-26 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.