Re: Foreign key slows down copy/insert

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: Richard van den Berg <richard(dot)vandenberg(at)trust-factory(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Foreign key slows down copy/insert
Date: 2005-04-14 15:28:23
Message-ID: 1006.1113492503@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Markus Bertheau 2005-04-14 15:47:23 recovery after long delete
Previous Message Christopher Kings-Lynne 2005-04-14 15:28:11 Re: Foreign key slows down copy/insert