Re: Insert performance - Mailing list pgsql-performance

From Shridhar Daithankar
Subject Re: Insert performance
Date
Msg-id 3F40BDC4.1605.9407ADF@localhost
Whole thread Raw
In response to Re: Insert performance  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Insert performance
List pgsql-performance
On 16 Aug 2003 at 11:40, Josh Berkus wrote:

> Shridhar,
>
> > Unfortunately he can not use copy due to some constraints.
>
> Why not use COPY to load the table, and then apply the constraints by query
> afterwords?  It might not be faster, but then again it might.

Lol.. The constraints I mentioned weren't database constraints.. It need to
interface with another database module.. The data import can not be text..
that's a project requirement..

I should have been clearer in first place..

Bye
 Shridhar

--
O'Toole's commentary on Murphy's Law:    Murphy was an optimist.


pgsql-performance by date:

Previous
From: David Emery
Date:
Subject: Re: Benchmark
Next
From: pginfo
Date:
Subject: bad join performance