Raghavendra Rao J S V wrote:
> Are you suggesting me to keep "autovacuum_vacuum_cost_limit" to zero or
> " autovacuum_vacuum_scale_factor" to zero or both? Please clarify me.
autovacuum_vacuum_cost_limit is effectively 100 by default.
You could raise it to 2000 or more.
If that does not take care of your problems, set autovacuum_vacuum_cost_delay to 0.
That will make autovacuum even more aggressive.
Do *not* set autovacuum_vacuum_scale_factor to 0. That will just cause autovacuum
to run all the time without getting anywhere. Sorry for trying to use irony in
e-mail; I am aware I shouldn't do that.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com