pgsql: Doc: improve description of window function processing. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Doc: improve description of window function processing.
Date
Msg-id E1tre28-001lvS-33@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Doc: improve description of window function processing.

The previous wording talked about a "single pass over the data",
which can be read as promising more than intended (to wit, that only
one WindowAgg plan node will be used).  What we promise is only what
the SQL spec requires, namely that the data not get re-sorted between
window functions with compatible PARTITION BY/ORDER BY clauses.
Adjust the wording in hopes of making this clearer.

Reported-by: Christopher Inokuchi <cinokuchi@gmail.com>
Author: Tom Lane <tgl@sss.pgh.pa.us>
Reviewed-by: David G. Johnston <david.g.johnston@gmail.com>
Discussion: https://postgr.es/m/CABde6B5va2wMsnM79u_x=n9KUgfKQje_pbLROEBmA9Ru5XWidw@mail.gmail.com
Backpatch-through: 13

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/e7d29d1fac822d5a3dc2f7fafa5bd80a742f27af

Modified Files
--------------
doc/src/sgml/queries.sgml | 8 ++++----
1 file changed, 4 insertions(+), 4 deletions(-)


pgsql-committers by date:

Previous
From: Alexander Korotkov
Date:
Subject: pgsql: Teach Append to consider tuple_fraction when accumulating subpat
Next
From: Heikki Linnakangas
Date:
Subject: pgsql: Fix snapshot used in logical replication index lookup