From: | Robert Haas <rhaas(at)postgresql(dot)org> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Reuse abbreviated keys in ordered [set] aggregates. |
Date: | 2016-02-17 10:12:46 |
Message-ID: | E1aVz6E-0006BN-43@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Reuse abbreviated keys in ordered [set] aggregates.
When processing ordered aggregates following a sort that could make use
of the abbreviated key optimization, only call the equality operator to
compare successive pairs of tuples when their abbreviated keys were not
equal.
Peter Geoghegan, reviewd by Andreas Karlsson and by me.
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/f1f5ec1efafe74ca45e24e0bf3371b1d6985c8ee
Modified Files
--------------
src/backend/catalog/index.c | 2 +-
src/backend/executor/nodeAgg.c | 16 ++++++--
src/backend/executor/nodeSort.c | 2 +-
src/backend/utils/adt/orderedsetaggs.c | 33 ++++++++++-----
src/backend/utils/sort/tuplesort.c | 74 ++++++++++++++++++++++++----------
src/include/utils/tuplesort.h | 4 +-
6 files changed, 92 insertions(+), 39 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-02-17 14:25:48 | Re: Re: [COMMITTERS] pgsql: Introduce group locking to prevent parallel processes from deadl |
Previous Message | Andres Freund | 2016-02-17 08:32:55 | Re: Re: [COMMITTERS] pgsql: Introduce group locking to prevent parallel processes from deadl |