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 1vONJ4-0050LM-24 for pgsql-committers@arkaria.postgresql.org; Wed, 26 Nov 2025 21:44:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vONJ3-001o5Z-0m for pgsql-committers@arkaria.postgresql.org; Wed, 26 Nov 2025 21:44:09 +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 1vONJ3-001o5R-03 for pgsql-committers@lists.postgresql.org; Wed, 26 Nov 2025 21:44:09 +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.96) (envelope-from ) id 1vONJ1-001fuQ-0u for pgsql-committers@lists.postgresql.org; Wed, 26 Nov 2025 21:44:09 +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=DWbmlb4tSQGJbbKOEzLfNlwfcxuqVTh59i3W27X+02A=; b=Z4uUi2Z9AJRfFmPdocNs/6USq5 Y6iaysjqMztyjgiKk/0EXSjnd3yVPsuFtmmOMZpkf1ZU4kFRhs/PHGStfL1l98AIhGDDpDZie+WlE StlYPPhyeUwn8rt3ftUgB0TBWVrLZfWCQHFXbJWyORo1BT00B/O+Sri5gnA14s/BgW5CKisW7zmAy hcDcCiPpfqQAXdCVLb8O1ca03S1NjyHlC74938rObjTuStmHFkuLAx6KyjSQwfvO+L+iQRI5ZCrLY Pprfj1wn1ciPSx/zRaf/ci/7C9uYrF6g8j3Uq2W8ys5gn7UhiakRPJawwDRPY140jhbWsT5tt91ox ZAsaYNGw==; 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 1vONIz-001DZw-2a for pgsql-committers@lists.postgresql.org; Wed, 26 Nov 2025 21:44:05 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vONIy-001Ye2-34 for pgsql-committers@lists.postgresql.org; Wed, 26 Nov 2025 21:44:05 +0000 Content-Type: multipart/mixed; boundary="===============3752294570141726286==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Have the planner replace COUNT(ANY) with COUNT(*), when possible X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 26 Nov 2025 21:44:05 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3752294570141726286== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SGF2ZSB0aGUgcGxhbm5lciByZXBsYWNlIENPVU5UKEFOWSkgd2l0aCBDT1VOVCgqKSwgd2hlbiBw b3NzaWJsZQoKVGhpcyBhZGRzIFN1cHBvcnRSZXF1ZXN0U2ltcGxpZnlBZ2dyZWYgdG8gYWxsb3cg cGdfcHJvYy5wcm9zdXBwb3J0CmZ1bmN0aW9ucyB0byByZWNlaXZlIGFuIEFnZ3JlZiBhbmQgYWxs b3cgdGhlbSB0byBkZXRlcm1pbmUgaWYgdGhlcmUgaXMgYQp3YXkgdGhhdCB0aGUgQWdncmVmIGNh bGwgY2FuIGJlIG9wdGltaXplZC4KCkFsc28gYWRkZWQgaXMgYSBzdXBwb3J0IGZ1bmN0aW9uIHRv IGFsbG93IHRyYW5zZm9ybWF0aW9uIG9mIENPVU5UKEFOWSkKaW50byBDT1VOVCgqKS4gIFRoaXMg aXMgcG9zc2libGUgdG8gZG8gd2hlbiB0aGUgZ2l2ZW4gIkFOWSIgY2Fubm90IGJlCk5VTEwgYW5k IGFsc28gdGhhdCB0aGVyZSBhcmUgbm8gT1JERVIgQlkgLyBESVNUSU5DVCBjbGF1c2VzIHdpdGhp biB0aGUKQWdncmVmLiAgVGhpcyBpcyBhIHVzZWZ1bCB0cmFuc2Zvcm1hdGlvbiB0byBkbyBhcyBp dCBpcyBjb21tb24gdGhhdApwZW9wbGUgd3JpdGUgQ09VTlQoMSksIHdoaWNoIHVudGlsIG5vdyBo YXMgYWRkZWQgdW5uZWVkZWQgb3ZlcmhlYWQuCldoZW4gY291bnRpbmcgYSBOT1QgTlVMTCBjb2x1 bW4uICBUaGUgb3ZlcmhlYWRzIGNhbiBiZSB3b3JzZSBhcyB0aGF0Cm1pZ2h0IG1lYW4gZGVmb3Jt aW5nIG1vcmUgb2YgdGhlIHR1cGxlLCB3aGljaCBmb3IgbGFyZ2UgZmFjdCB0YWJsZXMgbWF5CmJl IG1hbnkgY29sdW1ucyBpbi4KCkl0IG1heSBiZSBwb3NzaWJsZSB0byBhZGQgcHJvc3VwcG9ydCBm dW5jdGlvbnMgZm9yIG90aGVyIGFnZ3JlZ2F0ZXMuICBXZQpjb3VsZCBjb25zaWRlciBpZiBPUkRF UiBCWSBjb3VsZCBiZSBkcm9wcGVkIGZvciBzb21lIGNhbGxzLCBlLmcuIHRoZQpPUkRFUiBCWSBp cyBxdWl0ZSB1c2VsZXNzIGluIE1BWChjIE9SREVSIEJZIGMpLgoKVGhlcmUgaXMgYSBsaXR0bGUg Yml0IG9mIHBhc3NpbmcgZmFsbG91dCBmcm9tIGFkanVzdGluZwpleHByX2lzX25vbm51bGxhYmxl KCkgdG8gaGFuZGxlIENvbnN0IHdoaWNoIHJlc3VsdHMgaW4gYSBwbGFuIGNoYW5nZSBpbgp0aGUg YWdncmVnYXRlcy5vdXQgcmVncmVzc2lvbiB0ZXN0LiAgUHJldmlvdXNseSwgbm90aGluZyB3YXMg YWJsZSB0bwpkZXRlcm1pbmUgdGhhdCAiT25lLVRpbWUgRmlsdGVyOiAoMTAwIElTIE5PVCBOVUxM KSIgd2FzIGFsd2F5cyB0cnVlLAp0aGVyZWZvcmUgdXNlbGVzcyB0byBpbmNsdWRlIGluIHRoZSBw bGFuLgoKQXV0aG9yOiBEYXZpZCBSb3dsZXkgPGRncm93bGV5bWxAZ21haWwuY29tPgpSZXZpZXdl ZC1ieTogQ29yZXkgSHVpbmtlciA8Y29yZXkuaHVpbmtlckBnbWFpbC5jb20+ClJldmlld2VkLWJ5 OiBNYXRoZXVzIEFsY2FudGFyYSA8bWF0aGV1c3NzaWx2OTdAZ21haWwuY29tPgpEaXNjdXNzaW9u OiBodHRwczovL3Bvc3Rnci5lcy9tL0NBQXBIRHZxR2NQVGFnWHBLZkg9Q3JtSEJxQUxwemlUaEpF RHNfTXJQcWpLVmVERjl3QUBtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRl dGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzQy NDczYjNiMzEyMzhiMTVjYzNjMDMwYjQ0MTZiMmVlNzk1MDhkOGMKCk1vZGlmaWVkIEZpbGVzCi0t LS0tLS0tLS0tLS0tCmNvbnRyaWIvcG9zdGdyZXNfZmR3L2V4cGVjdGVkL3Bvc3RncmVzX2Zkdy5v dXQgfCAgMjAgKystLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGxhbi9pbml0c3BsYW4uYyAgICAg ICAgIHwgIDIwICstLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvY2xhdXNlcy5jICAgICAg ICAgICB8ICA3MyArKysrKysrKysrKysrKysKc3JjL2JhY2tlbmQvdXRpbHMvYWR0L2ludDguYyAg ICAgICAgICAgICAgICAgICB8ICA0OSArKysrKysrKystCnNyYy9pbmNsdWRlL25vZGVzL3N1cHBv cnRub2Rlcy5oICAgICAgICAgICAgICAgfCAgMjUgKysrKysKc3JjL2luY2x1ZGUvb3B0aW1pemVy L29wdGltaXplci5oICAgICAgICAgICAgICB8ICAgMyArCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0 ZWQvYWdncmVnYXRlcy5vdXQgICAgICAgfCAxMjUgKysrKysrKysrKysrKysrKysrKysrKystLQpz cmMvdGVzdC9yZWdyZXNzL3NxbC9hZ2dyZWdhdGVzLnNxbCAgICAgICAgICAgIHwgIDQ0ICsrKysr KysrLQpzcmMvdG9vbHMvcGdpbmRlbnQvdHlwZWRlZnMubGlzdCAgICAgICAgICAgICAgIHwgICAx ICsKOSBmaWxlcyBjaGFuZ2VkLCAzMjQgaW5zZXJ0aW9ucygrKSwgMzYgZGVsZXRpb25zKC0pCgo= --===============3752294570141726286==--