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

--- 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