| From: | Jacob Champion <jacob(dot)champion(at)enterprisedb(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Dian Fay <di(at)nmfay(dot)com>, Matheus Alcantara <matheusssilv97(at)gmail(dot)com>, Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: pg_plan_advice |
| Date: | 2026-01-07 23:11:24 |
| Message-ID: | CAOYmi+ku2LPuXWDpnQDgGcFyh86RC1awqg8+pOpiuqHzf4xGvA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Dec 15, 2025 at 12:06 PM Robert Haas <robertmhaas(at)gmail(dot)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 | Content-Type | Size |
|---|---|---|
| partnsp.diff.txt | text/plain | 8.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2026-01-07 23:13:33 | Re: DOC: fixes multiple errors in alter table doc |
| Previous Message | Nathan Bossart | 2026-01-07 23:06:22 | Re: improve performance of pg_dump with many sequences |