Postgres Pro
Downloads
Home   >   mailing lists

Re: INSERT extremely slow with large data sets (fwd) - Mailing list pgsql-performance

From George Essig
Subject Re: INSERT extremely slow with large data sets (fwd)
Date
Msg-id 20031114220238.87764.qmail@web80210.mail.yahoo.com
Whole thread Raw
In response to INSERT extremely slow with large data sets (fwd)  (Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>)
Responses Re: INSERT extremely slow with large data sets (fwd)  (Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Help with count(*)
Next
From:
Date:
Subject: Re: Error in transaction processing