Clarification Needed: When does autovacuum daemon run?
| От | Narasimha Murthy-VRFX87 |
|---|---|
| Тема | Clarification Needed: When does autovacuum daemon run? |
| Дата | |
| Msg-id | 58FEF525AF1E664D9503ACDEAC926BBC03BE7D7A@ZMY16EXM66.ds.mot.com обсуждение исходный текст |
| Ответы |
Re: Clarification Needed: When does autovacuum daemon run?
Re: Clarification Needed: When does autovacuum daemon run? |
| Список | pgsql-admin |
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)
В списке pgsql-admin по дате отправления: