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>
Cc: 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-15 13:13:38
Message-ID: 20031115131338.90329.qmail@web80208.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-performance
--- Slavisa Garic <Slavisa(dot)Garic(at)infotech(dot)monash(dot)edu(dot)au> wrote:
> 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
> 

VACUUM ANALYZE will reclaim disk space and update statistics used by the optimizer to help execute
queries faster.  This could speed up your inserts.  See
http://www.postgresql.org/docs/7.3/static/sql-vacuum.html.

George Essig

In response to

Responses

pgsql-performance by date

Next:From: radha.manoharDate: 2003-11-15 14:52:45
Subject: Re: Error in transaction processing
Previous:From: Dennis BjorklundDate: 2003-11-15 10:21:09
Subject: Re: Help with count(*)

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