What’s new in the Postgres 18 query planner / optimizer | POSETTE: An Event for Postgres 2025 скачать в хорошем качестве

What’s new in the Postgres 18 query planner / optimizer | POSETTE: An Event for Postgres 2025

Video of a conference talk examining how with every PostgreSQL release, the planner (a.k.a query optimizer) evolves and is given the ability to do things that previous versions of PostgreSQL could not do. Often these changes can lead to significant performance increases for certain classes of query. This talk explains what's new in the PostgreSQL 18 query planner. Each change will include an example of how the planner handles things now and how this was handled in previous versions of PostgreSQL. David Rowley has been a PostgreSQL user since 8.2 and working on core PostgreSQL full-time since 9.4. David is a major PostgreSQL contributor and committer working at Microsoft and primarily working on performance optimizations in the query planner and executor. ► Video bookmarks: ⏩ 00:00 Introduction ⏩ 01:07 PostgreSQL 18 feature freeze ⏩ 02:26 Part 1: PostgreSQL 18 query planner’s new abilities ⏩ 02:30 Better OR clause support ⏩ 06:34 Self join elimination ⏩ 09:52 Improved EXCEPT / INTERSECT support ⏩ 13:31 GROUP BY clause optimization ⏩ 16:52 Part 2: General query planner improvements ⏩ 17:00 Lock performance: v17 vs v 18 ⏩ 20:24 Run-time pruning: v17 vs v18 ⏩ 23:29 Planner performance improvements ⏩ 26:07 Other notable changes & testing 📕 Everything you need to know about POSETTE: An Event for Postgres 2025 can be found at: https://posetteconf.com ✅ Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist 📌 Let’s connect:   LinkedIn -   / posetteconf   X – @PosetteConf,   / posetteconf   Mastodon – @posetteconf, https://mastodon.social/@posetteconf Bluesky – @posetteconf.com, https://bsky.app/profile/posetteconf.com Azure Database for Postgres LinkedIn:   / azure-database-for-postgresql   _________________________________ #PosetteConf #PostgreSQL #PostgreSQL18