Improve Hash/Merge Join estimate accuracy when all predicates are Hash/Merge clauses

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v4, Patch count: 2, First patch: +61−9, All patches: +83−11

Tags

Performance

Created

2026-09-09 13:02:56

Last modified

2026-09-09 13:02:56 (3 weeks ago)

Latest email

2026-09-28 10:51:27 (3 days ago)

Status

PG20-3 (2026-11-01 – 2026-11-30): Needs review

Target version

stable

Authors

Ilia Evdokimov (ilidock95)

Reviewers

Become reviewer

Committer

Links

Emails

Improve Hash/Merge Join estimate accuracy when all predicates are Hash/Merge clauses: First at 2025-07-10 10:09:48 by Ilia Evdokimov <ilya.evdokimov at tantorlabs.com>
Latest at 2026-09-28 10:51:27 by Ilia Evdokimov <ilya.evdokimov at tantorlabs.com>
Latest attachment (v4-0002-Use-exact-join-size-estimate-for-plain-inner-merg.patch) at 2026-09-28 10:51:27 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com>
    Attachment (v4-0002-Use-exact-join-size-estimate-for-plain-inner-merg.patch) at 2026-09-28 10:51:27 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: No)
    Attachment (v3-0001-Use-exact-join-size-estimate-for-plain-inner-merg.patch) at 2026-09-09 14:22:39 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: No)
    Attachment (v2-0001-Use-exact-join-size-estimate-for-plain-inner-merg.patch) at 2026-09-07 17:39:55 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: No)
    Attachment (v1-0001-Improve-row-count-estimates-for-hash-merge-joins.patch) at 2025-07-10 10:09:48 from Ilia Evdokimov <ilya.evdokimov at tantorlabs.com> (Patch: No)

History

When	Who	What
2026-09-27 12:44:30	Xiangxin Zeng (xiangxin-zeng)	Posted review with messageid <179051307018.1124.2392986466048370734.pgcf@coridan.postgresql.org>
2026-09-09 13:02:56	Ilia Evdokimov (ilidock95)	Attached mail thread 7abcff03-b38c-432f-81fa-d66abf0f061d@tantorlabs.com
2026-09-09 13:02:56	Ilia Evdokimov (ilidock95)	Created patch record