Re: Pathify RHS unique-ification for semijoin planning

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Pathify RHS unique-ification for semijoin planning
Date: 2025-07-03 10:06:47
Message-ID: CAMbWs48Oo1U4FytpWzx4N3AJ+5X7nkMCf88qnJEW5s93BQ9dvQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jul 1, 2025 at 11:57 AM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> On Tue, Jun 3, 2025 at 4:52 PM Richard Guo <guofenglinux(at)gmail(dot)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 Content-Type Size
v4-0001-Pathify-RHS-unique-ification-for-semijoin-plannin.patch application/octet-stream 106.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Japin Li 2025-07-03 10:19:17 Re: Inconsistent LSN format in pg_waldump output
Previous Message Álvaro Herrera 2025-07-03 09:52:56 Re: CREATE DOMAIN create two not null constraints