Re: Reduce LEFT/FULL JOIN to ANTI JOIN in more cases

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: wenhui qiu <qiuwenhuifx(at)gmail(dot)com>
Cc: Isaac Morland <isaac(dot)morland(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Reduce LEFT/FULL JOIN to ANTI JOIN in more cases
Date: 2026-08-19 01:41:59
Message-ID: CAMbWs48yEAfk+G1jSjRxv8U1aqK=mPEqb-j6Z--V31v2KkNjCw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Aug 18, 2026 at 5:40 PM wenhui qiu <qiuwenhuifx(at)gmail(dot)com> wrote:
>> Thank you for updating the path. The test went well. LGTM

Thanks! Pushed.

Isaac, this should also address your complaint that a whole-row IS
NULL test performs worse than the equivalent per-column one.

- Richard

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Chao Li 2026-08-19 02:18:53 Re: Fix a relcache reference leak in reorderbuffer.c
Previous Message Xuneng Zhou 2026-08-19 01:34:23 Re: [Patch] Make ginInsertCleanup follow vacuum's BufferAccessStrategy