Re: Batch Insert Performance

From: "Peter Alberer" <h9351252(at)obelix(dot)wu-wien(dot)ac(dot)at>
To: "'Greg Stark'" <gsstark(at)mit(dot)edu>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Batch Insert Performance
Date: 2002-12-19 14:38:16
Message-ID: 000501c2a76c$441e7af0$5be0d089@ekelhardt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2002-12-19 14:54:50 Re: trouble caused by change in 7.3 handling of '' in
Previous Message S Dawalt 2002-12-19 14:01:32 Re: trouble caused by change in 7.3 handling of '' in