Re: Planner : anti-join on left joins - Mailing list pgsql-hackers

From Richard Guo
Subject Re: Planner : anti-join on left joins
Date
Msg-id CAMbWs498hXYhNyXvOEKiVNDoacFh-NepqErMBGOnkeqFqBxNaQ@mail.gmail.com
Whole thread Raw
In response to Re: Planner : anti-join on left joins  (Richard Guo <guofenglinux@gmail.com>)
Responses Re: Planner : anti-join on left joins
List pgsql-hackers
On Tue, Jan 6, 2026 at 5:23 PM Richard Guo <guofenglinux@gmail.com> wrote:
> The logic 'strict for b.z' effectively applies only if b.z happens to
> be the join key b.y.  To avoid confusion, I have rephrased the comment
> to make this distinction clear.
>
> I've also included a commit message, refined the comments throughout,
> and added test cases in the updated patch.
>
> Feedback and testing are very welcome.

I've pushed this patch.

- Richard



pgsql-hackers by date:

Previous
From: Maxim Orlov
Date:
Subject: Re: Add 64-bit XIDs into PostgreSQL 15
Next
From: Andrey Borodin
Date:
Subject: Re: Streaming replication and WAL archive interactions