From: Alvaro Herrera <alvherre@commandprompt.com>
To: Chris Hoover <revoohc@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Autovacuum ideas
Date: Tue, 11 Apr 2006 19:52:56 -0400
Message-ID: <20060411235256.GD16405@surnet.cl> (raw)
In-Reply-To: <1d219a6f0604111602m62445e60h425c5dd59219606e@mail.gmail.com>
References: <1d219a6f0604111602m62445e60h425c5dd59219606e@mail.gmail.com>
Chris Hoover wrote:
> As far as I can tell, there is no way to tell the daemon to only do it's
> work between certain hours. Could this be added as an option? In my
> situation, I have tables that if vacuumed during the day would cause a
> noticeable slowdown to my users and has therefore been deemed unacceptable
> by management. This is one thing that is preventing me from turning on
> autovacuun,. However, due to the activity on them, they really need to be
> vacuumed daily. It would be nice to be able to tell autovacuum to run, but
> have a way to tell it to always sleep during these hours (i.e. 7am to 5pm
> daily). Has there been any thought into a feature like this?
Well, this is something that is (or should be) in the TODO list, but no
one has come around with a proposal to implement it yet. I've given it
tiny amounts of thought; a system not unlike Unix's crontab might do it.
You would specify intervals at which you wish autovacuum to operate on
certain groups of tables; or intervals at which you don't want autovac
to run at all, etc.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: alvherre@commandprompt.com, revoohc@gmail.com
Subject: Re: Autovacuum ideas
In-Reply-To: <20060411235256.GD16405@surnet.cl>
References: <1d219a6f0604111602m62445e60h425c5dd59219606e@mail.gmail.com> <20060411235256.GD16405@surnet.cl>
* 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