Re: pg_plan_advice

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>

To: Jakub Wartak <jakub.wartak@enterprisedb.com>

Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-11-06T16:45:47Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Add pg_plan_advice contrib module.
- 5883ff30b02c 19 (unreleased) landed
Store information about Append node consolidation in the final plan.
- 7358abcc6076 19 (unreleased) landed
Store information about elided nodes in the final plan.
- 0d4391b265f8 19 (unreleased) landed
Store information about range-table flattening in the final plan.
- adbad833f3d9 19 (unreleased) landed
Allow for plugin control over path generation strategies.
- 4020b370f214 19 (unreleased) landed
Allow passing a pointer to GetNamedDSMSegment()'s init callback.
- 48d4a1423d2e 19 (unreleased) cited
Don't reset the pathlist of partitioned joinrels.
- 014f9a831a32 19 (unreleased) cited

Attachments

v3-0005-Allow-for-plugin-control-over-path-generation-str.patch (application/octet-stream) patch v3-0005
v3-0002-Store-information-about-elided-nodes-in-the-final.patch (application/octet-stream) patch v3-0002
v3-0001-Store-information-about-range-table-flattening-in.patch (application/octet-stream) patch v3-0001
v3-0004-Temporary-hack-to-unbreak-partitionwise-join-cont.patch (application/octet-stream) patch v3-0004
v3-0003-Store-information-about-Append-node-consolidation.patch (application/octet-stream) patch v3-0003
v3-0006-WIP-Add-pg_plan_advice-contrib-module.patch (application/octet-stream) patch v3-0006

Here's v3. I've attempted to fix some more things that cfbot didn't
like, one of which was an actual bug in 0005, and I also fixed a
stupid few bugs in pgpa_collector.c and added a few more tests.

-- 
Robert Haas
EDB: http://www.enterprisedb.com