Horton

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

Slavisa Garic <slavisa.garic@infotech.monash.edu.au>

View thread View on postgr.es
From: Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>
To: George Essig <george_essig@yahoo.com>
Cc: Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>, pgsql-performance@postgresql.org
Date: 2003-11-15T01:20:20Z
Lists: pgsql-performance 
Does VACUUM ANALYZE help with the analysis or it also speeds up the
process. I know i could try that before I ask but experiment is running
now and I am too curious to wait :),

Anyway thanks for the hint,
Slavisa

On Fri, 14 Nov 2003, George Essig wrote:

> 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
> 
>