Re: scheduling autovacuum at lean hours only.

Поиск
Список
Период
Сортировка
От Glyn Astill
Тема Re: scheduling autovacuum at lean hours only.
Дата
Msg-id 920307.27884.qm@web23606.mail.ird.yahoo.com
обсуждение исходный текст
Ответ на scheduling autovacuum at lean hours only.  (Rajesh Kumar Mallah <mallah.rajesh@gmail.com>)
Список pgsql-performance
> From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>

> Is it possible to configure autovacuum to run only
> during certain hours ? We are forced to keep
> it off because it pops up during the peak
> query hours.

AFAIK not directly within the conf.

However you could probably set up a shell script to turn it on and off as and when required via cron; just change the
settingto off in the conf file and reload. 




В списке pgsql-performance по дате отправления:

Предыдущее
От: Rajesh Kumar Mallah
Дата:
Сообщение: scheduling autovacuum at lean hours only.
Следующее
От: Guillaume Cottenceau
Дата:
Сообщение: Re: scheduling autovacuum at lean hours only.