I use int8 types in most PK or FK columns in a pg 8.1 database.
Would int4 instead of int8 speed up creation of an index?
int4 will reduze the size of the table, of course. Would this reduce size of
index, too? By the same amount?
How much speed up will i gain on queries? Postgresql Doc mentions a speed-up.
Is it more like 0,1%, 1% or 10% speed-up?
kind regards
Janning
--
kind regards,
janning