On Fri, 2004-05-14 at 17:08, Jaime Casanova wrote:
> is there any diff. in performance if i use smallint in place of integer?
Assuming you steer clear of planner deficiencies, smallint should be
slightly faster (since it consumes less disk space), but the performance
difference should be very smal
"Jaime Casanova" <[EMAIL PROTECTED]> writes:
> i have a question, is there any advantages in using numeric(1) or numeric(2)
> in place of smallint?
Performance-wise, smallint is an order of magnitude better.
regards, tom lane
---(end of broadcast)
Hi all,
i have a question, is there any advantages in using numeric(1) or numeric(2)
in place of smallint?
is there any diff. in performance if i use smallint in place of integer?
Thanx in advance,
Jaime Casanova
_
Help STOP SPAM wi