Bruno BAGUETTE writes:
> How many memory does take numeric(3,0) ?
> Is it smaller than INT2 that takes 2 octets ?
numeric(x) takes about 10 + x/2 bytes in 7.3. I'm too lazy to calculate
it exactly, but int2 surely beats numeric in storage size and it kills it
in performance. The documentation contains information about choosing the
most appropriate data type:
http://www.postgresql.org/docs/7.3/static/datatype.html#DATATYPE-NUMERIC
--
Peter Eisentraut peter_e(at)gmx(dot)net