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 1um7ac-00AF34-4W for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Aug 2025 09:16: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 1um7aZ-00DqQH-K2 for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Aug 2025 09:16:07 +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 1um7aZ-00DqQ8-AJ for pgsql-hackers@lists.postgresql.org; Wed, 13 Aug 2025 09:16:07 +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 1um7aX-000VaI-0U for pgsql-hackers@lists.postgresql.org; Wed, 13 Aug 2025 09:16:07 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1um7aU-000vJf-J1 for pgsql-hackers@lists.postgresql.org; Wed, 13 Aug 2025 09:16:03 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1um7aU-000bnA-2s for pgsql-hackers@lists.postgresql.org; Wed, 13 Aug 2025 09:16:02 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: Improve hash join's handling of tuples with null join keys To: pgsql-hackers@lists.postgresql.org From: Chao Li Cc: Tom Lane Date: Wed, 13 Aug 2025 09:16:01 +0000 User-Agent: pgcommitfest X-cfsender: chaol In-Reply-To: <496221.1748882849@sss.pgh.pa.us> References: <3061845.1746486714@sss.pgh.pa.us> <496221.1748882849@sss.pgh.pa.us> Message-ID: <175507656113.993.1381684440543440253.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SSBkb3dubG9hZGVkIHRoZSBwYXRjaCBhbmQgdGVzdGVkIGFsbCBqb2luIHR5cGVzOiBpbm5lciwg bGVmdCwgcmlnaHQsIGZ1bGwsIHNlbWkgYW5kIGFudGkuIEJhc2ljYWxseSBteSB0ZXN0cyBhbGwg cGFzc2VkLiBIb3dldmVyLCBJIGRpZG4ndCB0ZXN0IGFueSBjYXNlIG9mIHBhcmFsbGVsIHF1ZXJ5 Lg0KDQpJIGhhdmUgdHdvIG5pdCBjb21tZW50czoNCg0KMS4gSW4gaGFzaGpvaW4uaCwgbGluZSA3 Ni03OCwgdGhlIGFkZGVkIGNvbW1lbnQgc2F5cyAiKEluIHRoZSB1bmxpa2VseSBidXQgc3VwcG9y dGVkIGNhc2Ugb2YgYSBub24tc3RyaWN0IGpvaW4gb3BlcmF0b3IsIHdlIHRyZWF0IG51bGwga2V5 cyBhcyBub3JtYWwgZGF0YS4pIi4gQnV0IEkgZG9uJ3Qgc2VlIHdoZXJlIG5vbi1zdHJpY3Qgam9p biBpcyBoYW5kbGVkLiBTbywgaG93IHRoaXMgcGF0Y2ggaW1wYWN0IG5vbi1zdHJpY3Qgam9pbnM/ DQoNCjIuIFR3byBuZXcgam9pbiBzdGF0ZXMgYXJlIGFkZGVkOiBISl9GSUxMX09VVEVSX05VTExf VFVQTEVTLCBISl9GSUxMX0lOTkVSX05VTExfVFVQTEVTLiBUaGVyZSBhcmUgZXhpc3Rpbmcgam9p biBzdGF0ZXM6IEhKX0ZJTExfT1VURVJfVFVQTEUgYW5kIEhKX0ZJTExfSU5ORVJfVFVQTEVTLiBU aGV5IGFsbCB1c2UgIkZJTEwiLiBCdXQgSSB0aGluayB0aGF0ICJGSUxMIiBpbiBISl9GSUxMX09V VEVSX05VTExfVFVQTEVTIG1lYW5zIGRpZmZlcmVudCBmcm9tIGluICJISl9GSUxMX09VVEVSX1RV UExFIi4gQmVjYXVzZSBISl9GSUxMX09VVEVSX1RVUExFIG1lYW5zIHRoYXQgd2hlbiByZXR1cm5p bmcgYW4gb3V0ZXIgdHVwbGUsIGl0IG5lZWRzIHRvIGZpbGwgaW4gbnVsbC1leHRlbnNpb24gb2Yg aW5uZXIgdGFibGVzOyB3aGlsZSBISl9GSUxMX09VVEVSX05VTExfVFVQTEVTIG1lYW5zIHRvIHJl dHVybiBvdXRlciB0dXBsZXMgdGhhdCBoYXZlIG51bGwgam9pbiBrZXlzLiBJIHdvdWxkIHN1Z2dl c3Qgc29tZXRoaW5nIGxpa2UgIkFQUEVORCIgZm9yIHRoZSBuZXcgc3RhdGVzOiBISl9BUFBFTkRf T1VURVJfTlVMTF9UVVBMRVMgYW5kIEhKX0FQUEVORF9JTk5FUl9OVUxMX1RVUExFUy4KClRoZSBu ZXcgc3RhdHVzIG9mIHRoaXMgcGF0Y2ggaXM6IFdhaXRpbmcgb24gQXV0aG9yCg==