Re: Decimal64 and Decimal128

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Decimal64 and Decimal128
Дата
Msg-id CAKJS1f_QuqK4bA5onggdF8iEE+Qw4P40eTWH+r9Jg2mgt8DMZA@mail.gmail.com
обсуждение исходный текст
Ответ на Decimal64 and Decimal128  (Feng Tian <ftian@vitessedata.com>)
Список pgsql-hackers

On 25 September 2015 at 08:29, Feng Tian <ftian@vitessedata.com> wrote:
Compared to numeric type, decimal64 arithmetics is about 2x faster, decimal128 is about 1.5x faster.  However, the cast between decimal and float4/8 is implemented rather naively and slow.   As always, it depends on workload, decimal may take more, or less space, may be slower if cast is frequently performed.

Are you able to share the processor vendor, and perhaps some other specs of the machine you obtained these results from?

Regards

David Rowley

--
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
 

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: No Issue Tracker - Say it Ain't So!
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: Decimal64 and Decimal128