Re: Insert performance

From: "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Insert performance
Date: 2003-08-18 06:21:32
Message-ID: 3F40BDC4.1605.9407ADF@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message pginfo 2003-08-18 10:10:43 bad join preformance
Previous Message Tom Lane 2003-08-17 22:25:08 Re: 7.4 beta 1 getting out of swap