MergeJoin beats HashJoin in the case of multiple hash clauses

Edit
ID 5114
Title MergeJoin beats HashJoin in the case of multiple hash clauses
Topic Performance
Created 2024-07-08 12:47:55
Last modified 2024-10-07 08:46:20 (5 days, 19 hours ago)
Latest email 2024-10-08 05:00:27 (4 days, 23 hours ago)
Status
2024-11: Needs review
2024-09: Moved to next CF
Target version
Authors Andrei Lepikhov (lepikhov)
Reviewers Become reviewer
Committer
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/5114
git checkout commitfest/cf/5114
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 2024-10-08 05:00:27 by Andrei Lepikhov <lepihov at gmail.com>
Latest 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>
    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
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