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: Zsolt Parragi <zsolt.parragi@percona.com>
Cc: David Geier <geidav.pg@gmail.com>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2026-03-02T15:04:28Z
Lists: pgsql-hackers

Attachments

On 2/25/26 16:43, Zsolt Parragi wrote:

> expressions.sql is missing a new line at the end of the file,
> otherwise it looks good to me.

I've fixed this in v5-patch.

Since the C changes are minimal, the patch is relatively small, and no 
further issues were raised, I am moving this patch to "Ready for Committer"

-- 
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