Request a Demo
Home   >   mailing lists

Re: Convert NOT IN sublinks to anti-joins when safe - Mailing list pgsql-hackers

From Richard Guo
Subject Re: Convert NOT IN sublinks to anti-joins when safe
Date
Msg-id CAMbWs4_g4+Vc1oKgoTMfo=sEw5h4seMQyC5m1Wx23Kpy21gvHg@mail.gmail.com
Whole thread
In response to Re: Convert NOT IN sublinks to anti-joins when safe  (Richard Guo <guofenglinux@gmail.com>)
List pgsql-hackers
Tree view 
On Sat, Feb 14, 2026 at 4:37 PM Richard Guo <guofenglinux@gmail.com> wrote:
> On Thu, Feb 5, 2026 at 3:51 PM Richard Guo <guofenglinux@gmail.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.

Attached is another updated patch rebased on current master, with some
minor cosmetic adjustments; nothing essential has changed.

- Richard
Attachment

pgsql-hackers by date:

Previous
From: Jakub Wartak
Date:
Subject: Re: pg_plan_advice (now with transparent SQL plan performance overrides - pg_stash_advice)
Next
From: Nitin Motiani
Date:
Subject: Re: Adding pg_dump flag for parallel export to pipes