Postgres Pro
Downloads
Home   >   mailing lists

Re: Foreign key slows down copy/insert - Mailing list pgsql-performance

From Tom Lane
Subject Re: Foreign key slows down copy/insert
Date
Msg-id 1006.1113492503@sss.pgh.pa.us
Whole thread Raw
In response to Re: Foreign key slows down copy/insert  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-performance
Tree view 
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 by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Foreign key slows down copy/insert
Next
From: Markus Bertheau
Date:
Subject: recovery after long delete