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-18 08:10:34
Message-ID: CAMbWs4_YuyA2+7pLqqqVu1q7n-B6LxUjx+Gqb5+mSpJARbmQFQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The patchset no longer applies, so here is a rebased version. There
are no changes other than the rebase and some cosmetic tweaks.

I plan to give this another self-review and push it soon, barring
objections.

- Richard

Attachment Content-Type Size
v3-0001-Reduce-LEFT-JOIN-to-ANTI-JOIN-using-quals-within-.patch application/octet-stream 18.3 KB
v3-0002-Reduce-FULL-JOIN-to-ANTI-JOIN.patch application/octet-stream 23.4 KB
v3-0003-Reduce-outer-joins-to-anti-joins-for-whole-row-IS.patch application/octet-stream 17.9 KB
v3-0004-Relax-strictness-detection-for-row-format-IS-NOT-.patch application/octet-stream 8.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2026-08-18 08:34:32 Re: Re-read conindid under the referenced table's lock in the RI fast path
Previous Message Peter Smith 2026-08-18 08:04:12 Re: Support EXCEPT for TABLES IN SCHEMA publications