Horton

VACUUM vs VACUUM ANALYZE

Mark Coffman <mark@epilogue.net>

View thread
From: "Mark Coffman" <mark@epilogue.net>
To: <pgsql-general@postgresql.org>
Date: 2001-10-18T18:33:06Z
Lists: pgsql-hackers 
I know the differences between VACUUM and VACUUM ANALYZE have been discussed
before, but I'd like to know how you schedule your cleaning jobs.  Right now
I do a

VACUUM
VACUUM ANALYZE

every hour... it takes about 3 minutes to run both.  Should I run ANALYZE
less often?

Mark
Epilogue.net