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: (view raw, whole thread or download thread mbox)
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

George Essig

In response to


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-2017 The PostgreSQL Global Development Group