VACUUM vs VACUUM ANALYZE

From: "Mark Coffman" <mark(at)epilogue(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: VACUUM vs VACUUM ANALYZE
Date: 2001-10-18 18:33:06
Message-ID: 00a101c15803$63b9ed40$91010a0a@npinfocorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gould 2001-10-18 18:34:21 Re: Accessing PostgreSQL through Apache and PHP4 on Linux
Previous Message Jason Earl 2001-10-18 18:19:06 Re: newbie authentication/automated backup (pg_dumpall) questions

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-10-18 18:43:09 Re: may be bug in pg_dumpall in 7.0.3
Previous Message Tom Lane 2001-10-18 18:18:34 Re: To Postgres Devs : Wouldn't changing the select limit