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. My query in other word was, if I set autovacuum_naptime to 1 hr, which minute of an hour the auto-vacuum runs (oth min, 15th min or something else).
>From the clarification given by the you and other community members, I now >understood that autovacuum is designed to run frequently in the background, >not designed to run once a day at a specific time. Due to this design intent, >autovacuum_naptime is set to 1 min by default and autovacuum runs >lazy/plain/standard vacuum commands (so that Vacuum can run 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-ow...@postgresql.org [mailto:pgsql-admin-ow...@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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
