doc: Note that plan advice does not affect cached plans Plan advice is consulted only at plan time. When a cached plan is re-executed, no re-planning occurs, so updated advice has no effect. DISCARD PLANS can be used to discard cached plans, but only affects the sessions in which it is executed.
Reported-by: Noah Misch <[email protected]> Suggested-by: Jakub Wartak <[email protected]> Discussion: https://postgr.es/m/[email protected] Co-authored-by: Dongpo Liu <[email protected]> Co-authored-by: Robert Haas <[email protected]> Backpatch-through: 19 Branch ------ REL_19_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/a69ac3559823a81fb9b16aa77db450617ff80f14 Modified Files -------------- doc/src/sgml/pgplanadvice.sgml | 12 ++++++++++++ doc/src/sgml/pgstashadvice.sgml | 8 ++++++++ 2 files changed, 20 insertions(+)
