Hi Alvaro Herrera,
Since, my original plan was to run the auto-vacuum daily EXACTLY at 5 am, I wanted to know which seconds of a minute.
Myquery in other word was, if I set autovacuum_naptime to 1 hr, which minute of an hour the auto-vacuum runs (oth min,
15thmin or something else).
From the clarification given by the you and other community members, I now understood that autovacuum is designed to
runfrequently in the background, not designed to run once a day at a specific time. Due to this design intent,
autovacuum_naptimeis set to 1 min by default and autovacuum runs lazy/plain/standard vacuum commands (so that Vacuum
canrun concurrently with other normal DB operations).
Regards, Narasimha Murthy
Cell +91 95814 98895, +91-94940 62794 | 040-2347 2025 (O) | x2025 (O)
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Alvaro Herrera
Sent: Thursday, May 20, 2010 2:21 AM
To: Narasimha Murthy-VRFX87
Cc: Ian Lea; Devrim GÜNDÜZ; pgsql-admin
Subject: Re: [ADMIN] Clarification Needed: When does autovacuum daemon run?
Excerpts from Narasimha Murthy-VRFX87's message of mar may 18 07:04:34 -0400 2010:
> I need some more clarification. autovacuum_naptime takes one minute by
> default. In this case, which second of each minute the autovacuum
> daemon runs (provided it is enabled)?
Why does it matter which second it runs?
> What is the "activity rounds" mentioned in the manual??
Each worker start is a new round.
--
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
