| From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Richard Guo <riguo(at)pivotal(dot)io>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Fix up grouping sets reorder |
| Date: | 2019-06-17 18:47:38 |
| Message-ID: | 87wohk124q.fsf@news-spur.riddles.org.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>>>>> "Andres" == Andres Freund <andres(at)anarazel(dot)de> writes:
>> During the reorder of grouping sets into correct prefix order, if
>> only one aggregation pass is needed, we follow the order of the
>> ORDER BY clause to the extent possible, to minimize the chance that
>> we add unnecessary sorts. This is implemented in
>> preprocess_grouping_sets --> reorder_grouping_sets.
Andres> Thanks for finding!
Andres> Andrew, could you take a look at that?
Yes.
--
Andrew (irc:RhodiumToad)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Korotkov | 2019-06-17 20:13:04 | Re: SQL/JSON path issues/questions |
| Previous Message | Stephen Frost | 2019-06-17 18:40:53 | Re: UCT (Re: pgsql: Update time zone data files to tzdata release 2019a.) |