Thank you comments
El sáb, 10 abr 2021 a las 3:28, Laurenz Albe (<laurenz.albe@xxxxxxxxxxx>) escribió:
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
--
Ing. Henry G. Cortez
