Re: Batch Insert Performance - Mailing list pgsql-general

From Peter Alberer
Subject Re: Batch Insert Performance
Date
Msg-id 000501c2a76c$441e7af0$5be0d089@ekelhardt
Whole thread Raw
In response to Batch Insert Performance  (Greg Stark <gsstark@mit.edu>)
Responses Re: Batch Insert Performance  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Hi greg,

here is an info page that could be useful for you: "Referential
Integrity Tutorial & Hacking" at
http://techdocs.postgresql.org/techdocs/hackingreferentialintegrity.php

But be careful, you have to deal with the system tables directly.

Have you tried selecting the data into a temp table and "copying" that
into the source_other_xref table? Could that be faster?

Ciao, peter



pgsql-general by date:

Previous
From: S Dawalt
Date:
Subject: Re: trouble caused by change in 7.3 handling of '' in
Next
From: Vivek Khera
Date:
Subject: Re: trouble caused by change in 7.3 handling of '' in