git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 75f9c4c) | patch
Order active window clauses for greater reuse of Sort nodes.
2018年9月14日 16:35:42 +0000 (17:35 +0100)
2018年9月14日 16:35:42 +0000 (17:35 +0100)
commit 728202b63cdcd7fb73fdba114903ed235eb02f3a
Order active window clauses for greater reuse of Sort nodes.

By sorting the active window list lexicographically by the sort clause
list but putting longer clauses before shorter prefixes, we generate
more chances to elide Sort nodes when building the path.

Author: Daniel Gustafsson (with some editorialization by me)
Reviewed-by: Alexander Kuzmenkov, Masahiko Sawada, Tom Lane
Discussion: https://postgr.es/m/124A7F69-84CD-435B-BA0E-2695BE21E5C2%40yesql.se
src/backend/nodes/list.c diff | blob | blame | history
src/backend/optimizer/plan/planner.c diff | blob | blame | history
src/test/regress/expected/window.out diff | blob | blame | history
src/test/regress/sql/window.sql diff | blob | blame | history
This is the main PostgreSQL git repository.
RSS Atom

AltStyle によって変換されたページ (->オリジナル) /