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