Re: Autovacuum not running properly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


On Mon, Sep 4, 2023 at 1:44 PM Rajesh Kumar <rajeshkumar.dba09@xxxxxxxxx> 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

Please see <>.


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux