Differences between int8 and int4 as pkeys and fkeys

Поиск
Список
Период
Сортировка
От Thomas Swan
Тема Differences between int8 and int4 as pkeys and fkeys
Дата
Msg-id 4.3.2.7.2.20000804145754.00b322c0@sunset.backbone.olemiss.edu
обсуждение исходный текст
Ответ на Re: random() function produces wrong range  (Christopher Masto <chris@netmonger.net>)
Список pgsql-hackers
<div>Perhaps a little off topic.</div><br /><div>I had been using int8 as primary / foreign keys pairs.   After joining
severallarge tables on the keys, I noticed about a 30/40% speed improvement just in changing the keys from int8 to int4
datatypes.</div><br /> Should it affect it that much? <br /> - <br /> - <b><u>Thomas Swan</u></b>
                                  <br/> - 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." 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Christopher Masto
Дата:
Сообщение: Re: random() function produces wrong range
Следующее
От: Lamar Owen
Дата:
Сообщение: Re: [GENERAL] Upper limit of a TEXT field