Re: Pathify RHS unique-ification for semijoin planning - Mailing list pgsql-hackers

From Richard Guo
Subject Re: Pathify RHS unique-ification for semijoin planning
Date
Msg-id CAMbWs48Oo1U4FytpWzx4N3AJ+5X7nkMCf88qnJEW5s93BQ9dvQ@mail.gmail.com
Whole thread Raw
List pgsql-hackers
On Tue, Jul 1, 2025 at 11:57 AM Richard Guo <guofenglinux@gmail.com> wrote:
> On Tue, Jun 3, 2025 at 4:52 PM Richard Guo <guofenglinux@gmail.com> wrote:
> > Here is an updated version of the patch, which is ready for review.
> > I've fixed a cost estimation issue, improved some comments, and added
> > a commit message.  Nothing essential has changed.

> This patch does not apply anymore, and here is a new rebase.

This patch does not apply again, so here is a new rebase.

This version also fixes an issue related to parameterized paths: if
the RHS has LATERAL references to the LHS, unique-ification becomes
meaningless because the RHS depends on the LHS, and such paths should
not be generated.

Thanks
Richard

Attachment

pgsql-hackers by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: CREATE DOMAIN create two not null constraints
Next
From: Amit Kapila
Date:
Subject: Re: Conflict detection for update_deleted in logical replication