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 small. Also, alignment/padding considerations may mean that smallint doesn't actually save any space anyway. -Neil ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]