--- Slavisa Garic <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to