From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Autovacuum not working peoperly
Date: Thu, 17 Aug 2023 16:14:12 -0500
Message-ID: <373a8862-40ab-530b-648d-8c7182ff7c38@gmail.com> (raw)
In-Reply-To: <CAJk5AtbbdNaPpDY3ghKPU4_Cp5BXmn0Y2wnrwRWEYFwfYYEqtA@mail.gmail.com>
References: <CAJk5AtbbdNaPpDY3ghKPU4_Cp5BXmn0Y2wnrwRWEYFwfYYEqtA@mail.gmail.com>
On 8/17/23 14:06, Rajesh Kumar wrote:
> 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
Please clarify "not working properly".
--
Born in Arizona, moved to Babylonia.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Autovacuum not working peoperly
In-Reply-To: <373a8862-40ab-530b-648d-8c7182ff7c38@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox