Postgresql-8.2 manual has mentioned following points.
* The autovacuum daemon, when enabled, runs every autovacuum_naptime
* 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. By setting
autovacuum_naptime to 24*60*60 (# of seconds in a day), I can run the
daemon everyday. But, how do I ensure the daemon runs at 5am? What is
the "activity rounds" mentioned in the manual? Pl clarify. Appreciate an
Regards, Narasimha Murthy
Cell +91 95814 98895, +91-94940 62794 | 040-2347 2025 (O) | x2025 (O)
pgsql-admin by date
|Next:||From: Devrim GÜNDÜZ||Date: 2010-05-18 10:10:23|
|Subject: Re: Clarification Needed: When does autovacuum daemon run?|
|Previous:||From: Robert Treat||Date: 2010-05-15 17:58:03|
|Subject: Re: [HACKERS] List traffic|