Horton

Re: INSERT extremely slow with large data sets (fwd)

George Essig <george_essig@yahoo.com>

View thread View on postgr.es
From: George Essig <george_essig@yahoo.com>
To: Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>, pgsql-performance@postgresql.org
Date: 2003-11-14T22:02:38Z
Lists: pgsql-performance 
Slavisa Garic wrote:

> Hi Everyone,
 
> I am using PostgreSQL 7.3.2 and have used earlier versions (7.1.x 
> onwards) 
> and with all of them I noticed same problem with INSERTs when there is 
> a
> large data set. Just to so you guys can compare time it takes to insert
> one row into a table when there are only few rows present and when 
> there
> are thousands:

Try running VACUUM ANALYZE periodically during inserts.  I found this to help.

George Essig