Re: Combining Aggregates

Поиск
Список
Период
Сортировка
От Atri Sharma
Тема Re: Combining Aggregates
Дата
Msg-id CAOeZVicT7E=_rNSO6=s6kQ_TY0_1-uKENW5Yi56oRg4=R93kaw@mail.gmail.com
обсуждение исходный текст
Ответ на Combining Aggregates  (Simon Riggs <simon@2ndQuadrant.com>)
Ответы Re: Combining Aggregates  (Petr Jelinek <petr@2ndquadrant.com>)
Re: Combining Aggregates  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers


On Wed, Dec 17, 2014 at 3:23 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
KaiGai, David Rowley and myself have all made mention of various ways
we could optimize aggregates.

Following WIP patch adds an extra function called a "combining
function", that is intended to allow the user to specify a
semantically correct way of breaking down an aggregate into multiple
steps.

Gents, is this what you were thinking? If not...



A quick look at the patch makes me assume that the patch does not handle the problem of combining transvals or move at all in that direction (which is fine, just reconfirming).

So, essentially, we are adding a "grand total" on top of individual sum() or count() operations,right?

Also, should we not have a sanity check for the user function provided?

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Combining Aggregates
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Some modes of vcregress not mentioned in MSVC scripts