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

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates
Дата
Msg-id 544FAFB9.5020106@vmware.com
обсуждение исходный текст
Ответ на Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates  (Andreas Karlsson <andreas@proxel.se>)
Ответы Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates  (Andreas Karlsson <andreas@proxel.se>)
Список pgsql-hackers
On 10/28/2014 04:47 PM, Andreas Karlsson wrote:
> On 10/28/2014 03:40 PM, Heikki Linnakangas wrote:
>> The patch doesn't do division with the 128-bit integers. It only does
>> addition and multiplication. Those are pretty straightforward to implement.
>
> The patch uses division when converting from __int128_t to Numeric.

Oh, I see. Hmph, looks like I'm losing an argument..

Moving on to other issues, isn't 128 bits too small to store the squares 
of the processed numbers? That could overflow..

- Heikki




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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: alter user/role CURRENT_USER
Следующее
От: Andreas Karlsson
Дата:
Сообщение: Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates