Re: [ADMIN] Repeating autovacuum

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [ADMIN] Repeating autovacuum
Дата
Msg-id CAKFQuwZQ0jC2qrci7Q5HSNEH2qGH4DrzuNd143a1dwG=bGWWJw@mail.gmail.com
обсуждение исходный текст
Ответ на [ADMIN] Repeating autovacuum  (Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>)
Ответы Re: [ADMIN] Repeating autovacuum
Re: [ADMIN] Repeating autovacuum
Список pgsql-admin
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.

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

Предыдущее
От: Ertan Küçükoğlu
Дата:
Сообщение: [ADMIN] Repeating autovacuum
Следующее
От: Ertan Küçükoğlu
Дата:
Сообщение: Re: [ADMIN] Repeating autovacuum