TLDR Tech / Data
Plan Advice in PostgreSQL 19
PostgreSQL 19's pg_plan_advice serializes join order, scan type, join method, and parallelism into replayable plan guidance, while pg_stash_advice applies it by query ID. Structural strings make plan diffs stable enough for CI and upgrades, but selective pinning matters: preserving one proven decision is safer than freezing every choice as data distributions and statistics change.
Read the full story