| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| 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-19 02:20:25 |
| Message-ID: | Pine.LNX.4.62.0504181917110.12937@hosting.commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> Since the database I am working on has many FKs, I would rather not have to
> drop/add them when I am loading large data sets.
You may want to hunt the archives. IIRCC I saw a couple of posts in the
recent months about an update you can do to one of the system tables to disable
the key checks and then re-enable them after your done with the import.
Sincerely,
Joshua D. Drake
>
--
Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564
Custom programming, 24x7 support, managed services, and hosting
Open Source Authors: plPHP, pgManage, Co-Authors: plPerlNG
Reliable replication, Mammoth Replicator - http://www.commandprompt.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-04-19 03:10:01 | Re: refcurosr vs. setof |
| Previous Message | Bruce Momjian | 2005-04-19 01:45:15 | Re: How to improve db performance with $7K? |