Message-ID: <f0e1c85b53d81c0b2dd77ee190031124d4438895.camel@cybertec.at>
Subject: Re: autovacuum_vacuum_cost_limit
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Henry Francisco Garcia Cortez <garcortez@gmail.com>,
	pgsql-admin@lists.postgresql.org, david.g.johnston@gmail.com
Date: Sat, 10 Apr 2021 11:28:12 +0200
In-Reply-To: <20210410015023.GA13248@alvherre.pgsql>
References: <20210410015023.GA13248@alvherre.pgsql>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) 
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/f0e1c85b53d81c0b2dd77ee190031124d4438895.camel%40cybertec.at>
Precedence: bulk

On Fri, 2021-04-09 at 21:50 -0400, Alvaro Herrera wrote:
> On 2021-Apr-10, Laurenz Albe wrote:
> > On Fri, 2021-04-09 at 14:19 -0600, Henry Francisco Garcia Cortez wrote:
> > > Hi community I have a question about autovacuum_vacuum_cost_limit
> > >   I want to increase this parameter I have read on internet that value
> > >   It could have as maximum 10,000 but I want to know, what will it be the troubles if I did that change
> > 
> > That will keep PostgreSQL from functioning properly.
> > I would never increase the setting beyond the 20ms that were the
> > default before v12.
> 
> I think you're confusing it with autovacuum_vacuum_cost_delay.  He is
> asking about the cost_limit.  Increasing that setting will mean that the
> 20ms sleeps will occur much less frequently.

Yes, indeed.  Sorry.

Increasing "autovacuum_vacuum_cost_limit" will make autovacuum run faster.
There is no problem with increasing it as much as you want.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com