On Tuesday 17 July 2007 17:52:11 you wrote:
> [EMAIL PROTECTED] wrote:
> > 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?
>
> Almost certainly, but by how much will depend on your hardware and size
> of index.
>
> >
[EMAIL PROTECTED] wrote:
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?
Almost certainly, but by how much will depend on your hardware and size
of index.
int4 will reduze the size of the table, of course. Would this
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 menti
