Re: Reduce planning time for large NOT IN lists containing NULL
Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
From: Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
To: David Rowley <dgrowleyml@gmail.com>
Cc: Zsolt Parragi <zsolt.parragi@percona.com>,
David Geier <geidav.pg@gmail.com>,
PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2026-03-17T10:50:59Z
Lists: pgsql-hackers
Attachments
- v7-0002-Reduce-planning-time-for-large-NOT-IN-lists-conta.patch (text/x-patch) patch v7-0002
- v7-0001-Move-planner-row-estimation-tests-to-selectivity..patch (text/x-patch) patch v7-0001
Rebased the v7-patches to fix git apply failure. -- Best regards, Ilia Evdokimov, Tantor Labs LLC, https://tantorlabs.com/
Commits
-
Short-circuit row estimation in NOT IN containing NULL consts
- c95cd2991f1e 19 (unreleased) landed
-
Move planner row-estimation tests to new planner_est.sql
- 374a6394c6ae 19 (unreleased) landed