Re: Convert NOT IN sublinks to anti-joins when safe

From: Richard Guo <guofenglinux(at)gmail(dot)com>
To: Pg Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Convert NOT IN sublinks to anti-joins when safe
Date: 2026-02-14 07:37:11
Message-ID: CAMbWs4_V2QM=kUR3s3Jq8GVWAaZtouqpqU46GUuUXtCgAzBriA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Feb 5, 2026 at 3:51 PM Richard Guo <guofenglinux(at)gmail(dot)com> wrote:
> Attached is the updated patch, which adds the check requiring the
> operator to be a member of a btree or hash opfamily.

Attached is another updated patch rebased on current master, with the
addition of support for RowCompareExpr to handle multi-column ordering
operations; otherwise unchanged.

- Richard

Attachment Content-Type Size
v3-0001-Convert-NOT-IN-sublinks-to-anti-joins-when-safe.patch application/octet-stream 61.4 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2026-02-14 08:04:44 Re: Having problems generating a code coverage report
Previous Message jian he 2026-02-14 06:55:13 Re: CREATE TABLE LIKE INCLUDING POLICIES