Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group