Re: Numeric performances - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Numeric performances
Date
Msg-id 20070531174220.GB18911@alvh.no-ip.org
Whole thread Raw
In response to Numeric performances  (Vincenzo Romano <vincenzo.romano@gmail.com>)
Responses Re: Numeric performances
Re: Numeric performances
List pgsql-general
Vincenzo Romano escribió:
> Hi all.
> I'd like to know whether there is any "real world" evaluation (aka test) on
> performances of the NUMERIC data type when compared to FLOAT8 and FLOAT4.
> The documentation simply says that the former is "much slower" than the latter
> ones.

It is.  But why do you care?  You either have the correctness that
NUMERIC gives, or you don't.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: "Ian Harding"
Date:
Subject: Re: Design Table & Search Question
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Design Table & Search Question