Thread: Scheduling autovacuum

Scheduling autovacuum

From

Maalini Samuganardan

Date:

14 June 2011, 09:24:53

Hi,

I am currently doing a vacuum once a week. But i still see something called autovacuum that runs during peak hour which is causing high load. Is it possible to run this autovacuum during a specific time (non-peak time) using a scheduler?

Thank you
Regards,
Maalini

Re: Scheduling autovacuum

From

Simon Riggs

Date:

14 June 2011, 09:43:41

On Tue, Jun 14, 2011 at 9:59 AM, Maalini Samuganardan
<maalini.sam@gmail.com> wrote:

> I am currently doing a vacuum once a week. But i still see something called
> autovacuum that runs during peak hour which is causing high load. Is it
> possible to run this autovacuum during a specific time (non-peak time) using
> a scheduler?

There's a discussion of how to control this in the PostgreSQL Admin Cookbook
http://www.2ndquadrant.com/books/

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services