Re: Foreign key slows down copy/insert

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Richard van den Berg <richard(dot)vandenberg(at)trust-factory(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Foreign key slows down copy/insert
Date: 2005-04-14 15:28:11
Message-ID: 425E8C0B.8060408@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-04-14 15:28:23 Re: Foreign key slows down copy/insert
Previous Message Richard van den Berg 2005-04-14 15:25:36 Re: Foreign key slows down copy/insert