int8 vs int4 - Mailing list pgsql-general

From mljv@planwerk6.de
Subject int8 vs int4
Date
Msg-id 200707171741.02460.mljv@planwerk6.de
Whole thread Raw
Responses Re: int8 vs int4  (Richard Huxton <dev@archonet.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: yet another image: db or filesystem ? question
Next
From: Steve Atkins
Date:
Subject: Re: yet another image: db or filesystem ? question