Re: Autovacuum Running Timeframe

Поиск
Список
Период
Сортировка
От jaime soler
Тема Re: Autovacuum Running Timeframe
Дата
Msg-id 1473762979.896.3.camel@gmail.com
обсуждение исходный текст
Ответ на Re: Autovacuum Running Timeframe  (Gaetano Mendola <mendola@gmail.com>)
Ответы Re: Autovacuum Running Timeframe  (Amar <amarno1@gmail.com>)
Список pgsql-admin
Дерево обсуждения
El lun, 12-09-2016 a las 22:39 +0000, Gaetano Mendola escribió:

Are you sure, that's not the recommended use.


I also don't recommend to disable autovacuum why don't you programme a batch task that executes vacuum in  low activity hours


On Mon, Sep 5, 2016, 11:46 Amar <amarno1@gmail.com> wrote:
Hi Dimitris,

I would suggest to manually schedule database vacuum using cron jobs, instead of relaying on auto-vacuum.

Regards,
Amar

On Mon, Sep 5, 2016 at 10:41 AM, Κοκμάδης Δημήτριος <dkokmadis@gmail.com> wrote:
Hello,

I have a problem with autovacuum 

It runs randomly, so when it runs in websites high traffic hours it causes problems with site speed.

Is it possible to define specific timezone when autovacuum process could run?

Regards,

Dimitris 




--
~Amar

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

Предыдущее
От: jaime soler
Дата:
Сообщение: Re: How to list ALL PostgreSQL functions?
Следующее
От: Amar
Дата:
Сообщение: Re: Autovacuum Running Timeframe