From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Subject: Re: Insert performance
Date: Mon, 18 Aug 2003 11:51:32 +0530
Message-ID: <3F40BDC4.1605.9407ADF@localhost> (raw)
In-Reply-To: <200308161140.59764.josh@agliodbs.com>
References: <3F3E3B47.13828.333B51D9@localhost>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: shridhar_daithankar@persistent.co.in
Subject: Re: Insert performance
In-Reply-To: <3F40BDC4.1605.9407ADF@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox