MergeJoin beats HashJoin in the case of multiple hash clauses

Edit
ID 5114
Title MergeJoin beats HashJoin in the case of multiple hash clauses
CI (CFBot) Needs rebase! Needs rebase since 7 months. Failing since 7 months.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Topic Performance
Tags
Created 2024-07-08 12:47:55
Last modified 2025-04-24 14:04:42 (6 months ago)
Latest email 2025-07-20 00:05:58 (3 months ago)
Status
2025-03 (2025-03-01 – 2025-04-08): Committed
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
Target version
Authors Andrei Lepikhov (lepikhov)
Reviewers Become reviewer
Committer Alexander Korotkov (smagen)
Links
Emails
MergeJoin beats HashJoin in the case of multiple hash clauses
First at 2023-06-15 08:30:10 by Andrey Lepikhov <a.lepikhov at postgrespro.ru>
Latest at 2025-07-20 00:05:58 by Tender Wang <tndrwang at gmail.com>
Latest attachment (v3-0001-If-we-have-a-single-hashclause-list_copy-hashclau.patch) at 2025-07-08 00:52:13 from Tender Wang <tndrwang at gmail.com>
    Attachment (v3-0001-If-we-have-a-single-hashclause-list_copy-hashclau.patch) at 2025-07-08 00:52:13 from Tender Wang <tndrwang at gmail.com> (Patch: Yes)
    Attachment (v2-0001-If-we-have-a-single-hashclause-list_copy-hashclau.patch) at 2025-07-03 02:02:03 from Tender Wang <tndrwang at gmail.com> (Patch: Yes)
    Attachment (0001-Adjust-the-place-of-list_copy-in-estimate_multivaria.patch) at 2025-04-14 06:17:17 from Tender Wang <tndrwang at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Use-extended-stats-for-precise-estimation-of-buck.patch) at 2025-03-09 12:13:52 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Use-extended-statistics-for-precise-estimation-of.patch) at 2025-03-03 08:24:40 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Use-extended-statistics-for-precise-estimation-of.patch) at 2025-02-17 00:34:26 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Use-extended-statistics-for-precise-estimation-of.patch) at 2024-10-08 05:00:27 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (0001-Use-extended-statistics-for-precise-estimation-of-bu.patch) at 2024-07-08 12:45:15 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (fix_bucketsize_v2.diff) at 2023-09-11 08:04:22 from "Lepikhov Andrei" <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (diff_estimate.diff) at 2023-06-28 13:53:06 from Alena Rybakina <lena.ribackina at yandex.ru> (Patch: Yes)
    Attachment (q2.sql) at 2023-06-15 08:30:10 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: No)
History
When Who What
2025-04-24 14:04:42 Andrei Lepikhov (lepikhov) Closed in commitfest 2025-03 with status: Committed
2025-04-24 14:04:42 Andrei Lepikhov (lepikhov) Changed committer to smagen
2025-04-01 06:52:45 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2025-03-11 21:33:39 CFbot Patch needs rebase
2025-02-06 08:01:26 Andrei Lepikhov (lepikhov) Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-02 13:33:23 Dmitry Dolgov (erthalion) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-07 08:46:20 Andrei Lepikhov (lepikhov) Closed in commitfest 2024-09 with status: Moved to next CF
2024-07-08 12:48:10 Andrei Lepikhov (lepikhov) Changed authors to Andrei Lepikhov (lepikhov)
2024-07-08 12:47:55 Andrei Lepikhov (lepikhov) Attached mail thread 52257607-57f6-850d-399a-ec33a654457b@postgrespro.ru
2024-07-08 12:47:55 Andrei Lepikhov (lepikhov) Created patch record
Edit