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
