Horton

Re: Optimize IS DISTINCT FROM with non-nullable inputs

Richard Guo <guofenglinux@gmail.com>

View thread View on postgr.es
From: Richard Guo <guofenglinux@gmail.com>
To: Tender Wang <tndrwang@gmail.com>
Cc: Pg Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-02-10T02:07:16Z
Lists: pgsql-hackers 
On Mon, Feb 9, 2026 at 4:08 PM Richard Guo <guofenglinux@gmail.com> wrote:
> Thanks for the review.
>
> I plan to push the v3 patchset soon, barring any objections.

... and done.

- Richard

Commits

  1. Teach planner to transform "x IS [NOT] DISTINCT FROM NULL" to a NullTest

  2. Optimize BooleanTest with non-nullable input

  3. Optimize IS DISTINCT FROM with non-nullable inputs