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.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
