On 8/18/23 22:35, Rihad wrote:
> On 8/17/23 13:01, rihad wrote:
>>
>> Hi, all. After calling pg_stat_reset all statistics used by autovacuum
>> got zeroed, and started accumulating from scratch. Some tables get
>> acted upon properly, some don't.
>>
>>
> Self-replying: yup, it seems there's an arbitrary limit of 100K of
> n_live_tup after which autovac/analyze kicks in, or it seems so.
To know rather then guess read:
https://www.postgresql.org/docs/current/routine-vacuuming.html#AUTOVACUUM
>
> There are still many tables waiting for their turn, which is long due.
>
> Although there are some tables having only 60-70 (not 60-70K) n_live_tup
> that have had autovacuum run on them. Weird.
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com