Re: performance of foreign key constraints

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: performance of foreign key constraints
Дата
Msg-id 20030828172539.GA17195@libertyrms.info
обсуждение исходный текст
Ответ на performance of foreign key constraints  (teknokrat <teknokrat@yahoo.com>)
Список pgsql-performance
On Thu, Aug 28, 2003 at 06:15:57PM +0100, teknokrat wrote:
> 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?

Almost certainly.  But there's probably room for some middle ground
between 20 and none.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


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

Предыдущее
От: teknokrat
Дата:
Сообщение: performance of foreign key constraints
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: performance of foreign key constraints