MergeAppend could consider sorting cheapest child path

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
Topic Performance
Tags
Created 2025-04-24 14:37:30
Last modified 2025-04-24 14:37:30 (6 months ago)
Latest email 2025-07-31 14:20:04 (2 months ago)
Status
PG19-1 (2025-07-01 – 2025-07-31): Needs review
Target version 19
Authors Andrei Lepikhov (lepikhov), Alexander Pyhalov (a.pyhalov)
Reviewers 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
Edit