Re: pg_plan_advice

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>

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

Date: 2025-12-11T15:09:47Z

Lists: pgsql-hackers

Attachments

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

On Fri, Dec 5, 2025 at 2:57 PM Robert Haas <robertmhaas@gmail.com> wrote:
> 014f9a831a320666bf2195949f41710f970c54ad removes the need for what was
> previously 0004, so here is a new patch series with that dropped, to
> avoid confusing cfbot or human reviewers.

Here's v6, with minor improvements over v5.

0001: Unchanged.

0002, 0003: Unchanged except for typo fixes pointed out by reviewers.

0004: I've improved the hook placement, which was previously such as
to make correct unique-semijoin handling impossible, and I improved
the associated comment about how to use the hook, based on experience
trying to actually do so.

0005: Fixed a small bug related to unique-semijoin handling (other
problems remain). Tidied things up to avoid producing non-actionable
NO_GATHER() advice in a number of cases, per some off-list feedback
from Ajaykumar Pal.

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