Order windows to avoid Sort node between WindowAgg where sort result can be reused

Edit
Title Order windows to avoid Sort node between WindowAgg where sort result can be reused
Topic Performance
Created 2018-05-31 18:34:35
Last modified 2018-09-14 16:39:44 (2 months, 3 weeks ago)
Latest email 2018-09-14 16:38:28 (2 months, 3 weeks ago)
Status
2018-09: Committed
2018-07: Moved to next CF
Authors Daniel Gustafsson (d_gustafsson)
Reviewers Masahiko Sawada (masahikosawada), Alexander Kuzmenkov (akuzmenkov)Become reviewer
Committer Andrew Gierth (rhodiumtoad)
Links
Emails
Avoid extra Sort nodes between WindowAggs when sorting can be reused
First at 2018-05-30 16:19:48 by Daniel Gustafsson <daniel at yesql.se>
Latest at 2018-09-14 16:38:28 by Andrew Gierth <andrew at tao11.riddles.org.uk>
Latest attachment (0001-Order-active-window-clauses-for-greater-reuse-of-Sor.patch) at 2018-09-13 17:50:13 from Andrew Gierth <andrew at tao11.riddles.org.uk>
    Attachment (0001-Order-active-window-clauses-for-greater-reuse-of-Sor.patch) at 2018-09-13 17:50:13 from Andrew Gierth <andrew at tao11.riddles.org.uk> (Patch: Yes)
    Attachment (0001-Order-windows-on-partition-ordering-prefix-to-reuse-v6.patch) at 2018-07-27 19:12:02 from Alexander Kuzmenkov <a.kuzmenkov at postgrespro.ru> (Patch: Yes)
    Attachment (window_prefix_sort-v5.patch) at 2018-07-24 22:37:06 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (window_prefix_sort-v4.patch) at 2018-07-02 21:19:16 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (window_prefix_sort-v3.patch) at 2018-07-02 08:25:19 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (window_prefix_sort-v2.patch) at 2018-06-12 13:10:50 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (window_prefix_sort.patch) at 2018-05-30 16:19:48 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
History
When Who What
2018-09-14 16:39:44 Andrew Gierth (rhodiumtoad) Closed in commitfest 2018-09 with status: Committed
2018-09-11 20:42:12 Andrew Gierth (rhodiumtoad) Added rhodiumtoad as committer
2018-09-10 09:44:12 Alexander Kuzmenkov (akuzmenkov) New status: Ready for Committer
2018-08-10 22:18:48 Andrew Dunstan (adunstan) Closed in commitfest 2018-07 with status: Moved to next CF
2018-07-24 22:37:42 Daniel Gustafsson (d_gustafsson) New status: Needs review
2018-07-03 10:24:28 Masahiko Sawada (masahikosawada) New status: Waiting on Author
2018-07-02 21:21:06 Daniel Gustafsson (d_gustafsson) New status: Needs review
2018-07-02 12:01:27 Masahiko Sawada (masahikosawada) New status: Waiting on Author
2018-07-02 11:59:32 Masahiko Sawada (masahikosawada) Added masahikosawada as reviewer
2018-07-02 08:29:36 Daniel Gustafsson (d_gustafsson) New status: Needs review
2018-06-26 15:15:02 Alexander Kuzmenkov (akuzmenkov) New status: Waiting on Author
2018-06-26 15:14:49 Alexander Kuzmenkov (akuzmenkov) Added akuzmenkov as reviewer
2018-05-31 18:35:07 Daniel Gustafsson (d_gustafsson) Changed authors to Daniel Gustafsson (d_gustafsson)
2018-05-31 18:34:35 Daniel Gustafsson (d_gustafsson) Attached mail thread 124A7F69-84CD-435B-BA0E-2695BE21E5C2@yesql.se
2018-05-31 18:34:35 Daniel Gustafsson (d_gustafsson) Created patch record
Edit