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
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 ? |
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 |