Horton

Allow incremental sorts for windowing functions

David Rowley <drowley@postgresql.org>

View on postgr.es
Commit: 62e221e1c01e3985d2b8e4b68c364f8486c327ab
Author: David Rowley <drowley@postgresql.org>
Date: 2020-09-15T11:44:45Z
Releases: 14.0 
Allow incremental sorts for windowing functions

This expands on the work done in d2d8a229b and allows incremental sort
to be considered during create_window_paths().

Author: David Rowley
Reviewed-by: Daniel Gustafsson, Tomas Vondra
Discussion: https://postgr.es/m/CAApHDvoOHobiA2x13NtWnWLcTXYj9ddpCkv9PnAJQBMegYf_xw%40mail.gmail.com

Files

PathChange+/−
src/backend/optimizer/plan/planner.c modified +34 −7
src/test/regress/expected/window.out modified +44 −0
src/test/regress/sql/window.sql modified +22 −0

Discussion