Re: [ADMIN] Repeating autovacuum - Mailing list pgsql-admin

From David G. Johnston
Subject Re: [ADMIN] Repeating autovacuum
Date
Msg-id CAKFQuwZQ0jC2qrci7Q5HSNEH2qGH4DrzuNd143a1dwG=bGWWJw@mail.gmail.com
Whole thread Raw
In response to [ADMIN] Repeating autovacuum  (Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>)
Responses Re: [ADMIN] Repeating autovacuum  (Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>)
Re: [ADMIN] Repeating autovacuum  (Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>)
List 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 by date:

Previous
From: Ertan Küçükoğlu
Date:
Subject: [ADMIN] Repeating autovacuum
Next
From: Ertan Küçükoğlu
Date:
Subject: Re: [ADMIN] Repeating autovacuum