Re: Decimal64 and Decimal128 - Mailing list pgsql-hackers

From David Rowley
Subject Re: Decimal64 and Decimal128
Date
Msg-id CAKJS1f_QuqK4bA5onggdF8iEE+Qw4P40eTWH+r9Jg2mgt8DMZA@mail.gmail.com
Whole thread Raw
In response to Decimal64 and Decimal128  (Feng Tian <ftian@vitessedata.com>)
List 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 by date:

Previous
From: Josh Berkus
Date:
Subject: Re: No Issue Tracker - Say it Ain't So!
Next
From: Thomas Munro
Date:
Subject: Re: Decimal64 and Decimal128