int8 vs int4

From: mljv(at)planwerk6(dot)de
To: pgsql-general(at)postgresql(dot)org
Subject: int8 vs int4
Date: 2007-07-17 15:41:02
Message-ID: 200707171741.02460.mljv@planwerk6.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-07-17 15:47:01 Re: createing indexes on large tables and int8
Previous Message Steve Atkins 2007-07-17 15:39:50 Re: yet another image: db or filesystem ? question