Re: Autovacuum not working peoperly

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(at)jakobs(dot)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.
>
> Then try them step by step.
>
>
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>
>