MergeAppend could consider sorting cheapest child path

Log in to edit
ID 5719
Title MergeAppend could consider sorting cheapest child path
CI (CFBot) Summary
Stats (from CFBot) Patch version: v9, Patch count: 1, First patch: +2−2, All patches: +2−2
Tags Performance
Created 2025-04-24 14:37:30
Last modified 2025-04-24 14:37:30 (1 year ago)
Latest email 2025-07-31 14:20:04 (1 year ago)
Status
PG19-1 (2025-07-01 – 2025-07-31): Needs review
Target version 19
Authors Andrei Lepikhov (lepikhov), Alexander Pyhalov (a.pyhalov)
Reviewers Log in to become reviewer
Committer
Links
Emails
MergeAppend could consider sorting cheapest child path
First at 2024-06-18 16:45:09 by Alexander Pyhalov <a.pyhalov at postgrespro.ru>
Latest at 2025-07-31 14:20:04 by Andrei Lepikhov <lepihov at gmail.com>
Latest attachment (v9-0001-Sketch.patch) at 2025-07-31 14:20:04 from Andrei Lepikhov <lepihov at gmail.com>
    Attachment (v9-0001-Sketch.patch) at 2025-07-31 14:20:04 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Add-some-penatly-to-gather-merge-and-merge-append.patch) at 2025-07-26 22:51:13 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (sort-vs-mergeappend.sql) at 2025-07-22 11:13:44 from Andrei Lepikhov <lepihov at gmail.com> (Patch: No)
    Attachment (merge_sort.sql) at 2025-06-03 13:23:47 from Andrei Lepikhov <lepihov at gmail.com> (Patch: No)
    Attachment (v5-0001-Consider-explicit-sort-of-the-MergeAppend-subpath.patch) at 2025-05-07 06:57:16 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (v4-0001-Consider-explicit-sort-of-the-MergeAppend-subpath.patch) at 2025-05-05 13:56:36 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (v3-0001-Consider-explicit-sort-of-the-MergeAppend-subpath.patch) at 2025-05-05 11:41:17 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Consider-explicit-sort-of-the-MergeAppend-subpath.patch) at 2025-05-05 11:38:39 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Consider-explicit-sort-of-the-MergeAppend-subpath.patch) at 2025-04-29 13:52:40 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (v0-0001-Consider-explicit-sort-of-the-MergeAppend-subpath.patch) at 2025-04-24 13:01:18 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (v2-0001-MergeAppend-could-consider-using-sorted-best-path.patch) at 2025-03-28 08:19:30 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
    Attachment (v1-0001-MergeAppend-could-consider-using-sorted-best-path.patch) at 2024-06-18 16:45:09 from Alexander Pyhalov <a.pyhalov at postgrespro.ru> (Patch: Yes)
History
When Who What
2025-04-24 14:37:30 Andrei Lepikhov (lepikhov) Attached mail thread 25d6a2cd161673d51373b7e07e6d9dd6@postgrespro.ru
2025-04-24 14:37:30 Andrei Lepikhov (lepikhov) Created patch record
Log in to edit