Re: Speeding up operations - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Speeding up operations
Date
Msg-id 10947.1060806363@sss.pgh.pa.us
Whole thread Raw
In response to Speeding up operations  ("Rahul_Iyer" <rahul_iyer@persistent.co.in>)
List pgsql-hackers
"Rahul_Iyer" <rahul_iyer@persistent.co.in> writes:
> im on a project using Postgres. The project involves, at times, upto
> 5,000,000 inserts. I was checking the performance of Postgres for 5M inserts
> into a 2 column table (one col=integer, 2nd col=character). I used the
> Prepare... and execute method, so i basically had 5M execute statements and
> 1 prepare statement. Postgres took 144min for this... is there any way to
> improve this performance?

COPY, perhaps.  Have you read
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=populate.html
        regards, tom lane


pgsql-hackers by date:

Previous
From: Frank Wiles
Date:
Subject: Re: Speeding up operations
Next
From: Rod Taylor
Date:
Subject: 7.4 beta1 plpgsql regression