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

From: George Essig <george_essig(at)yahoo(dot)com>
To: Slavisa Garic <Slavisa(dot)Garic(at)infotech(dot)monash(dot)edu(dot)au>, pgsql-performance(at)postgresql(dot)org
Subject: Re: INSERT extremely slow with large data sets (fwd)
Date: 2003-11-14 22:02:38
Message-ID: 20031114220238.87764.qmail@web80210.mail.yahoo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message radha.manohar 2003-11-14 22:07:26 Re: Error in transaction processing
Previous Message Andrew Sullivan 2003-11-14 21:30:16 Re: Help with count(*)