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

From Tender Wang
Subject Re: Planner : anti-join on left joins
Date
Msg-id CAHewXNnwrrAPtAJjiNHnhnkcdN+ZfsJHDV0aMxbkgCZxnerM=Q@mail.gmail.com
Whole thread
In response to Re: Planner : anti-join on left joins  (Richard Guo <guofenglinux@gmail.com>)
List pgsql-hackers
Richard Guo <guofenglinux@gmail.com> 于2026年2月12日周四 14:43写道:
>
> 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

Thanks for making this optimization workable and pushing.


--
Thanks,
Tender Wang



pgsql-hackers by date:

Previous
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: BUG: Former primary node might stuck when started as a standby
Next
From: "Zhijie Hou (Fujitsu)"
Date:
Subject: RE: Improve pg_sync_replication_slots() to wait for primary to advance