On Sun, Jan 11, 2004 at 21:53:09 +0700,
David Garamond <[EMAIL PROTECTED]> wrote:
>
> My concern is that, the PostgreSQL docs says NUMERIC & DECIMAL is very
> slow compared to INT/BIGINT. Should I worry about that?
Most likely disk IO not cpu will be your bottleneck and the extra overhead
of numeric relative to int or float won't be a big deal.
Numeric is stored usingh based 10000 (at least in 7.4.x) and hence isn't
that horrible performance-wise (as compared to say storing it as an ascii
string).
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
