Hi all,
Couple of days ago, one of my colleague, Rahul Iyer posted a query regarding
insert performance of 5M rows. A common suggestion was to use copy.
Unfortunately he can not use copy due to some constraints. I was helping him to
get maximum out of it. We were playing with a data set of 500K
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.
> I was really amazed to see the numbers. First of all, it beat the sunOS
> machine l
Martha Stewart called it a Good Thing [EMAIL PROTECTED] (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.
If
On Saturday, August 16, 2003, at 01:21 AM, Josh Berkus wrote:
Mixo,
I need to is measure the perfomance of a ticketing system (written in
perl)
which has web interface (html::mason, apache2) with Pg as a backend.
Users
of the ticketing system can only connect to the backend via the web
interf
