Implement missing join selectivity estimation for range types

Edit
ID 6668
Title Implement missing join selectivity estimation for range types
CI (CFBot) Summary
Stats (from CFBot) Patch version: v9, Patch count: 3, First patch: +655−3, All patches: +1219−656
Tags
Created 2026-04-10 22:53:17
Last modified 2026-10-01 00:00:10 (22 hours ago)
Latest email 2026-09-18 22:53:08 (1 week ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
Target version
Authors Haibo Yan (billyean), Maxime Schoemans (mschoema), Mahmoud SAKR (mahmsakr), Diogo Repas (diogo.repas), Zhicheng Luo (zcsysu.163.com)
Reviewers Bryan Green (lispyone) Become reviewer
Committer
Links
Emails
Implement missing join selectivity estimation for range types
First at 2022-06-30 14:31:30 by Mahmoud Sakr <mahmoud.sakr at ulb.be>
Latest at 2026-09-18 22:53:08 by Haibo Yan <tristan.yim at gmail.com>
Latest attachment (v9-0001-Improve-range-join-selectivity-estimation-for.patch) at 2026-09-18 22:53:08 from Haibo Yan <tristan.yim at gmail.com>
    Attachment (v9-0001-Improve-range-join-selectivity-estimation-for.patch) at 2026-09-18 22:53:08 from Haibo Yan <tristan.yim at gmail.com> (Patch: No)
    Attachment (v8-0001-Improve-range-join-selectivity-estimation-for.patch) at 2026-04-21 13:54:33 from SCHOEMANS Maxime <maxime.schoemans at ulb.be> (Patch: Yes)
    Attachment (v7-0001-Improve-range-join-selectivity-estimation-for.patch) at 2026-04-16 15:12:56 from SCHOEMANS Maxime <maxime.schoemans at ulb.be> (Patch: Yes)
    Attachment (v6-0001-Improve-range-join-selectivity-estimation-for.patch) at 2026-04-14 14:03:07 from SCHOEMANS Maxime <maxime.schoemans at ulb.be> (Patch: Yes)
    Attachment (v5-0001-Improve-range-range-join-selectivity-estimation.patch) at 2026-04-06 23:32:02 from Haibo Yan <tristan.yim at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Join-Selectivity-Estimation-for-Range-types.patch) at 2024-01-05 17:39:50 from Schoemans Maxime <maxime.schoemans at ulb.be> (Patch: Yes)
    Attachment (changes.diff.txt) at 2023-11-30 14:50:36 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: Yes)
    Attachment (v3-0001-Join-Selectivity-Estimation-for-Range-types.patch) at 2023-11-20 20:17:22 from Schoemans Maxime <maxime.schoemans at ulb.be> (Patch: Yes)
    Attachment (v2-0001-Join-Selectivity-Estimation-for-Range-types.patch) at 2023-07-07 15:40:43 from Schoemans Maxime <maxime.schoemans at ulb.be> (Patch: Yes)
    Attachment (v2-0002-apply-division-before-adding-remainder.patch) at 2023-06-19 16:26:09 from Schoemans Maxime <maxime.schoemans at ulb.be> (Patch: Yes)
    Attachment (v1-0002-apply-division-before-adding-remainder.patch) at 2023-06-19 09:49:22 from Schoemans Maxime <maxime.schoemans at ulb.be> (Patch: Yes)
    Attachment (v1-0001-Join-Selectivity-Estimation-for-Range-types.patch) at 2022-06-30 14:31:30 from Mahmoud Sakr <mahmoud.sakr at ulb.be> (Patch: Yes)
History
When Who What
2026-10-01 00:00:10 CFbot Moved from CF PG20-2 to CF PG20-3
2026-09-18 20:41:01 Bryan Green (lispyone) Added lispyone as reviewer
2026-08-11 12:12:23 Maxime Schoemans (mschoema) Moved from CF PG20-1 to CF PG20-2
2026-04-24 18:42:39 Haibo Yan (billyean) Changed authors to Mahmoud SAKR (mahmsakr), Diogo Repas (diogo.repas), Maxime Schoemans (mschoema), Zhicheng Luo (zcsysu.163.com), Haibo Yan (billyean)
2026-04-24 18:42:14 Haibo Yan (billyean) Changed authors to Mahmoud SAKR (mahmsakr), Diogo Repas (diogo.repas), Maxime Schoemans (mschoema), Haibo Yan (billyean)
2026-04-23 02:23:40 Haibo Yan (billyean) Changed authors to Maxime Schoemans (mschoema), Haibo Yan (billyean)
2026-04-10 22:53:17 Haibo Yan (billyean) Attached mail thread CAB4o4asMq3k6HN9WfDsssQ5DDVfAziB4TpiFJ8RBJgZTVuwC7g@mail.gmail.com
2026-04-10 22:53:17 Haibo Yan (billyean) Created patch record
Edit