Horton

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

Richard Guo <guofenglinux@gmail.com>

View thread View on postgr.es
From: Richard Guo <guofenglinux@gmail.com>
To: Pg Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-03-04T09:52:07Z
Lists: pgsql-hackers

Attachments

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

Commits

  1. Convert NOT IN sublinks to anti-joins when safe