Re: Differences between int8 and int4 as pkeys and fkeys

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Thomas Swan <tswan(at)olemiss(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Differences between int8 and int4 as pkeys and fkeys
Date: 2000-08-05 02:28:32
Message-ID: 398B7BD0.29F6B732@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

> I had been using int8 as primary / foreign keys pairs. After joining
> several large tables on the keys, I noticed about a 30/40% speed
> improvement just in changing the keys from int8 to int4 data types.

Apparently it should be that much (though this is the first report
either way). Here are some reasons why there is the difference:

1) int4 is "pass by value", int8 is "pass by reference". So int8 hits
palloc() every time you generate a new one, whereas int4 may just copy
the data itself.

2) int8 is implemented in software libraries, at least on 32-bit
machines. int4 is implemented in hardware. Libraries are slower than
~1cycle hardware operations.

- Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alex Pilosov 2000-08-05 02:52:06 Re: libperl.so
Previous Message Michael Meskes 2000-08-04 23:26:32 Re: Embedded SQL C++ preprocessor ?

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-08-05 03:13:23 Re: Security choices...
Previous Message Thomas Lockhart 2000-08-05 02:20:20 Re: Installation Report for powerpc-apple-netbsdelf1.5