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.94.2) (envelope-from ) id 1vFg8N-00GQCC-16 for pgsql-committers@arkaria.postgresql.org; Sun, 02 Nov 2025 22:01:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vFg8L-00EXl5-Uq for pgsql-committers@arkaria.postgresql.org; Sun, 02 Nov 2025 22:01: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.94.2) (envelope-from ) id 1vFg5O-00EWHI-28 for pgsql-committers@lists.postgresql.org; Sun, 02 Nov 2025 21:58:05 +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 1vFg5K-005ddn-1T for pgsql-committers@lists.postgresql.org; Sun, 02 Nov 2025 21:58:04 +0000 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.94.2) (envelope-from ) id 1vFg5K-0091en-1w for pgsql-committers@lists.postgresql.org; Sun, 02 Nov 2025 21:58:00 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vFg5H-004k5c-2k for pgsql-committers@lists.postgresql.org; Sun, 02 Nov 2025 21:57:59 +0000 Content-Type: multipart/mixed; boundary="===============7527049558038979239==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve planner's estimates of tuple hash table sizes. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 02 Nov 2025 21:57:59 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7527049558038979239== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBwbGFubmVyJ3MgZXN0aW1hdGVzIG9mIHR1cGxlIGhhc2ggdGFibGUgc2l6ZXMuCgpG b3Igc2V2ZXJhbCB0eXBlcyBvZiBwbGFuIG5vZGVzIHRoYXQgdXNlIFR1cGxlSGFzaFRhYmxlcywg dGhlCnBsYW5uZXIgZXN0aW1hdGVkIHRoZSBleHBlY3RlZCBzaXplIG9mIHRoZSB0YWJsZSBhcyBi YXNpY2FsbHkKbnVtRW50cmllcyAqIChNQVhBTElHTihkYXRhV2lkdGgpICsgTUFYQUxJR04oU2l6 ZW9mSGVhcFR1cGxlSGVhZGVyKSkuClRoaXMgaXMgcHJldHR5IGZhciBvZmYsIGVzcGVjaWFsbHkg Zm9yIHNtYWxsIGRhdGEgd2lkdGhzLCBiZWNhdXNlCml0IGRvZXNuJ3QgYWNjb3VudCBmb3IgdGhl IG92ZXJoZWFkIG9mIHRoZSBzaW1wbGVoYXNoLmggaGFzaCB0YWJsZQpub3IgZm9yIGFueSBwZXIt dHVwbGUgImFkZGl0aW9uYWwgc3BhY2UiIHRoZSBwbGFuIG5vZGUgbWF5IHJlcXVlc3QuCkplZmYg SmFuZXMgbm90ZWQgYSBjYXNlIHdoZXJlIHRoZSBlc3RpbWF0ZSB3YXMgb2ZmIGJ5IGFib3V0IGEg ZmFjdG9yCm9mIHRocmVlLCBldmVuIHRob3VnaCB0aGUgb2J2aW91cyBoYXphcmRzIHN1Y2ggYXMg aW5hY2N1cmF0ZSBlc3RpbWF0ZXMKb2YgbnVtRW50cmllcyBvciBkYXRhV2lkdGggZGlkbid0IGFw cGx5LgoKVG8gaW1wcm92ZSBtYXR0ZXJzLCBjcmVhdGUgZnVuY3Rpb25zIHByb3ZpZGVkIGJ5IHRo ZSByZWxldmFudCBleGVjdXRvcgptb2R1bGVzIHRoYXQgY2FuIGVzdGltYXRlIHRoZSByZXF1aXJl ZCBzaXplcyB3aXRoIHJlYXNvbmFibGUgYWNjdXJhY3kuCihXZSdyZSBzdGlsbCBub3QgYWNjb3Vu dGluZyBmb3IgZWZmZWN0cyBsaWtlIGFsbG9jYXRvciBwYWRkaW5nLCBidXQKdGhpcyBhdCBsZWFz dCBnZXRzIHRoZSBmaXJzdC1vcmRlciBlZmZlY3RzIGNvcnJlY3QuKQoKSSBhZGRlZCBmdW5jdGlv bnMgdGhhdCBjYW4gZXN0aW1hdGUgdGhlIHR1cGxlIHRhYmxlIHNpemVzIGZvcgpub2RlU2V0T3Ag YW5kIG5vZGVTdWJwbGFuOyB0aGVzZSByZWx5IG9uIGFuIGVzdGltYXRvciBmb3IKVHVwbGVIYXNo VGFibGVzIGluIGdlbmVyYWwsIGFuZCB0aGF0IGluIHR1cm4gcmVsaWVzIG9uIG9uZSBmb3IKc2lt cGxlaGFzaC5oIGhhc2ggdGFibGVzLiAgVGhhdCBmZWVscyBsaWtlIGtpbmQgb2YgYSBsb3Qgb2Yg bWVjaGFuaXNtLApidXQgaWYgd2UgdGFrZSBhbnkgc2hvcnQtY3V0cyB3ZSdyZSB2aW9sYXRpbmcg bW9kdWxhcml0eSBib3VuZGFyaWVzLgoKVGhlIG90aGVyIHBsYWNlcyB0aGF0IHVzZSBUdXBsZUhh c2hUYWJsZXMgYXJlIG5vZGVBZ2csIHdoaWNoIHRvb2sKcGFpbnMgdG8gZ2V0IGl0cyBudW1iZXJz IHJpZ2h0IGFscmVhZHksIGFuZCBub2RlUmVjdXJzaXZldW5pb24uCkkgZGlkIG5vdCB0cnkgdG8g aW1wcm92ZSB0aGUgc2l0dWF0aW9uIGZvciBub2RlUmVjdXJzaXZldW5pb24gYmVjYXVzZQp0aGVy ZSdzIG5vdGhpbmcgdG8gaW1wcm92ZTogd2UgYXJlIG5vdCBtYWtpbmcgYW4gZXN0aW1hdGUgb2Yg dGhlIGhhc2gKdGFibGUgc2l6ZSwgYW5kIGl0IHdvdWxkbid0IGhlbHAgdXMgdG8gZG8gc28gYmVj YXVzZSB3ZSBoYXZlIG5vCm5vbi1oYXNoZWQgYWx0ZXJuYXRpdmUgaW1wbGVtZW50YXRpb24uICBP biB0b3Agb2YgdGhhdCwgb3VyIGVzdGltYXRlCm9mIHRoZSBudW1iZXIgb2YgZW50cmllcyB0byBi ZSBoYXNoZWQgaW4gdGhhdCBtb2R1bGUgaXMgc28gc3VzcGVjdAp0aGF0IHdlJ2QgbGlrZWx5IG9m dGVuIGNob29zZSB0aGUgd3JvbmcgaW1wbGVtZW50YXRpb24gaWYgd2UgZGlkIGhhdmUKdHdvIHdh eXMgdG8gZG8gaXQuCgpSZXBvcnRlZC1ieTogSmVmZiBKYW5lcyA8amVmZi5qYW5lc0BnbWFpbC5j b20+CkF1dGhvcjogVG9tIExhbmUgPHRnbEBzc3MucGdoLnBhLnVzPgpSZXZpZXdlZC1ieTogRGF2 aWQgUm93bGV5IDxkZ3Jvd2xleW1sQGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0 Z3IuZXMvbS9DQU1rVT0xemlhMEpmV19RUjhMNXhBMnZwYTBvcVZ1aWFwbTc4aD1XcE5zSEgxM185 dXdAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0K aHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8xZWE1YmRiMDBiZmJjNmY4 MDM0ODU5Y2QxOTc2OTM0NmJmMzFkYzUzCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpz cmMvYmFja2VuZC9leGVjdXRvci9leGVjR3JvdXBpbmcuYyAgICB8IDU5ICsrKysrKysrKysrKysr KysrKysrKysrKysrKysrKysrKysKc3JjL2JhY2tlbmQvZXhlY3V0b3Ivbm9kZVNldE9wLmMgICAg ICAgfCAgOSArKysrKysKc3JjL2JhY2tlbmQvZXhlY3V0b3Ivbm9kZVN1YnBsYW4uYyAgICAgfCA1 MyArKysrKysrKysrKysrKysrKysrKysrKysrKysrLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3Bs YW4vc3Vic2VsZWN0LmMgfCA0NSArKysrKysrKysrKysrLS0tLS0tLS0tLS0tLQpzcmMvYmFja2Vu ZC9vcHRpbWl6ZXIvdXRpbC9wYXRobm9kZS5jICB8IDEyICsrKystLS0Kc3JjL2luY2x1ZGUvZXhl Y3V0b3IvZXhlY3V0b3IuaCAgICAgICAgfCAgMyArKwpzcmMvaW5jbHVkZS9leGVjdXRvci9ub2Rl U2V0T3AuaCAgICAgICB8ICAyICsrCnNyYy9pbmNsdWRlL2V4ZWN1dG9yL25vZGVTdWJwbGFuLmgg ICAgIHwgIDQgKysrCnNyYy9pbmNsdWRlL2xpYi9zaW1wbGVoYXNoLmggICAgICAgICAgIHwgNTAg KysrKysrKysrKysrKysrKysrKysrKysrKystLQo5IGZpbGVzIGNoYW5nZWQsIDIwNiBpbnNlcnRp b25zKCspLCAzMSBkZWxldGlvbnMoLSkKCg== --===============7527049558038979239==--