pg_plan_advice

Edit
ID 6184
Title pg_plan_advice
CI (CFBot) Summary
Stats (from CFBot) Patch version: v26, Patch count: 5, First patch: +75−73, All patches: +424−122
Tags Extensions Missing Docs
Created 2025-10-30 14:55:36
Last modified 2026-04-14 12:13:47 (yesterday)
Latest email 2026-04-15 10:30:01 (5 hours ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Committed
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
Target version
Authors Robert Haas (rhaas)
Reviewers Become reviewer
Committer Robert Haas (rhaas)
Links
Emails
pg_plan_advice
First at 2025-10-30 14:00:05 by Robert Haas <robertmhaas at gmail.com>
Latest at 2026-04-15 10:30:01 by Tender Wang <tndrwang at gmail.com>
Latest attachment (v26-0001-pg_plan_advice-Export-feedback-related-definitio.patch) at 2026-04-07 21:21:19 from Robert Haas <robertmhaas at gmail.com>
    Attachment (v26-0001-pg_plan_advice-Export-feedback-related-definitio.patch) at 2026-04-07 21:21:19 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Add-pg_stash_advice-contrib-module.patch) at 2026-04-03 02:15:36 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v24-0002-pg_stash_advice-Allow-stashed-advice-to-be-persi.patch) at 2026-04-02 16:15:09 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (nocfbot-3-0001-Use-GetNamedDSA-GetNamedDSHash-for-shared.patch) at 2026-04-01 06:33:50 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (vnocfbot-2-0001-Make-pg_stash_advice-dump-advice-to-disk-.patch) at 2026-04-01 02:25:04 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (nocfbot-0001-Make-pg_stash_advice-dump-advice-to-disk-wh.patch) at 2026-03-29 18:58:39 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (0001-pg_plan_advice-Avoid-assertion-failure-with-partitio.ncfbot) at 2026-03-27 12:55:41 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v23-0003-Add-pg_collect_advice-contrib-module.patch) at 2026-03-26 17:20:21 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v22-0003-Add-an-alternative_root-field-to-PlannerInfo.patch) at 2026-03-24 21:09:51 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v1-0001-get_memoize_path-Don-t-exit-quickly-when-PGS_NEST.nocfbot) at 2026-03-19 20:38:23 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v1-0001-pg_plan_advice-Fix-multiple-copy-and-paste-errors.nocfbot) at 2026-03-18 22:19:31 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v21-0002-Add-pg_stash_advice-contrib-module.patch) at 2026-03-17 21:45:52 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (0001-pg_plan_advice-Avoid-a-crash-under-GEQO.nocfbot) at 2026-03-16 17:11:16 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-pg_plan_advice-header-install-discrepancy-betwee.patch) at 2026-03-14 15:06:04 from Zsolt Parragi <zsolt.parragi at percona.com> (Patch: Yes)
    Attachment (nocfbot-0002-pg_plan_advice-Allow-targeting-scans-by-partition-pa.patch) at 2026-03-13 08:38:25 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v20-0002-Test-pg_plan_advice-using-a-new-test_plan_advice.patch) at 2026-03-12 17:15:39 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v19-0004-Add-pg_stash_advice-contrib-module.patch) at 2026-03-10 14:55:26 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (nocfbot-v18-0007-pgstashadvice-sgml.diff) at 2026-03-02 23:11:17 from "David G. Johnston" <david.g.johnston at gmail.com> (Patch: Yes)
    Attachment (nocfbot-v18-0004-pgcollectadvice-sgml.diff) at 2026-03-02 22:09:12 from "David G. Johnston" <david.g.johnston at gmail.com> (Patch: Yes)
    Attachment (nocfbot-v18-0003-pg_plan_advice-sgml.diff) at 2026-03-02 04:10:52 from "David G. Johnston" <david.g.johnston at gmail.com> (Patch: Yes)
    Attachment (nocfbot-v18-0003-Readme.diff) at 2026-02-28 01:16:10 from "David G. Johnston" <david.g.johnston at gmail.com> (Patch: Yes)
    Attachment (v18-0002-Replace-get_relation_info_hook-with-build_simple.patch) at 2026-02-27 22:46:21 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v17-0002-Replace-get_relation_info_hook-with-build_simple.patch) at 2026-02-19 19:46:38 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v16-0002-Replace-get_relation_info_hook-with-build_simple.patch) at 2026-02-18 19:57:58 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v15-0003-Fix-add_partial_path-interaction-with-disabled_n.patch) at 2026-02-10 23:03:34 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v14-0004-Store-information-about-elided-nodes-in-the-fina.patch) at 2026-02-07 17:37:56 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (fix-materialize_finished_plan-Ensure-dummy-matpath-is-fu.nocf) at 2026-01-29 05:44:26 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (nocfbot-Docs-review.patch) at 2026-01-29 04:58:26 from "David G. Johnston" <david.g.johnston at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Store-information-about-range-table-flattening-i.patch) at 2026-01-28 17:13:39 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v12-0004-Store-information-about-Append-node-consolidatio.patch) at 2026-01-26 16:07:55 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v11-0002-Store-information-about-range-table-flattening-i.patch) at 2026-01-21 19:26:02 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (too-much-nesting.patch.nocfbot) at 2026-01-19 18:59:28 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (typedef_enum_pgsscantype.h.txt) at 2026-01-19 10:53:38 from Jakub Wartak <jakub.wartak at enterprisedb.com> (Patch: Yes)
    Attachment (v10-0001-Store-information-about-range-table-flattening-i.patch) at 2026-01-15 14:40:49 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (q4_errors_hard_without_stats_and_no_parallel_v2.txt) at 2026-01-15 12:28:30 from Jakub Wartak <jakub.wartak at enterprisedb.com> (Patch: No)
    Attachment (q4_errors_hard_without_stats.txt) at 2026-01-14 11:02:11 from Jakub Wartak <jakub.wartak at enterprisedb.com> (Patch: No)
    Attachment (join-missing-partition.diff.txt) at 2026-01-13 18:48:36 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (fasthash-zero-len.patch.nocfbot) at 2026-01-13 11:38:51 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (v9-0003-Store-information-about-Append-node-consolidation.patch) at 2026-01-12 17:13:32 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (alternate-v8-0003-changes.nocf) at 2026-01-11 20:20:32 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (unrolled_join.diff.txt) at 2026-01-08 20:58:54 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Store-information-about-range-table-flattening-in.patch) at 2026-01-08 18:21:35 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (partnsp.diff.txt) at 2026-01-07 23:11:24 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (v7-0001-Store-information-about-range-table-flattening-in.patch) at 2025-12-15 20:06:08 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (regress-crash.diff.txt) at 2025-12-15 16:37:43 from Jacob Champion <jacob.champion at enterprisedb.com> (Patch: Yes)
    Attachment (v6-0002-Store-information-about-elided-nodes-in-the-final.patch) at 2025-12-11 15:09:47 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Store-information-about-range-table-flattening-in.patch) at 2025-12-05 19:57:09 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (rls-demo-item-tags.sql) at 2025-11-23 00:43:40 from "Dian Fay" <di at nmfay.com> (Patch: No)
    Attachment (v4-0001-Store-information-about-range-table-flattening-in.patch) at 2025-11-18 16:19:24 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v3-0005-Allow-for-plugin-control-over-path-generation-str.patch) at 2025-11-06 16:45:47 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v2-0005-Allow-for-plugin-control-over-path-generation-str.patch) at 2025-11-04 19:54:44 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (0001-fixup-supress-some-gcc-warnings.txt) at 2025-10-31 09:58:59 from Jakub Wartak <jakub.wartak at enterprisedb.com> (Patch: Yes)
    Attachment (v1-0005-Allow-for-plugin-control-over-path-generation-str.patch) at 2025-10-30 14:00:05 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
