[ADMIN] autovacuum logs question

Поиск
Список
Период
Сортировка
Искать

[ADMIN] autovacuum logs question

От:
ghiureai <isabella.ghiurea@nrc-cnrc.gc.ca>
Дата:
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

Re: [ADMIN] autovacuum logs question

От:
Jerry Sievers <gsievers19@comcast.net>
Дата:
ghiureai  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@comcast.net
p: 312.241.7800

FAQ