Re: [ADMIN] Repeating autovacuum

Поиск
Список
Период
Сортировка
От Ertan Küçükoğlu
Тема Re: [ADMIN] Repeating autovacuum
Дата
Msg-id DDB88FC4-A773-4D39-8507-5929B106DC81@1nar.com.tr
обсуждение исходный текст
Ответ на Re: [ADMIN] Repeating autovacuum  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: [ADMIN] Repeating autovacuum  (Keith <keith@keithf4.com>)
Список pgsql-admin


On 8 Apr 2017, at 01:53, David G. Johnston <david.g.johnston@gmail.com> wrote:

On Fri, Apr 7, 2017 at 3:35 PM, Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr> wrote:
No autovacuum parameters are changed or used. They are all remarked as in
default config file.

I wonder if that is a normal behavior as system is idle.

​See "autovacuum_naptime (integer)"


Its "auto" vacuum which means it runs (nearly) continuously looking for things to do.

I suppose that in theory it could operate in a kind of "wait/notify" mode where every DDL against the database wakes the daemon otherwise it stays asleep.  I recall some work being done a number of years back on making the system more energy efficient during no-activity periods - but there are trade-offs to consider here for which I am not up-to-speed on the specifics.

It would be interesting to see the timestamps on those log entries...

David J.

I don't see any timestamp in the log. I myself wanted that, too. Do I need to turn some switch on?

Ertan Küçükoğlu

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [ADMIN] Repeating autovacuum
Следующее
От: stevenchang1213
Дата:
Сообщение: Re: [ADMIN] How do you manage cluster replication and failover ?