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

Title

Topic

Performance

Created

2018-05-31 18:34:35

Last modified

2018-09-14 16:39:44 (5 years, 7 months ago)

Latest email

2018-09-14 16:38:28 (5 years, 7 months ago)

Status

2018-09: Committed

2018-07: Moved to next CF

Target version

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