Re: Scheduling autovacuum

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Scheduling autovacuum
Дата
Msg-id BANLkTi=UUw5-DeakuzxUpP23Lzyd3auaMw@mail.gmail.com
обсуждение исходный текст
Ответ на Scheduling autovacuum  (Maalini Samuganardan <maalini.sam@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Maalini Samuganardan
Дата:
Сообщение: Scheduling autovacuum
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Passing the table name as a function argument in PLPGSQL