Not working properly refers might be because updates or delete or inserts might be more than the scheduled vacuum.
On Fri, 18 Aug, 2023, 2:47 AM Holger Jakobs, <holger@jakobs.com> wrote:
Am 17.08.23 um 21:06 schrieb Rajesh Kumar: > These are parameters have reg autovacuum. Autovacuum is not running > properly. How to resolve this? > > autovacuum=on log_autovacuum_min_duration=0 autovacuum_max_workers=3 > autovacuum_naptime=1min autovacuum_vacuum_threshold=50 > autovacuum_analyze_threshold=50 autovacuum_vacuum_cost_limit=-1 > autovacuum_vacuum_cost_delay=2ms autovacuum_freeze_max_age=200000000 > autovacuum_vacuum_scale_factor=0.2 autovacuum_analyze_scale_factor=0.1
Every setting has to be on its own line.
To resolve problems, comment out all settings in the same way as it was after install.