Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates

Поиск
Список
Период
Сортировка
От Andreas Karlsson
Тема Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates
Дата
Msg-id 544FB082.5090102@proxel.se
обсуждение исходный текст
Ответ на Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-hackers
Дерево обсуждения 
On 10/28/2014 04:01 PM, Heikki Linnakangas wrote:
> Moving on to other issues, isn't 128 bits too small to store the squares
> of the processed numbers? That could overflow..

Yeah, which is why stddev_*(int8) and var_*(int8) still have to use 
Numeric in the aggregate state. For the int2 and int4 versions it is 
fine to use __int128_t.

Andreas

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: Directory/File Access Permissions for COPY and Generic File Access Functions