From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Narasimha Murthy-VRFX87 <vrfx87@motorola.com>
Cc: Ian Lea <ian.lea@gmail.com>
Cc: Devrim GÜNDÜZ <devrim@gunduz.org>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Clarification Needed: When does autovacuum daemon run?
Date: Thu, 20 May 2010 13:20:04 -0400
Message-ID: <1274375829-sup-7935@alvh.no-ip.org> (raw)
In-Reply-To: <58FEF525AF1E664D9503ACDEAC926BBC03BE7D8D@ZMY16EXM66.ds.mot.com>
References: <58FEF525AF1E664D9503ACDEAC926BBC03BE7D8D@ZMY16EXM66.ds.mot.com>
Excerpts from Narasimha Murthy-VRFX87's message of jue may 20 02:47:21 -0400 2010:
> 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).
Yeah, you have no way to be know. I guess you could turn autovacuum off
in postgresql.conf all day, and exactly at 5am you have a cron job that
edits postgresql.conf and reloads Postgres. This would start up
autovacuum, which would then continue with the regular schedule.
This is hardly ideal; there were plans to improve on this by having an
autovacuum schedule, but I think the demand for this feature has
decreased considerable, so I haven't given it any minute's thought.
> 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).
Correct.
--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@alvh.no-ip.org, vrfx87@motorola.com, ian.lea@gmail.com, devrim@gunduz.org
Subject: Re: Clarification Needed: When does autovacuum daemon run?
In-Reply-To: <1274375829-sup-7935@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox