pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.



view thread (14+ messages)  latest in thread

Message-ID: <20060411235256.GD16405@surnet.cl>
Permalink:  ../20060411235256.GD16405@surnet.cl/
Also on:    postgresql.org/message-id/20060411235256.GD16405@surnet.cl

 · 

reply

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