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