Re: Scheduling autovacuum - Mailing list pgsql-novice

From Simon Riggs
Subject Re: Scheduling autovacuum
Date
Msg-id BANLkTi=UUw5-DeakuzxUpP23Lzyd3auaMw@mail.gmail.com
Whole thread Raw
In response to Scheduling autovacuum  (Maalini Samuganardan <maalini.sam@gmail.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Maalini Samuganardan
Date:
Subject: Scheduling autovacuum
Next
From: Andreas Kretschmer
Date:
Subject: Re: Passing the table name as a function argument in PLPGSQL