| From: | SCHOEMANS Maxime <maxime(dot)schoemans(at)ulb(dot)be> |
|---|---|
| To: | Haibo Yan <tristan(dot)yim(at)gmail(dot)com> |
| Cc: | vignesh C <vignesh21(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Damir Belyalov <dam(dot)bel07(at)gmail(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, SAKR Mahmoud <mahmoud(dot)sakr(at)ulb(dot)be>, Diogo Repas <diogo(dot)repas(at)gmail(dot)com>, Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru> |
| Subject: | Re: Implement missing join selectivity estimation for range types |
| Date: | 2026-04-16 15:12:56 |
| Message-ID: | AM0P190MB07243E890A7DFD6F24F70269F0232@AM0P190MB0724.EURP190.PROD.OUTLOOK.COM |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Haibo,
Attached is v7 with the changes we discussed.
Patch 2 now has an inline comment on the && case explaining the
outer-bounds approximation and its consistency with existing restriction
selectivity. The commit message mentions it as well.
Patch 3 uses a separate backend-private header (rangetypes_selfuncs.h)
instead of selfuncs.h.
Regards,
Maxime
| Attachment | Content-Type | Size |
|---|---|---|
| v7-0001-Improve-range-join-selectivity-estimation-for.patch | application/octet-stream | 20.7 KB |
| v7-0002-Improve-multirange-join-selectivity-estimation-fo.patch | application/octet-stream | 26.6 KB |
| v7-0003-Remove-duplicate-selectivity-functions-between-ra.patch | application/octet-stream | 34.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2026-04-16 15:13:51 | Re: First draft of PG 19 release notes |
| Previous Message | Zhijie Hou (Fujitsu) | 2026-04-16 15:04:41 | RE: Parallel Apply |