performance of foreign key constraints

Поиск
Список
Период
Сортировка
От teknokrat
Тема performance of foreign key constraints
Дата
Msg-id bildcd$232q$1@news.hub.org
обсуждение исходный текст
Ответы Re: performance of foreign key constraints  (Andrew Sullivan <andrew@libertyrms.info>)
Re: performance of foreign key constraints  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-performance
I have a table that has about 20 foreign key constraints on it. I think
this is a bit excessive and am considering removing them ( they are all
related to the same table and I don't think there is much chance of any
integrity violations ). Would this improve performance or not?

thanks


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

Предыдущее
От: "Matt Clark"
Дата:
Сообщение: Re: Hardware recommendations to scale to silly load
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: performance of foreign key constraints