History
When Who What
2026-04-14 12:13:47 Robert Haas (rhaas) Closed in commitfest PG20-1 with status: Committed
2026-04-14 12:13:47 Robert Haas (rhaas) Changed committer to rhaas
2026-04-10 00:00:04 CFbot Moved from CF PG19-Final to CF PG20-1
2026-04-07 21:34:41 CFbot Patch does not need rebase anymore
2026-04-07 05:16:28 CFbot Patch needs rebase
2026-04-02 16:32:50 CFbot Patch does not need rebase anymore
2026-03-28 08:08:32 CFbot Patch needs rebase
2026-03-10 15:02:41 CFbot Patch does not need rebase anymore
2026-03-09 14:05:36 CFbot Patch needs rebase
2026-03-07 17:25:40 CFbot Patch does not need rebase anymore
2026-03-05 22:18:32 CFbot Patch needs rebase
2026-02-18 20:06:35 CFbot Patch does not need rebase anymore
2026-02-18 06:21:26 CFbot Patch needs rebase
2026-01-15 15:03:35 CFbot Patch does not need rebase anymore
2026-01-14 06:27:24 CFbot Patch needs rebase
2026-01-06 14:58:27 Robert Haas (rhaas) Moved from CF PG19-3 to CF PG19-Final
2025-12-05 04:21:32 CFbot Patch does not need rebase anymore
2025-12-03 00:18:28 CFbot Patch needs rebase
2025-10-30 14:55:36 Robert Haas (rhaas) Attached mail thread CA+TgmoZ-Jh1T6QyWoCODMVQdhTUPYkaZjWztzP1En4=ZHoKPzw@mail.gmail.com
2025-10-30 14:55:36 Robert Haas (rhaas) Created patch record
Edit