Re: pg_plan_advice

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>

To: Matheus Alcantara <matheusssilv97@gmail.com>

Cc: Jakub Wartak <jakub.wartak@enterprisedb.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-11-18T16:19:24Z

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

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

Here's v4. This version has some bug fixes and test case changes to
0005 and 0006, with the goal of getting CI to pass cleanly (which it
now does for me, but let's see if cfbot agrees).

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