Search Postgresql Archives

int8 vs int4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux