Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Differences between int8 and int4 as pkeys and fkeys
<html><div>Perhaps a little off topic.</div> <br> <div>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.</div> <br> Should it affect it that much? <br> - <br> - <b><u>Thomas Swan</b> <x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab><x-tab> </x-tab><br> </u>- Graduate Student - Computer Science<br> - The University of Mississippi<br> - <br> - "People can be categorized into two fundamental <br> - groups, those that divide people into two groups <br> - and those that don't."</html>
Attachment: unknown_filename
Description: text/html (882 bytes)
Description: text/html (882 bytes)
In response to
- Re: random() function produces wrong range at 2000-08-04 18:28:28 from Christopher Masto
Responses
- Re: Differences between int8 and int4 as pkeys and fkeys at 2000-08-05 02:28:32 from Thomas Lockhart
pgsql-hackers by date
Next: From: Dale Anderson Date: 2000-08-04 20:58:42 Subject: Upper limit of a TEXT field Previous: From: Christopher Masto Date: 2000-08-04 18:28:28 Subject: Re: random() function produces wrong range
pgsql-general by date
Next: From: Dale Anderson Date: 2000-08-04 20:58:42 Subject: Upper limit of a TEXT field Previous: From: Philip Hallstrom Date: 2000-08-04 18:30:14 Subject: Re: Need for rebuilding index after many deletions?