ghiureai <isabella.ghiurea@xxxxxxxxxxxxxx> writes: > 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 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: postgres.consulting@xxxxxxxxxxx p: 312.241.7800 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
