Hi Steve,
 
Thanks for your reply.
 
My Postgresql version is 8.2. I amn't sure we have the autovacuum job running 
or not? How can I check it ?
 
Thanks.
 
Grace





At 2012-05-18 02:53:15,"Steve Crawford" <scrawf...@pinpointresearch.com> wrote:
>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
>

Reply via email to