Horton

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

George Essig <george_essig@yahoo.com>

View thread View on postgr.es
From: George Essig <george_essig@yahoo.com>
To: Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>
Cc: Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>, pgsql-performance@postgresql.org
Date: 2003-11-15T13:13:38Z
Lists: pgsql-performance 
--- Slavisa Garic <Slavisa.Garic@infotech.monash.edu.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