Content-Type: multipart/alternative;
 boundary="------------cH7xQ2K85wPDYeMI0e3PnfHt"
Message-ID: <f43547c8-1a21-4337-98f9-f6a1d2b8fd2b@tantorlabs.com>
Date: Mon, 23 Feb 2026 20:47:11 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Reduce planning time for large NOT IN lists containing NULL
To: David Geier <geidav.pg@gmail.com>,
 PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
References: <eaa2598c-5356-4e1e-9ec3-5fd6eb1cd704@tantorlabs.com>
 <52596e08-0902-475b-ad0f-265ec6918f19@gmail.com>
 <7791ec74-369d-48c7-969c-cf4ad18024f2@tantorlabs.com>
 <ed61316c-2e48-45d1-9cca-dc539bfd93b9@tantorlabs.com>
 <dd5e91c1-5e59-471c-bd9d-96a11c7928f4@tantorlabs.com>
 <6b3aebb5-f26c-4f50-abd6-e733d452af26@gmail.com>
Content-Language: en-US
From: Ilia Evdokimov <ilya.evdokimov@tantorlabs.com>
In-Reply-To: <6b3aebb5-f26c-4f50-abd6-e733d452af26@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/f43547c8-1a21-4337-98f9-f6a1d2b8fd2b%40tantorlabs.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------cH7xQ2K85wPDYeMI0e3PnfHt
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 2/20/26 17:22, David Geier wrote:

> It seems like we don't have a regression test which has a NULL value in
> the NOT IN list. Maybe you can find a good place to add that one?

There are already regression tests covering NOT IN with NULL values in 
expressions.sql. Do you think we need an additional simple case, or is 
the current coverage sufficient?

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

--------------cH7xQ2K85wPDYeMI0e3PnfHt
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>On 2/20/26 17:22, David Geier wrote:</p>
    <div class="moz-cite-prefix"><span style="white-space: pre-wrap">
</span></div>
    <blockquote type="cite"
      cite="mid:6b3aebb5-f26c-4f50-abd6-e733d452af26@gmail.com">
      <pre wrap="" class="moz-quote-pre">It seems like we don't have a regression test which has a NULL value in
the NOT IN list. Maybe you can find a good place to add that one?
</pre>
    </blockquote>
    <p>There are already regression tests covering NOT IN with NULL
      values in expressions.sql. Do you think we need an additional
      simple case, or is the current coverage sufficient?</p>
    <p><span class="moz-txt-tag">-- <br>
      </span>Best regards,       <br>
      Ilia Evdokimov, <br>
      Tantor Labs LLC, <br>
      <a class="moz-txt-link-freetext" href="https://tantorlabs.com/">https://tantorlabs.com/</a></p>
  </body>
</html>

--------------cH7xQ2K85wPDYeMI0e3PnfHt--