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-02-14T07:37:11Z
Lists: pgsql-hackers

Attachments

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.

- Richard

Commits

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