Re: Clarification Needed: When does autovacuum daemon run?

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Narasimha Murthy-VRFX87 <vrfx87(at)motorola(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Clarification Needed: When does autovacuum daemon run?
Date: 2010-05-18 14:51:10
Message-ID: 1274194230-sup-1696@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Excerpts from Narasimha Murthy-VRFX87's message of mar may 18 05:56:26 -0400 2010:
> Hello,
>
> Postgresql-8.2 manual has mentioned following points.
> * The autovacuum daemon, when enabled, runs every autovacuum_naptime
> seconds.
> * autovacuum_naptime (integer): Specifies the delay between "activity
> rounds" for the autovacuum daemon....The delay is measured in seconds,
> and the default is one minute (1m)....
>
> My Query: I want to run autovacuum daemon everyday at 5 am.

You cannot do that with autovacuum currently. Use cron.
--

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tena Sakai 2010-05-18 23:14:49 troubled by pg_dump and pg_restore
Previous Message Narasimha Murthy-VRFX87 2010-05-18 11:04:34 Re: Clarification Needed: When does autovacuum daemon run?