Re: Autovacuum ideas - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: Autovacuum ideas
Date
Msg-id 1144799436.13511.28.camel@localhost.localdomain
Whole thread Raw
In response to Autovacuum ideas  ("Chris Hoover" <revoohc@gmail.com>)
Responses Re: Autovacuum ideas
List pgsql-admin
>   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... just turn off autovac and then use vacuumdb during off hours via
cron.

Joshua D. Drake

>
> Thanks,
>
> Chris
--

            === The PostgreSQL Company: Command Prompt, Inc. ===
      Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
      Providing the most comprehensive  PostgreSQL solutions since 1997
                     http://www.commandprompt.com/





pgsql-admin by date:

Previous
From: Anthony Ransley
Date:
Subject: Re: Autovacuum ideas
Next
From: Alvaro Herrera
Date:
Subject: Re: Autovacuum ideas