Postgres Pro
Downloads
Home   >   mailing lists

Re: Clarification Needed: When does autovacuum daemon run? - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Clarification Needed: When does autovacuum daemon run?
Date
Msg-id 1274194230-sup-1696@alvh.no-ip.org
Whole thread Raw
In response to Clarification Needed: When does autovacuum daemon run?  ("Narasimha Murthy-VRFX87" <VRFX87@motorola.com>)
List pgsql-admin
Tree view 
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.
--

pgsql-admin by date:

Previous
From: "Narasimha Murthy-VRFX87"
Date:
Subject: Re: Clarification Needed: When does autovacuum daemon run?
Next
From: Tena Sakai
Date:
Subject: troubled by pg_dump and pg_restore