What’s new in the Postgres 18 query planner / optimizer

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 also shows how this was handled in previous versions of PostgreSQL.