Re: Speeding up operations

On Wed, 13 Aug 2003 10:53:39 +0530
"Rahul_Iyer" <rahul_iyer@persistent.co.in> wrote:

> hi...
> 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? if so, how? btw, im
> using it on a SPARC/Solaris 2.6.
> thanx in adv
> rahul
> 
> P.S: Kindly point me towards any relevant documentation as well.
 If this is a one time insert you'll want to remove any indexes and rebuild them after the inserts are done.  
 Also you'll want to look into the COPY command here: 
 http://www.postgresql.org/docs/7.3/static/sql-copy.html
 Loading the data from file like this is probably going to be much faster than from a script and/or program. 
---------------------------------  Frank Wiles <frank@wiles.org>
http://frank.wiles.org---------------------------------