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 1wFtEF-005fh6-0B for pgsql-hackers@arkaria.postgresql.org; Thu, 23 Apr 2026 12:32:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wFtEE-001lZM-0o for pgsql-hackers@arkaria.postgresql.org; Thu, 23 Apr 2026 12:32:22 +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 1wFtED-001lXu-2g for pgsql-hackers@lists.postgresql.org; Thu, 23 Apr 2026 12:32:21 +0000 Received: from mail-northeuropeazon11022109.outbound.protection.outlook.com ([52.101.66.109] helo=DUZPR83CU001.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wFtEB-00000002eFz-1SdN for pgsql-hackers@lists.postgresql.org; Thu, 23 Apr 2026 12:32:21 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=LOXEhmUBpb69OtXFQduZIwnNrRV6nLn77K0gOC7E+Oy4UX9JBC/62jOecGkhQe7KGP1n2X8itCyQaXhm5XLl2V0HI/d+XtX5j+HIyt0RjUwAy0LWOUt1+9LdK2phDVptuSgTr/uDPzsPn36CP7OE5tvbKfRRAxK9Tvw5rGntwkoSjOTnXvDXaK3Ll/YKwbNy+SK28DPgaulPfXdroQBu0XOSfoDPLAAPrZY33OdB63j7rwn1p8jxGuPKnL+BdXVmY5I2GqOo7F7WfRPJBCbZfQSaiF38liGhIBuCvx3jVCUYzWjpsSHbhcQFBuyPj2Jn9p0I7jyW96+6ZgYnOD7DVQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=ts353DIPSuQ934ZY1Z4Ase0T9rojTyloVuRiLP0gAd8=; b=WYn+uO7bYE5NtGsvUK37/PDmfYmmfC7dHh4XyNP47obA4OkBLJsm1vQQYzLMw3dHWSGe7428MIfZoWl1Dn8cavNQwWksEoSBdp+z61f30d6CmaZ2oMQBMpIsM5qURNvY21wXCfqTJ1D17vzUPgvYLaH0cAB/P+pKCro0gKRt2BfRPYl5I5bINO3mCYhTBMAhadsJXjEyyNj2TqgH6ydqF24+IaiJ27bX7iw4hTbnYROXyMzDg6oj45Ck/i3KVfo+j1CZjHa1VR2tNiGzQmrRuolaxvUwU9EV9YJKpqgNMoG2A2nd5TblAAo9Fa+p0efNgddbptAszJzGi9kzipLIvw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ulb.be; dmarc=pass action=none header.from=ulb.be; dkim=pass header.d=ulb.be; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ulb.be; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=ts353DIPSuQ934ZY1Z4Ase0T9rojTyloVuRiLP0gAd8=; b=gjd//tx172/PPXCs/OSaFeBoyxGe4XrLTxiIabEopC/JpbIH9NeKZuYNqhBKbcOJTMJprkLtl+pwaV29QxVybeXFednEQA4sO9o2a5HXkhKA+DUcp8DA1DpT9qzdAf78qiWWbpOop2S7tAMQH0FFiD+iml9GuklMh1isvzUAMd4= Received: from DB8P190MB0731.EURP190.PROD.OUTLOOK.COM (2603:10a6:10:125::14) by GVUP190MB2709.EURP190.PROD.OUTLOOK.COM (2603:10a6:150:361::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.9846.16; Thu, 23 Apr 2026 12:32:15 +0000 Received: from DB8P190MB0731.EURP190.PROD.OUTLOOK.COM ([fe80::3f82:98a0:536f:f5af]) by DB8P190MB0731.EURP190.PROD.OUTLOOK.COM ([fe80::3f82:98a0:536f:f5af%5]) with mapi id 15.20.9846.021; Thu, 23 Apr 2026 12:32:13 +0000 From: SCHOEMANS Maxime To: Haibo Yan CC: vignesh C , Tom Lane , Damir Belyalov , jian he , PostgreSQL Hackers , SAKR Mahmoud , Diogo Repas Subject: Re: Implement missing join selectivity estimation for range types Thread-Topic: Implement missing join selectivity estimation for range types Thread-Index: AQHZK2HTFElV4cAAG0qhvSWvkCiFBa6keKmAgAAVOQCAAtFcgIACBB+AgAYni4CAVKFYAICOo58AgABu2wCAG78GAIAAfkQAgMyTtICACXamgIBHqSyAgAB2DQCAEmj+gIAHr52AhPImLgCAC/F48YAAt/OAgADvhWCAANpugIAAt9XegAJqCgCABVuiyIACZQOAgACgduI= Date: Thu, 23 Apr 2026 12:32:13 +0000 Message-ID: References: <8afecd87-d1e5-241c-5e3e-75e1c62c279b@enterprisedb.com> <1bc5e1e4-380b-213d-6e6a-d5e8f7f0c7f5@enterprisedb.com> <84ffb566-8038-ab35-c841-7a5e5728a247@enterprisedb.com> <525ea957-88ff-e2c6-2975-474c849aa234@ulb.be> <48a78946-f380-a279-e75f-711846e509f8@ulb.be> <4c443cf6-96af-0953-fd5b-bd2b5c0c6f00@ulb.be> <2516071.1699991181@sss.pgh.pa.us> <08b2dea8-6dca-06e4-a53d-3e6334e7645b@ulb.be> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=ulb.be; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: DB8P190MB0731:EE_|GVUP190MB2709:EE_ x-ms-office365-filtering-correlation-id: 9ccf4a17-5fb5-4ebd-456b-08dea13458dc x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|366016|786006|376014|1800799024|18002099003|22082099003|56012099003|38070700021|8096899003; x-microsoft-antispam-message-info: YNazTOGPbHzC59Qq/cD+nXwbno8jV0brDIEyQwtR3nO+WuU1wI3GpHLcIvOL7EpM34erOlMizmbCUa7c5tEEmCZ7nQMoGloPg5+Y7SB+Ncyl0KhfGYLW9vezebo4GOoun2CzK2QtqQBhIh4+CDmdPNS8J1KpgRzftyVe/CFHXY7zJ/W4JX1ql2NjfbMhCgvB1/uZ2jdoMu7sp5qzBCelWUKmIW7JKJuFOXtiZ5GkZlfw3MayKs/PaD6Jr5SM2dEY67f9FSTtXnKTHUCX4bdasUnAUDlJ8tx/xaMD9S6xj/2bclxqM/f8DZ0Qa9Mb+sFWSlKSFBAPjl0qG0Zz0nuKRAswb0LWdZs2yK/pQQTTSxcaNhSlySME0GOJkLQO01puA3IqOojYonDW9fd/dK2IidNz6vaUCQAMjcI2AJjKbSbxJ7O3/4VW/HabRDA4WNDoO7OIxmskdSiZg10WzP2mwnWphox4/vZsnsQY/e15/Oq4tFwU2yERu8fDLGI4TezUAYDLefOswsze455hift7E0ZSEk4GrgDbysdXy+J1WKHQL+xT9WblFR2aUGoqtveHmBpjoF+kc7s06oE6EVjIVjP/twTsXQ9ZoVGoPmC58U2VcwUZ45PQRiyJyXBh33GrF4NDV5VixA/ArtKDn8yxMbniCQ2RfXLxSDTxATazO8x0ZO1Q0uzTQfV807Kitp+wwugUaLy7LEqmfsmtCUb2UxXnaiQOpNXUo+FHJ0Ho7WMQxKBJ/NkCJ+evCgy473/OaESG5H4tEM9oYrRhU3LVLB8FTvIuZU7Y8vBk7hXSlwI= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:DB8P190MB0731.EURP190.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230040)(366016)(786006)(376014)(1800799024)(18002099003)(22082099003)(56012099003)(38070700021)(8096899003);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?/0QKwfSb27P3NDbj5t87iWKGE2XLv38oLEAg4AP1/Bvy9CHOcKZ8wPt2yQ?= =?iso-8859-1?Q?ZYK/9IayPg5Auo5Mjyc5aGxesyfYpa8me7NN1CxFIB5lNXiSwloKhNMOE6?= =?iso-8859-1?Q?6hwtzmb0tIrSuwH7zHJ2qsc6nXzKI+ZX+v//AwxSlh/IfngrteJ9XrWW78?= =?iso-8859-1?Q?xpRfSY+KPtDXEKjjSYKEDHHaiTL+Acfq9oIvr2vz4frDfhEi8Xhoel/v4v?= =?iso-8859-1?Q?TCklgUMtIkN6BpXEpyTNB1ul8+59O3Do+ROS/S8/g8R7v74BgS6GdHOAx2?= =?iso-8859-1?Q?XxddP2JyQsX9FI822gHgdBBYv4h8Se/UQuJsDkYPNQC6HzmdP5c2CSD2tD?= =?iso-8859-1?Q?Cb+3viPtydEQlF8CuMK1O/FcTAF9Ubeiio2rMdZmekqEx6ceomT0ZF0Rpo?= =?iso-8859-1?Q?WtX/s+sxMFgCIn67T0E9yn22COvf2rQHuns+HcoqSgAhBGICyz810aLhk+?= =?iso-8859-1?Q?eW3muNAFjxmU3nA2tlzUowg5Xio1zk43dGFpu6wStywfovwJPvbELxikyw?= =?iso-8859-1?Q?VpIMn7Gp1l1lXgJ3zjGzUhQrYXmHp5/zMntJ5kRl2ySSQCR6GeqxyLKd55?= =?iso-8859-1?Q?EaJmgiPqt1waduHZcaJtB+qvnf19HGii1UM56oQo9+hwtO9vHr/ZGcqc+i?= =?iso-8859-1?Q?KFVVS2GV5YZrs0n8ctuQyWyzRdg7HsvPR8WuRVOqA8AcOB+sp81m+9R7PT?= =?iso-8859-1?Q?6jTRC88X98CyyELcFWk8s67xKOL5k4ksW0+xsG8i1rN1Ew+fXSWOiltZRP?= =?iso-8859-1?Q?6ItvtOMTAu2GiHs29NAH4eqMg6G8rANnstzp2BepCsXP9z99MfrqpDf05c?= =?iso-8859-1?Q?Riff4GaL7Wn5RHF4Wu5fufmOmv1aqlHtsmUHHuwnkaPyKwxg6hqKFmWt3b?= =?iso-8859-1?Q?eEz3PDvrouQsMH0wCiIidzbwYMMciNepvdbtDld6RboN13Nw3Ex90sDYh+?= =?iso-8859-1?Q?A2kNT+YBmr68piOIW6XSNUjZlkB21+Kgaxy9WDdAHY5IJlJFqJJB5mt37L?= =?iso-8859-1?Q?CI3/I6Yk+q1v92/ewY5ymmyWaTmZV8WwrVWR8eroWImKUY77Cbddfgjkq7?= =?iso-8859-1?Q?Ad369nVjrL9wTqVOUK1lxf49ZOqQ8kraHb9q97etoVOYkwXq8mFQB9Aopm?= =?iso-8859-1?Q?1kl0RvueZMCPQRWnQqvVhMH1YI5SMVVu79eiRkJnCUz8OgNEwpMaNOJ8oJ?= =?iso-8859-1?Q?fJxp+xaJM2mUQKduA9Gde3yebVyvXkXX31YIdGznHEtKAzPaTLfbmSobTa?= =?iso-8859-1?Q?9ppDWH36jpx7ds0BiZ70+JTR/u6WAMgnAkowp7FclbCLjhTivmZ8l8i8o7?= =?iso-8859-1?Q?7p6RhwT0rc3FOl5JUiwjsGjSbaykg3MzekiUPCNhPTZzNWTiHuCJAx2w5w?= =?iso-8859-1?Q?2vCKHXFjcfjQuihWS7ymtO1kC5oLCCG3RIph2WwYVbzH/OKNfq9bkQk/uF?= =?iso-8859-1?Q?cOtED5bIzbWlMlPkpLv/XLzu80EXAjE9G+oA7y9cz397hUGvXPijzo5Uys?= =?iso-8859-1?Q?rZ4h7AswrSJQ7UZ2fmlSJltwKB1Jwl3vNhrRqWmxx00FDOomquFByx6cII?= =?iso-8859-1?Q?f0p15LC5r6YLTHDcRMaDYa6unNbH1qTxvAbekEi0koZLQsd80cV97NMn+c?= =?iso-8859-1?Q?jA+bs+mvv/q7UQ/eV4dXkLH7D9TleX4wt+4FGQmnd7TeB5qkQdmjj2P0gl?= =?iso-8859-1?Q?uK56KrtHofeQ57bs1puf5Axoeg+SnsJsapyNFvUQe/udiyf/2PAJ20RYn1?= =?iso-8859-1?Q?FawDSrKVlxxu38dBCrBMqdsZJU+rHOXaYSPAQlpx2hX6j0nyCkjU1vYLFU?= =?iso-8859-1?Q?gD3Ertw+0g=3D=3D?= Content-Type: multipart/alternative; boundary="_000_DB8P190MB073193B8E609885E3B11E73CF02A2DB8P190MB0731EURP_" MIME-Version: 1.0 X-OriginatorOrg: ulb.be X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: DB8P190MB0731.EURP190.PROD.OUTLOOK.COM X-MS-Exchange-CrossTenant-Network-Message-Id: 9ccf4a17-5fb5-4ebd-456b-08dea13458dc X-MS-Exchange-CrossTenant-originalarrivaltime: 23 Apr 2026 12:32:13.3903 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 30a5145e-75bd-4212-bb02-8ff9c0ea4ae9 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: +SZPOVxQJAfmgNUKPmbNgfBxETz8Iz5EPrLGrsmJliGBc1DAkGLZ1xwEIK21WywjFoD7O1zqoPoJlgtwoThJeQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: GVUP190MB2709 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_DB8P190MB073193B8E609885E3B11E73CF02A2DB8P190MB0731EURP_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Haibo, Thanks for creating the CommitFest entry. Could you add Diogo Repas, Zhicheng Luo, and Mahmoud Sakr as authors as well? They wrote the original patch and the underlying algorithm. The earlier CF entry is at https://commitfest.postgresql.org/patch/3821/ for reference. Regards, Maxime --_000_DB8P190MB073193B8E609885E3B11E73CF02A2DB8P190MB0731EURP_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi Haibo,

Thanks for creating the CommitFest entry. Could you add Diogo Repas,
Zhicheng Luo, and Mahmoud Sakr as authors as well? They wrote the
original patch and the underlying algorithm. The earlier CF entry is
at https://commitfest.postgresql.org/patch/3821/ for reference.

Regards,
Maxime
--_000_DB8P190MB073193B8E609885E3B11E73CF02A2DB8P190MB0731EURP_--