Re: Autovacuum not running properly

On Mon, Sep 4, 2023 at 1:44 PM Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> wrote:
>
> The result I get "amount of tuples inserted" is not very clear. Let's say I get 10000 which is 10k , in this case, do you mean autovacuum will trigger for every 10k (inserts+updates+deletes) ?

Assuming you are referring to the value
autovacuum_vacuum_insert_threshold +
autovacuum_vacuum_insert_scale_factor * reltuples = 10k, then it means
that under 10k inserts, your table will not be vacuumed. With thed
default configuration, essentially you get vacuum running every time
you insert at least 20% of new tuples, and the same is for delete and
updates.

Please see <https://www.postgresql.org/docs/15/runtime-config-autovacuum.html>.

Luca