Re: pg_plan_advice - Mailing list pgsql-hackers

From Jacob Champion
Subject Re: pg_plan_advice
Date
Msg-id CAOYmi+ku2LPuXWDpnQDgGcFyh86RC1awqg8+pOpiuqHzf4xGvA@mail.gmail.com
Whole thread Raw
In response to Re: pg_plan_advice  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: pg_plan_advice
List pgsql-hackers
On Mon, Dec 15, 2025 at 12:06 PM Robert Haas <robertmhaas@gmail.com> wrote:
> - Add gather((d d/d.d)) test case, per Jacob, and fix the related bug
> in pgpa_identifier_matches_target, per Jacob's email.

I think this fix affected the ability to omit the partition schema in
advice strings. Attached is a quick test that shows it on my machine,
plus an attempted fix that mashes together the v6 and v7 approaches.
(I have diffs in my generated plan advice compared to what's in
v7-0005, so I'm not sure if my .out file is correct.)

--Jacob

Attachment

pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: improve performance of pg_dump with many sequences
Next
From: Robert Treat
Date:
Subject: Re: DOC: fixes multiple errors in alter table doc