Update and foreign key indices

Поиск
Список
Период
Сортировка
От Nikhil G. Daddikar
Тема Update and foreign key indices
Дата
Msg-id 004301c23c7c$f0089220$2c00a8c0@darkstar
обсуждение исходный текст
Ответы Re: Update and foreign key indices  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-general
Hello Folks,

I will ask my question through an example:


1) I have table PROJECT that has a foreign key USER_ID references USER(ID)

2) I *don't* use USER_ID in a where clause so don't have to create indices for performance reason. 

3) USER table's primary key *never* changes.

Q: Do I have to create an index for FK USER_ID to speed up updates to USER table rows?


Basically, is PG nice enough to understand that since a key is not updated, it need not check the integrity
constraints.


I am using PGSQL 7.1.3

Thanks.

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

Предыдущее
От: Valerie Schneider DSI/DEV
Дата:
Сообщение: Memory usage / concept
Следующее
От: Christian Ullrich
Дата:
Сообщение: Julian day calculation is wrong (strictly speaking)