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.
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 early reply.
Regards,
Narasimha Murthy
Cell +91 95814
98895, +91-94940 62794 | 040-2347 2025 (O) | x2025 (O)