Discussion:
[ADMIN] autovacuum logs question
ghiureai
2017-07-11 18:07:27 UTC
Permalink
Hi ,
I am running Pgsql version 9.5.6 with :

autovacuum = on
log_autovacuum_min_duration = 0
autovacuum_naptime = 3min

I was hoping to see in errorlog all the stats time and CPU usage
for autovacumm operationfor all tables , but so far there is only one
and same table been logged , how about rest of them, the other
autovacuum param are disabled ( using the default values)
Thank you
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Jerry Sievers
2017-07-12 19:13:36 UTC
Permalink
Post by ghiureai
Hi ,
autovacuum = on
log_autovacuum_min_duration = 0
autovacuum_naptime = 3min
I was hoping to see in errorlog all the stats time and CPU usage
for autovacumm operationfor all tables , but so far there is only
one and same table been logged , how about rest of them, the other
autovacuum param are disabled ( using the default values)
Thank you
I assume autovac not visiting those tables due to insufficient churn.

Review the docs in regards to the threshold/scale settings that
determine how aggressive autovac is.
--
Jerry Sievers
Postgres DBA/Development Consulting
e: ***@comcast.net
p: 312.241.7800
--
Sent via pgsql-admin mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Loading...