Re: Foreign key slows down copy/insert

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Foreign key slows down copy/insert
Дата
Msg-id 425E8C0B.8060408@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Foreign key slows down copy/insert  (Richard van den Berg <richard.vandenberg@trust-factory.com>)
Ответы Re: Foreign key slows down copy/insert
Список pgsql-performance
> My problem with this really is that in my database it is hard to predict
> which inserts will be huge (and thus need FKs dissabled), so I would
> have to code it around all inserts. Instead I can code my own integirty
> logic and avoid using FKs all together.

Just drop the fk and re-add it, until postgres gets more smarts.

Chris

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

Предыдущее
От: Richard van den Berg
Дата:
Сообщение: Re: Foreign key slows down copy/insert
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Foreign key slows down copy/insert