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

ID 1653

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 (6 years, 2 months ago)

Latest email 2018-09-14 16:38:28 (6 years, 2 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 CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/1653
git checkout commitfest/cf/1653

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