Re: Reduce planning time for large NOT IN lists containing NULL

From: Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>
To: David Geier <geidav(dot)pg(at)gmail(dot)com>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Reduce planning time for large NOT IN lists containing NULL
Date: 2026-02-20 13:28:57
Message-ID: dd5e91c1-5e59-471c-bd9d-96a11c7928f4@tantorlabs.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2/20/26 16:25, Ilia Evdokimov wrote:

> I've moved the NULL check higher, placing it immediately after
> DatumGetArrayTypeP(). This allows us to detect the presence of NULL
> elements before decontructing the array.
>
Sorry, I forgot to attach the patch in my previous mail. Attaching it now.

--
Best regards.
Ilia Evdokimov,
Tantor Labs LLC,
https://tantorlabs.com/

Attachment Content-Type Size
v3-0001-Reduce-planning-time-for-large-NOT-IN-lists-conta.patch text/x-patch 1.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2026-02-20 13:37:48 Re: POC: make mxidoff 64 bits
Previous Message Ilia Evdokimov 2026-02-20 13:25:24 Re: Reduce planning time for large NOT IN lists containing NULL