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 1w34ol-000sIe-2W for pgsql-committers@arkaria.postgresql.org; Thu, 19 Mar 2026 04:17:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w34ok-00GBlw-14 for pgsql-committers@arkaria.postgresql.org; Thu, 19 Mar 2026 04:17:06 +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 1w34oj-00GBlo-33 for pgsql-committers@lists.postgresql.org; Thu, 19 Mar 2026 04:17:06 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w34oh-000000013hC-0WB9 for pgsql-committers@lists.postgresql.org; Thu, 19 Mar 2026 04:17:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=83fOhQjpFExnORiLjURXNzqhAMz359i5DAJ3Oe/0yi8=; b=tvxry59MLkUWpTbWkgWuQxHGl7 TBQsyrNbcRY+KUcBgT9wDNagV6vUqomDucMMxy3Vybrdc9f7Cdnt6/0SUih7Z3PoJIpHGfeW5ii1L Lqat/q8KrAalBBiIsAWRRIxGztKa8s/JV8ln4Uvcn3kS3+EQbp/Wl1AipaiWvElJkKuW4jnmhBaLs t5gIPQ4Ejw2v+RARC1GCoYQNm0RHRZJhqXD2kxu+eXWxufNp6YuiGtWQW4y+kEIvwJ1ukQeSCTwhv 3M26qYQpmDqQpIbIcCQ27T9y6q6xPd0TS2QAOrbCErw8ZmTPLBfO7fGdIVtqQhfeZ1rVxGLJWuyPx YZqWZY3g==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w34of-001JTm-2l for pgsql-committers@lists.postgresql.org; Thu, 19 Mar 2026 04:17:02 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w34oe-000R9F-2l for pgsql-committers@lists.postgresql.org; Thu, 19 Mar 2026 04:17:01 +0000 Content-Type: multipart/mixed; boundary="===============4431904152862518534==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Short-circuit row estimation in NOT IN containing NULL consts X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 19 Mar 2026 04:17:01 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4431904152862518534== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U2hvcnQtY2lyY3VpdCByb3cgZXN0aW1hdGlvbiBpbiBOT1QgSU4gY29udGFpbmluZyBOVUxMIGNv bnN0cwoKU2NhbGFyQXJyYXlPcEV4cHIgdXNlZCBmb3IgZWl0aGVyIE5PVCBJTiBvciA8Pi89IEFM TCwgd2hlbiB0aGUgYXJyYXkKY29udGFpbnMgYSBOVUxMIGNvbnN0YW50LCB3aWxsIG5ldmVyIGV2 YWx1YXRlIHRvIHRydWUuICBIZXJlIHdlIGFkZCBhbgpleHBsaWNpdCBzaG9ydC1jaXJjdWl0IGlu IHNjYWxhcmFycmF5c2VsKCkgdG8gYWNjb3VudCBmb3IgdGhpcyBhbmQgcmV0dXJuCjAuMCByb3dz IHdoZW4gd2Ugc2VlIHRoYXQgYSBOVUxMIGV4aXN0cy4gIFdoZW4gdGhlIGFycmF5IGlzIGEgY29u c3RhbnQsCndlIGNhbiB2ZXJ5IHF1aWNrbHkgc2VlIGlmIHRoZXJlIGFyZSBhbnkgTlVMTCB2YWx1 ZXMgYW5kIHJldHVybiBlYXJseQpiZWZvcmUgZ29pbmcgdG8gbXVjaCBlZmZvcnQgaW4gc2NhbGFy YXJyYXlzZWwoKS4gIEZvciBub24tY29uc3QgYXJyYXlzLAp3ZSBzaG9ydC1jaXJjdWl0IGFmdGVy IGZpbmRpbmcgdGhlIGZpcnN0IE5VTEwgYW5kIGZvcmVnbyBzZWxlY3Rpdml0eQplc3RpbWF0aW9u cyBvZiBhbnkgcmVtYWluaW5nIGVsZW1lbnRzLgoKSW4gdGhlIGZ1dHVyZSwgaXQgbWlnaHQgYmUg YmV0dGVyIHRvIGRvIHNvbWV0aGluZyBmb3IgdGhpcyBjYXNlIGluCmNvbnN0YW50IGZvbGRpbmcu ICBXZSB3b3VsZCBuZWVkIHRvIGJlIGNhcmVmdWwgdG8gb25seSBkbyB0aGlzIGZvcgpzdHJpY3Qg b3BlcmF0b3JzIG9uIGV4cHJlc3Npb25zIGxvY2F0ZWQgaW4gcGxhY2VzIHRoYXQgZG9uJ3QgY2Fy ZSBhYm91dApkaXN0aW5ndWlzaGluZyBmYWxzZSBmcm9tIE5VTEwgcmV0dXJucy4gaS5lLiBFWFBS S0lORF9RVUFMIGV4cHJlc3Npb25zLgpEb2luZyB0aGF0IHJlcXVpcmVzIGEgYml0IG1vcmUgdGhv dWdodCBhbmQgZWZmb3J0LCBzbyBoZXJlIHdlIGp1c3QgZml4CnNvbWUgbmVlZGxlc3NseSBzbG93 IHNlbGVjdGl2aXR5IGVzdGltYXRpb25zIGZvciBTY2FsYXJBcnJheU9wRXhwcgpjb250YWluaW5n IG1hbnkgYXJyYXkgZWxlbWVudHMgYW5kIGF0IGxlYXN0IG9uZSBOVUxMLgoKQXV0aG9yOiBJbGlh IEV2ZG9raW1vdiA8aWx5YS5ldmRva2ltb3ZAdGFudG9ybGFicy5jb20+ClJldmlld2VkLWJ5OiBE YXZpZCBHZWllciA8Z2VpZGF2LnBnQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IFpzb2x0IFBhcnJh Z2kgPHpzb2x0LnBhcnJhZ2lAcGVyY29uYS5jb20+ClJldmlld2VkLWJ5OiBEYXZpZCBSb3dsZXkg PGRncm93bGV5bWxAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL2Vh YTI1OThjLTUzNTYtNGUxZS05ZWMzLTVmZDZlYjFjZDcwNEB0YW50b3JsYWJzLmNvbQoKQnJhbmNo Ci0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9y Zy9wZy9jb21taXRkaWZmL2M5NWNkMjk5MWYxZTNlY2U2ODlhZGZlNjYyMDgyZjIwMDEyNmQyNTUK Ck1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9zZWxm dW5jcy5jICAgICAgICAgIHwgMTcgKysrKysrKysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9l eHBlY3RlZC9wbGFubmVyX2VzdC5vdXQgfCAyNyArKysrKysrKysrKysrKysrKysrKysrKysrKysK c3JjL3Rlc3QvcmVncmVzcy9zcWwvcGxhbm5lcl9lc3Quc3FsICAgICAgfCAxNSArKysrKysrKysr KysrKysKMyBmaWxlcyBjaGFuZ2VkLCA1OSBpbnNlcnRpb25zKCspCgo= --===============4431904152862518534==--