On 05/17/2012 11:30 AM, leaf_yxj wrote:
Hi Guys. Please help me about this.
For postgres database, it looks like we need analyze and vacuum all the
tables periodly. I need to write a script which can be executed in crontab.
I don't have any clues about that. I only know the command :
analyze tablename;
vacuum tablename;
Leave off the tablename to do the whole db. But (unless you are on a
really old version of PG) you really shouldn't need to manually vacuum
things as that is the job of the autovacuum process.
There are unusual situations that suggest a manual analyze. It should be
run right after a cluster for instance. But they are limited special cases.
What indicates that you need to vacuum or analyze via cron?
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
