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

On 2/20/26 12:06, Ilia Evdokimov wrote:

There is already ARR_HASNULL() which allows us to detect the presence of NULL in ArrayType.

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.

I tested this with several queries of the form:

WHERE x NOT IN (NULL, ...)

In my tests (with column x having detailed statistics, so selectivity estimation performs more work), planning time decreases from 5-200 ms before the patch to ~ 1-2 ms after the patch, depending on the list size.

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