Episode
Beyond Joins and Indexes
with Bruce Momjian
Video of a conference talk on the Postgres Query Optimizer by Bruce Momjian at POSETTE: An Event for Postgres 2024. Bruce's presentation Explaining the Postgres Query Optimizer covers the details of query optimization, optimizer statistics, joins, and indexes. This talk covers 42 other operations the optimizer can choose to handle complex queries, large data sets, and to enhance performance. These include merge append, gather, memoize, and hash aggregate. It explains their purpose and shows queries that can generate these operations.
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.
Chapters
- 00:00 - Intro
- 01:23 - What will be covered (numbered list)
- 03:03 - #1-3 Result ... Function Scan
- 04:01 - #4-7 Incremental Sort ... Merge Append
- 07:02 - #8-10 Subquery Scan ... SetOp
- 08:39 - #11-12 Materialize .. Memoize
- 12:26 - #13-18 Group ... WindowAgg
- 15:13 - #19-26 Parallel Seq Scan ... Parallel Hash Join
- 19:58 - #27-29 CTE Scan ... Recursive Union
- 21:54 - #30-35 ProjectSet ... Tid Scan
- 23:13 - #36-39 Insert ... Merge
- 23:53 - #40-42 Semi Join ... SubPlan
- 25:25 - #43 Others
- 25:49 - Conclusion
Recommended resources
Related episodes
Connect
Video of a conference talk on the Postgres Query Optimizer by Bruce Momjian at POSETTE: An Event for Postgres 2024. Bruce's presentation Explaining the Postgres Query Optimizer covers the details of query optimization, optimizer statistics, joins, and indexes. This talk covers 42 other operations the optimizer can choose to handle complex queries, large data sets, and to enhance performance. These include merge append, gather, memoize, and hash aggregate. It explains their purpose and shows queries that can generate these operations.
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.
Chapters
- 00:00 - Intro
- 01:23 - What will be covered (numbered list)
- 03:03 - #1-3 Result ... Function Scan
- 04:01 - #4-7 Incremental Sort ... Merge Append
- 07:02 - #8-10 Subquery Scan ... SetOp
- 08:39 - #11-12 Materialize .. Memoize
- 12:26 - #13-18 Group ... WindowAgg
- 15:13 - #19-26 Parallel Seq Scan ... Parallel Hash Join
- 19:58 - #27-29 CTE Scan ... Recursive Union
- 21:54 - #30-35 ProjectSet ... Tid Scan
- 23:13 - #36-39 Insert ... Merge
- 23:53 - #40-42 Semi Join ... SubPlan
- 25:25 - #43 Others
- 25:49 - Conclusion
Recommended resources
Related episodes
Connect
มีคำติชมหรือไม่? ส่งปัญหาที่เกิดขึ้นได้ที่นี่