Re: [PERFORM] numeric data types

2004-05-16 Thread Neil Conway
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

Re: [PERFORM] numeric data types

2004-05-14 Thread Tom Lane
"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)

[PERFORM] numeric data types

2004-05-14 Thread Jaime Casanova
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