COPY with fk's slow

Поиск
Список
Период
Сортировка
От John Smith
Тема COPY with fk's slow
Дата
Msg-id 20030206072122.99305.qmail@web40702.mail.yahoo.com
обсуждение исходный текст
Ответы Re: COPY with fk's slow
Список pgsql-general

I'm playing around with importing 10,000 records into a table with a single index and a single foreign key. COPY takes roughly 10 minutes(!). However, if I drop the foreign key, COPY takes a couple seconds, THEN adding the foreign key back takes another few seconds. Any idea why COPY with a f/k takes so much longer? Any workarounds? Such as lock the table, drop fk, copy, add fk, unlock?

John

 



Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now

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

Предыдущее
От: Curt Sampson
Дата:
Сообщение: Re: Temporary and permanent tables with same name
Следующее
От: "Nigel J. Andrews"
Дата:
Сообщение: Re: Deleting orphan records