MergeJoin beats HashJoin in the case of multiple hash clauses

Edit
Title MergeJoin beats HashJoin in the case of multiple hash clauses
Topic Performance
Created 2024-07-08 12:47:55
Last modified 2024-07-08 12:48:10 (6 days, 22 hours ago)
Latest email 2024-07-08 12:45:15 (6 days, 22 hours ago)
Status
2024-09: Needs review
Target version
Authors Andrei Lepikhov (lepikhov)
Reviewers Become reviewer
Committer
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 2024-07-08 12:45:15 by Andrei Lepikhov <lepihov at gmail.com>
Latest 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>
    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-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