Re: pg_plan_advice

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Wed, Mar 18, 2026 at 4:44 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> It looks like the appearance of "Supplied Plan Advice:" depends
>> on whether the prepared query's plan got regenerated or not.
>> I'm not sure if this represents a bug (ie undesirable behavior) or
>> it's just that the test is being insufficiently careful about
>> being reproducible.

> Well, that's embarrassing: it's a copy-and-paste error. The test
> prepares and executes pt1, then prepares and executes pt2, then
> prepares pt3 and executes pt1, then prepares pt4 and execute p2. pt3
> and pt4 are never used for anything. Also there's a related typo in a
> comment. See attached.

Ah ... so the observed behavior is because if pt2 does get replanned,
that happens with a different always_store_advice_details setting
than it used originally?

regards, tom lane