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

From:	Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>
To:	David Rowley <dgrowleyml(at)gmail(dot)com>
Cc:	Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>, 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-03-17 10:50:59
Message-ID:	977365f2-2ab7-4008-8d9c-f62ef5271cea@tantorlabs.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2026-02-18 14:11:56 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> 📎  2026-02-19 15:38:41 from David Geier <geidav(dot)pg(at)gmail(dot)com>   2026-02-20 09:06:55 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> 📎    2026-02-20 13:25:24 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>     2026-02-20 13:28:57 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> 📎      2026-02-20 14:22:20 from David Geier <geidav(dot)pg(at)gmail(dot)com>       2026-02-23 17:47:11 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>        2026-02-23 19:44:07 from Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>         2026-02-24 08:15:54 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com>          2026-02-24 08:29:27 from David Geier <geidav(dot)pg(at)gmail(dot)com>           2026-02-24 21:14:01 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> 📎            2026-02-25 13:43:54 from Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>             2026-03-02 15:04:28 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> 📎              2026-03-03 01:08:19 from David Rowley <dgrowleyml(at)gmail(dot)com>               2026-03-03 21:55:31 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> 📎                2026-03-17 10:50:59 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> 📎                 2026-03-18 04:32:47 from David Rowley <dgrowleyml(at)gmail(dot)com> 📎                  2026-03-18 14:26:51 from Ilia Evdokimov <ilya(dot)evdokimov(at)tantorlabs(dot)com> 📎                   2026-03-19 04:28:11 from David Rowley <dgrowleyml(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v7-0002-Reduce-planning-time-for-large-NOT-IN-lists-conta.patch	text/x-patch	4.6 KB
v7-0001-Move-planner-row-estimation-tests-to-selectivity..patch	text/x-patch	29.0 KB

In response to

• Re: Reduce planning time for large NOT IN lists containing NULL at 2026-03-03 21:55:31 from Ilia Evdokimov

Responses

• Re: Reduce planning time for large NOT IN lists containing NULL at 2026-03-18 04:32:47 from David Rowley

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Antonin Houska	2026-03-17 10:53:40	Re: Adding REPACK [concurrently]
Previous Message	Amit Kapila	2026-03-17 10:40:53	Re: [Proposal] Adding Log File Capability to pg_createsubscriber