On Wed, 13 Aug 2003 10:53:39 +0530 "Rahul_Iyer" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> http://frank.wiles.org --------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
