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

From Christopher Kings-Lynne
Subject Re: Foreign key slows down copy/insert
Date
Msg-id 425E8C0B.8060408@familyhealth.com.au
Whole thread Raw
In response to Re: Foreign key slows down copy/insert  (Richard van den Berg <richard.vandenberg@trust-factory.com>)
Responses Re: Foreign key slows down copy/insert
List 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

pgsql-performance by date:

Previous
From: Richard van den Berg
Date:
Subject: Re: Foreign key slows down copy/insert
Next
From: Tom Lane
Date:
Subject: Re: Foreign key slows down copy/insert