Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vvFBR-00AA8c-2T for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Feb 2026 13:44:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vvFBQ-006ItZ-1y for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Feb 2026 13:44:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vvFBQ-006ItR-11 for pgsql-hackers@lists.postgresql.org; Wed, 25 Feb 2026 13:44:08 +0000 Received: from mail-yw1-x1130.google.com ([2607:f8b0:4864:20::1130]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vvFBN-00000001E3L-0Zxd for pgsql-hackers@lists.postgresql.org; Wed, 25 Feb 2026 13:44:08 +0000 Received: by mail-yw1-x1130.google.com with SMTP id 00721157ae682-79853c0f5b9so23781007b3.0 for ; Wed, 25 Feb 2026 05:44:05 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772027044; cv=none; d=google.com; s=arc-20240605; b=lWuk+dkAHlfCTX+9VERtPPQbeg/aUPaQJtNJ446YFK5mQoJrzaKusZGsdjH7TD+//3 cn+PfHLzrat2OFuNKMN0yseVo7RpQI4O+ALmnZYDPWlsZnI48+CxaMWZ2DUx/ZgfSMB/ vhW0svfH9zz7TL3+SZn6/AJVbI1LXFHjb88WChAWpjqqBT/G6P0oOYrmonQMG2K7byNi 3MYp2nQvYAs29VXRARzFvWUPHBOMeD7qo6PPbspE23a7lGONTtUeHivnPHVlnlmt5CFF 7yYcLLTZShsLEZTGWjSG5nsfyjnv3ij8nwywM/VSkNGJZZFMcOGaYiwwtSsNALQUF8dU 6JTw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=CPIkkCECC+JjUQubHyS5MVoZfqvx+dmUt2bZ04Y8MME=; fh=uCVRPXOQtp+CGcpEmzGLJLPvCu2w0Jk9QHbJedllqhw=; b=VUez4naFrk/wrvxAMoUOPyJad0K/ju1Y2B8hRUkrbn5GkNnmLWMT4U0QsYHUyIEvEM a0e0EMolZu6xev6S2616XpjmhLsFtR79vkC5E5kGqytLJRy+chRq9T/1xI76zw1/jK3H ow/xfHT14hc5YTQZ5ZNk0u0XTYWqFurYOEyGdz5czf1EDT9IPkeo09idA8f9HIuacuvo 3oHw/JaUN7GLeUYr003vyu8M66rglS4ceSCvwo7+ZNgOU/Mi2S/dcYN8SfwECVG+vHmf SgUPXU7/iCGc9yaiyPUjfmt/Hb4dE1M7c3YN+vAN1Gd8vkvaTSr0gHf0BAvxZuTh+DwZ mGLQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=percona.com; s=google; t=1772027044; x=1772631844; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=CPIkkCECC+JjUQubHyS5MVoZfqvx+dmUt2bZ04Y8MME=; b=NDm2KdoEFAdc5NS6MU2kBe0wzKR8uJl4ibHTFSfK29CVRgAA7eGYMcaFiwaSWV7cQ9 P9n7aDUHHEp6O0RxNyPS5Hf/5sBz68Tb+zdBpsfFpmXmOkohqpqlIsR1vhzku/PlwlGR 51rLXgH5U+T70XSGnwu3l3gfv8pDKe0iMLnN4= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772027044; x=1772631844; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=CPIkkCECC+JjUQubHyS5MVoZfqvx+dmUt2bZ04Y8MME=; b=WyGhjEvOsTFxkz/ap+jkBuV2vG/oUnrnQFI3PbtVz31/H+8+yBGdgTy6rG6bMakizT 6vVgkDvissmwWe8TzfmNwRo4WeiHxPR2bb9/nq593o2gOJd1YoXOxkquPvUOxYCC7vBl 1Dw6Ai2+k6RpIU8lPO+xaurYG3VWUkD9XELG4/AhqsFGc5nmEUOjOon5m6bwT4CPR+Yg lz4WXknugcQEoSRCCxZ6qtJ2mTR+Fp6lsK1YXvWkzW8oLYeGoKOa9vF+tCbTbPi8fHph f7+78lb3e2udv/EPv0tDFsUmMeUQaGf6dtqNbcp3ENr2qIQDxVsn7VDz/zEYfpPtSk6U bfqw== X-Forwarded-Encrypted: i=1; AJvYcCVds14FSkVrv3lcLs2krxCjFa3gatGr6mWnzo4sTGscVpmblFrUPPEW/IVZeSXIFEH1j4FJ/Ggr8vYVDImU@lists.postgresql.org X-Gm-Message-State: AOJu0YwbNCbOFFJPMUg7/HebcXdQqzBN8rX5qs2ynqny/IoK5oHZbK61 obcq9mmavmCM2dg0MLMpYtOBty4U3Y0VWOpmnabZBhkaz5Yo/O7SaT0VFJ/hJmbk6XViG6+atPB La9p2RZ7gFrDqVgltX1UgB77XqwcTUfhX3ZWQR18LOkZJ3Q5tpdsLSPVod7eHn8gnhQWazX4ETo tBDRZef4XD2ojxHQTyTc2GBCxQw/MGPohuYNp06rLZqV5EQk7hz8qHolORzx/r47i3JREDTXaNn bVGbbzwmxuVCF2QzM3eBTaMrDrXV0bnzTWv2b4vlqDqV1sWLDhPXY1KvvEUAhGkQ3s= X-Gm-Gg: ATEYQzyIO7GVOOIqijwt/8kxgNTQ7ZiBUcDjvAiDwbn+18BBpPfqFBHq9Y8xMwjMQJY LAXHezwPZGvDTka+o3wcVpwPiNXKPUHwQMqyBs6BmsYXHFyhuExd2EN13M4qJBC6p5Dc2GyIZla FC6KWFYEQY9bIfjxki3VTz2qp+frlfd2bSkbKRJpnJYfC7dlrIzTzJw4v0VoDDpriEwgXhpaWtZ nKhpYtNeBS0oke3rnWSf+86/rh16nzLax+XFimfXUoJMRkv0blcrG4/6kBwSCgkzwv7MSsX/2zw atqHXnoMZedbjk4gK8OLtrOzx+Saka12aVGHfPAN4WTlRd3OJsnh/lNpgcTZtXCKX9ZE X-Received: by 2002:a05:690c:84:b0:794:ea37:1d3a with SMTP id 00721157ae682-7986fca7968mr4211977b3.28.1772027043734; Wed, 25 Feb 2026 05:44:03 -0800 (PST) MIME-Version: 1.0 References: <52596e08-0902-475b-ad0f-265ec6918f19@gmail.com> <7791ec74-369d-48c7-969c-cf4ad18024f2@tantorlabs.com> <6b3aebb5-f26c-4f50-abd6-e733d452af26@gmail.com> <52f3c637-465d-4f0e-9546-732ecf61ab87@tantorlabs.com> <3fc74079-f429-48c8-ad8c-688b21d4d1c1@gmail.com> <4c761b02-5a60-4076-aa0c-9c6fef06e2c1@tantorlabs.com> In-Reply-To: <4c761b02-5a60-4076-aa0c-9c6fef06e2c1@tantorlabs.com> From: Zsolt Parragi Date: Wed, 25 Feb 2026 13:43:54 +0000 X-Gm-Features: AaiRm51uUrP3g5WopnsZIeqqWZcnGt-dp5buX4x05xV6YZT8cE1jg3yvcFJhOFk Message-ID: Subject: Re: Reduce planning time for large NOT IN lists containing NULL To: Ilia Evdokimov Cc: David Geier , PostgreSQL Developers Content-Type: text/plain; charset="UTF-8" X-CLOUD-SEC-AV-Sent: true X-CLOUD-SEC-AV-Info: percona,google_mail,monitor X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk expressions.sql is missing a new line at the end of the file, otherwise it looks good to me.