| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: COPY performance |
| Date: | 2002-04-13 19:18:59 |
| Message-ID: | 20020413121415.J86939-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On Sat, 13 Apr 2002, Nigel J. Andrews wrote:
> > Also, you should probably leave the foreign key reference off the table
> > and add it after you load the data.
>
> I should have mentioned that I'm doing the copy in to the table in a
> transaction block with all constraints deferred. That should mean it's only at
> the commit stage that foreign key will be checked right?
With the definition shown, I believe your constraint is not deferrable so
setting the constraint mode to deferred won't help. In any case it'd still
need to be saving the information on the triggers to run.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2002-04-13 19:19:34 | Re: COPY performance |
| Previous Message | Nigel J. Andrews | 2002-04-13 19:04:04 | Re: COPY performance |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2002-04-13 19:19:34 | Re: COPY performance |
| Previous Message | Nigel J. Andrews | 2002-04-13 19:04:04 | Re: COPY performance |