adjust the place of list_copy() call to reduce the overhead of function call and memory copies.

Edit
ID 5704
Title adjust the place of list_copy() call to reduce the overhead of function call and memory copies.
CI (CFBot) Summary
Stats (from CFBot) Patch version: v3, Patch count: 1, First patch: +2−1, All patches: +2−1
Topic Miscellaneous
Tags Performance
Created 2025-04-16 15:38:45
Last modified 2025-07-19 18:23:23 (3 months ago)
Latest email 2025-07-20 00:05:58 (3 months ago)
Status
PG19-1 (2025-07-01 – 2025-07-31): Committed
Target version
Authors Tender Wang (tndrwang)
Reviewers Become reviewer
Committer Tom Lane (tgl)
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-07-19 18:23:23 Tom Lane (tgl) Closed in commitfest PG19-1 with status: Committed
2025-07-19 18:23:23 Tom Lane (tgl) Changed committer to tgl
2025-07-07 02:52:01 Tender Wang (tndrwang) New status: Ready for Committer
2025-07-07 02:51:27 Tender Wang (tndrwang) Removed tndrwang from reviewers
2025-07-07 02:51:23 Tender Wang (tndrwang) Added tndrwang as reviewer
2025-07-02 06:17:24 Tender Wang (tndrwang) Changed tags to Performance
2025-04-16 15:38:46 Tender Wang (tndrwang) Attached mail thread 52257607-57f6-850d-399a-ec33a654457b@postgrespro.ru
2025-04-16 15:38:45 Tender Wang (tndrwang) Created patch record
Edit