PLAN ADVICE IN POSTGRESQL 19

Summary from the TLDR Data newsletter

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.