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

PostgreSQL 16 introduces quite a few improvements to the query planner and makes many SQL queries run faster than they did on previous versions of PostgreSQL. If you look at the PG16 release notes, you’ll see some of these planner improvements. But with the volume of changes made in each PostgreSQL release, it’s not possible to provide enough detail about each and every change. So maybe you might

[tmatsuu]

PostgreSQL16で改善されるクエリーまとめ。個人的には1と2のようなクエリーはあるあるなので嬉しいのではないかと思いました。