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 1vaHbs-006NyK-0c for pgsql-committers@arkaria.postgresql.org; Mon, 29 Dec 2025 18:04:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vaHbr-00032l-0Z for pgsql-committers@arkaria.postgresql.org; Mon, 29 Dec 2025 18:04:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vaHYs-0002CI-2S for pgsql-committers@lists.postgresql.org; Mon, 29 Dec 2025 18:01:43 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vaHYr-003DJp-1H for pgsql-committers@lists.postgresql.org; Mon, 29 Dec 2025 18:01:42 +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.96) (envelope-from ) id 1vaHYq-009Muo-2p for pgsql-committers@lists.postgresql.org; Mon, 29 Dec 2025 18:01:40 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vaHYo-003LY4-2b for pgsql-committers@lists.postgresql.org; Mon, 29 Dec 2025 18:01:39 +0000 Content-Type: multipart/mixed; boundary="===============5312681792872769004==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Ensure sanity of hash-join costing when there are no MCV statist X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 29 Dec 2025 18:01:39 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5312681792872769004== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RW5zdXJlIHNhbml0eSBvZiBoYXNoLWpvaW4gY29zdGluZyB3aGVuIHRoZXJlIGFyZSBubyBNQ1Yg c3RhdGlzdGljcy4KCmVzdGltYXRlX2hhc2hfYnVja2V0X3N0YXRzIGlzIGRlZmluZWQgdG8gcmV0 dXJuIHplcm8gdG8gKm1jdl9mcmVxIGlmCml0IGNhbm5vdCBvYnRhaW4gYSB2YWx1ZSBmb3IgdGhl IGZyZXF1ZW5jeSBvZiB0aGUgbW9zdCBjb21tb24gdmFsdWUuCkl0cyBzb2xlIGNhbGxlciBmaW5h bF9jb3N0X2hhc2hqb2luIGlnbm9yZWQgdGhpcyBwcm92aXNpb24gYW5kIHdvdWxkCmJsaW5kbHkg YmVsaWV2ZSB0aGUgemVybyB2YWx1ZSwgcmVzdWx0aW5nIGluIGNvbXB1dGluZyB6ZXJvIGZvciB0 aGUKbGFyZ2VzdCBidWNrZXQgc2l6ZS4gIEluIGNvbnNlcXVlbmNlLCB0aGUgc2FmZXR5IGNoZWNr IHRoYXQgaW50ZW5kZWQKdG8gcHJldmVudCB0aGUgbGFyZ2VzdCBidWNrZXQgZnJvbSBleGNlZWRp bmcgZ2V0X2hhc2hfbWVtb3J5X2xpbWl0KCkKd2FzIGluZWZmZWN0aXZlLCBhbGxvd2luZyB2ZXJ5 IHNpbGx5IHBsYW5zIHRvIGJlIGNob3NlbiBpZiBzdGF0aXN0aWNzCndlcmUgbWlzc2luZy4KCkFm dGVyIGZpeGluZyBmaW5hbF9jb3N0X2hhc2hqb2luIHRvIGRpc3JlZ2FyZCB6ZXJvIHJlc3VsdHMg Zm9yCm1jdl9mcmVxLCBhIHNlY29uZCBwcm9ibGVtIGFwcGVhcmVkOiBzb21lIGNhc2VzIHRoYXQg c2hvdWxkIHVzZSBoYXNoCmpvaW5zIGZhaWxlZCB0by4gIFRoaXMgaXMgYmVjYXVzZSBlc3RpbWF0 ZV9oYXNoX2J1Y2tldF9zdGF0cyB3YXMKdW5hd2FyZSBvZiB0aGUgZmFjdCB0aGF0IEFOQUxZWkUg d29uJ3Qgc3RvcmUgTUNWIHN0YXRpc3RpY3MgaWYgaXQKZG9lc24ndCBmaW5kIGFueSBtdWx0aXBs eS1vY2N1cnJpbmcgdmFsdWVzLiAgVGh1cyB0aGUgbGFjayBvZiBhbiBNQ1YKc3RhdHMgZW50cnkg ZG9lc24ndCBuZWNlc3NhcmlseSBtZWFuIHRoYXQgd2Uga25vdyBub3RoaW5nOyB3ZSBtYXkKd2Vs bCBrbm93IHRoYXQgdGhlIGNvbHVtbiBpcyB1bmlxdWUuICBUaGUgZm9ybWVyIGNvZGluZyByZXR1 cm5lZCB6ZXJvCmZvciAqbWN2X2ZyZXEgaW4gdGhpcyBjYXNlLCB3aGljaCB3YXMgcHJldHR5IGNs b3NlIHRvIGNvcnJlY3QsIGJ1dCBub3cKZmluYWxfY29zdF9oYXNoam9pbiBkb2Vzbid0IGJlbGll dmUgaXQgYW5kIGRpc2FibGVzIHRoZSBoYXNoIGpvaW4uClNvIGNoZWNrIHRvIHNlZSBpZiB0aGVy ZSBpcyBhIEhJU1RPR1JBTSBzdGF0cyBlbnRyeTsgaWYgc28sIEFOQUxZWkUKaGFzIGluIGZhY3Qg cnVuIGZvciB0aGlzIGNvbHVtbiBhbmQgbXVzdCBoYXZlIGZvdW5kIGl0IHRvIGJlIHVuaXF1ZS4K SW4gdGhhdCBjYXNlIHJlcG9ydCB0aGUgTUNWIGZyZXF1ZW5jeSBhcyAxIC8gcm93cywgaW5zdGVh ZCBvZiBjbGFpbWluZwppZ25vcmFuY2UuCgpSZXBvcnRpbmcgYSBtb3JlIGFjY3VyYXRlICptY3Zf ZnJlcSBpbiB0aGlzIGNhc2UgY2FuIGFsc28gYWZmZWN0IHRoZQpidWNrZXQtc2l6ZSBza2V3IGFk anVzdG1lbnQgZnVydGhlciBkb3duIGluIGVzdGltYXRlX2hhc2hfYnVja2V0X3N0YXRzLApjYXVz aW5nIGhhc2gtam9pbiBjb3N0IGVzdGltYXRlcyB0byBjaGFuZ2Ugc2xpZ2h0bHkuICBUaGlzIGFm ZmVjdHMKc29tZSBwbGFuIGNob2ljZXMgaW4gdGhlIGNvcmUgcmVncmVzc2lvbiB0ZXN0cy4gIFRo ZSBmaXJzdCBkaWZmIGluCmpvaW4ub3V0IGNvcnJlc3BvbmRzIHRvIGEgY2FzZSB3aGVyZSB3ZSBo YXZlIG5vIHN0YXRzIGFuZCBzaG91bGQgbm90CnJpc2sgYSBoYXNoIGpvaW4sIGJ1dCB0aGUgcmVt YWluaW5nIGNoYW5nZXMgYXJlIGNhdXNlZCBieSBwcm9kdWNpbmcKYSBiZXR0ZXIgYnVja2V0LXNp emUgZXN0aW1hdGUgZm9yIHVuaXF1ZSBqb2luIGNvbHVtbnMuICBUaG9zZSBhcmUgYWxsCmhhcm1s ZXNzIGNoYW5nZXMgc28gZmFyIGFzIEkgY2FuIHRlbGwuCgpUaGUgZXhpc3RpbmcgYmVoYXZpb3Ig d2FzIGludHJvZHVjZWQgaW4gY29tbWl0IDQ4NjdkN2Y2MiBpbiB2MTEuCkl0IGFwcGVhcnMgZnJv bSB0aGUgY29tbWl0IGxvZyB0aGF0IGRpc2FibGluZyB0aGUgYnVja2V0LXNpemUgc2FmZXR5CmNo ZWNrIGluIHRoZSBhYnNlbmNlIG9mIHN0YXRpc3RpY3Mgd2FzIGludGVudGlvbmFsOyBidXQgd2Un dmUgbm93IHNlZW4KYSBjYXNlIHdoZXJlIHRoZSBlbnN1aW5nIGJlaGF2aW9yIGlzIGJhZCBlbm91 Z2ggdG8gbWFrZSB0aGF0IHNlZW0gbGlrZQphIHBvb3IgZGVjaXNpb24uICBJbiBhbnkgY2FzZSB0 aGUgbGFjayBvZiBvdGhlciBwcm9ibGVtcyB3aXRoIHRoYXQKc2FmZXR5IGNoZWNrIGFmdGVyIHNl dmVyYWwgeWVhcnMgaGVscHMgdG8ganVzdGlmeSBlbmZvcmNpbmcgaXQgbW9yZQpzdHJpY3RseS4g IEhvd2V2ZXIsIHdlIHdvbid0IHJpc2sgYmFjay1wYXRjaGluZyB0aGlzLCBpbiBjYXNlIGFueQph cHBsaWNhdGlvbnMgYXJlIGRlcGVuZGluZyBvbiB0aGUgZXhpc3RpbmcgYmVoYXZpb3IuCgpCdWc6 ICMxOTM2MwpSZXBvcnRlZC1ieTogSmluaHVpIExhaSA8amluaHVpLmxhaUBxcS5jb20+CkF1dGhv cjogVG9tIExhbmUgPHRnbEBzc3MucGdoLnBhLnVzPgpSZXZpZXdlZC1ieTogQ2hhbyBMaSA8bGku ZXZhbi5jaGFvQGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8yMzgw MTY1LjE3NjY4NzEwOTdAc3NzLnBnaC5wYS51cwpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5l cy9tLzE5MzYzLThkZDMyZmM3NjAwYTExNTNAcG9zdGdyZXNxbC5vcmcKCkJyYW5jaAotLS0tLS0K bWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29t bWl0ZGlmZi9iZDNlM2U5ZTU2ODMwZTFiMTQ0OGI1NTk3NDNiMGYwYTkwYTZlMzhkCgpNb2RpZmll ZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9jb3N0c2l6 ZS5jICAgICAgICB8ICAgNSArLQpzcmMvYmFja2VuZC91dGlscy9hZHQvc2VsZnVuY3MuYyAgICAg ICAgICAgICB8ICAxNCArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2pvaW4ub3V0ICAgICAg ICAgICB8ICAyOSArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2pvaW5faGFzaC5vdXQgICAg ICB8ICAgMSArCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcGFydGl0aW9uX2pvaW4ub3V0IHwg NDMyICsrKysrKysrKysrKystLS0tLS0tLS0tLS0tLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9qb2lu X2hhc2guc3FsICAgICAgICAgICB8ICAgMSArCjYgZmlsZXMgY2hhbmdlZCwgMjQ4IGluc2VydGlv bnMoKyksIDIzNCBkZWxldGlvbnMoLSkKCg== --===============5312681792872769004==--