Re: performance of foreign key constraints

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: performance of foreign key constraints
Дата
Msg-id 1062097097.79027.214.camel@jester
обсуждение исходный текст
Ответ на Re: performance of foreign key constraints  (teknokrat <teknokrat@yahoo.com>)
Ответы Re: performance of foreign key constraints
Список pgsql-performance
> The references are all to the same table i.e. they are employee ids, so
> leaving some and not others would make no sense. The table has no
> deletes, small amount of inserts and moderate amount of updates. However
> there are many selects and its their performance I am most concerned with.

Foreign keys have no impact on selects.

Although this does sound like a rather strange design to me (20+ columns
wide and they're all employee ids?)

Вложения

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

Предыдущее
От: "Anders K. Pedersen"
Дата:
Сообщение: Re: Queries sometimes take 1000 times the normal time
Следующее
От: Bill Moran
Дата:
Сообщение: Re: The results of my PostgreSQL/filesystem performance