Re: Foreign key slows down copy/insert

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Foreign key slows down copy/insert
Дата
Msg-id 1006.1113492503@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Foreign key slows down copy/insert  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-performance
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> No it certainly won't warn you.  You have _avoided_ the check entirely.
>   That's why I was warning you...

> If you wanted to be really careful, you could:

Probably the better bet is to drop and re-add the FK constraint.

            regards, tom lane

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

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Foreign key slows down copy/insert
Следующее
От: Markus Bertheau
Дата:
Сообщение: recovery after long delete