Re: Numeric performances - Mailing list pgsql-general

From Lincoln Yeoh
Subject Re: Numeric performances
Date
Msg-id 200706040944.l549ig3r069459@smtp1.jaring.my
Whole thread Raw
In response to Re: Numeric performances  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Numeric performances  (PFC <lists@peufeu.com>)
List pgsql-general
At 01:42 AM 6/1/2007, Alvaro Herrera wrote:
>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.

I suspect it's still useful to know what order of
magnitude slower it is. After all if it is 1000x
slower (not saying it is), some people may decide
it's not worth it or roll their own.

Any hints/gotchas for/when doing such performance tests?

Regards,
Link.


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: changing 'mons' in interval?
Next
From: "Albe Laurenz"
Date:
Subject: Re: Tablespaces