Re: INSERT extremely slow with large data sets (fwd) - Mailing list 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
>
>