Horton

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

Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>

View thread View on postgr.es
From: Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
To: David Geier <geidav.pg@gmail.com>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2026-02-20T13:28:57Z
Lists: pgsql-hackers

Attachments

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/

Commits

  1. Short-circuit row estimation in NOT IN containing NULL consts

  2. Move planner row-estimation tests to new planner_est.sql