Waiting for Postgres 19: Enhanced Planner Hints with Path Generation Strategies

Hacker News

In today’s E121 of “5mins of Postgres” we're talking about the upcoming Postgres 19 release, and how better extensibility of the Postgres planner will enable better plan management and planner hint extensions. We dive into the recently committed "path generation strategies" change, the proposed pg_plan_advice extension it was developed for, and show how can evolve and lose 2,500 lines of code! Find the full transcript and references here: https://pganalyze.com/blog/5mins-postgres-19-better-pla