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

Edit
ID 7281
Title Improve Hash/Merge Join estimate accuracy when all predicates are Hash/Merge clauses
CI (CFBot) Summary
Stats (from CFBot) Patch version: v2, Patch count: 1, First patch: +7−1, All patches: +7−1
Tags Performance
Created 2026-09-09 13:02:56
Last modified 2026-09-09 13:02:56 (1 hour ago)
Latest email 2026-09-09 14:22:39 (10 minutes 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-09 14:22:39 by Ilia Evdokimov <ilya.evdokimov at tantorlabs.com>
Latest 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>
    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: Pending check)
    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-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
Edit