From: | Henry Francisco Garcia Cortez <garcortez(at)gmail(dot)com> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, pgsql-admin(at)lists(dot)postgresql(dot)org, david(dot)g(dot)johnston(at)gmail(dot)com |
Subject: | Re: autovacuum_vacuum_cost_limit |
Date: | 2021-04-12 14:51:18 |
Message-ID: | CAJP2v3GZB+je6UOD1+8-5OXEkRXSezhoCUj9Vm=auHA1Emjo5g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thank you comments
El sáb, 10 abr 2021 a las 3:28, Laurenz Albe (<laurenz(dot)albe(at)cybertec(dot)at>)
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
From | Date | Subject | |
---|---|---|---|
Next Message | Lars Aksel Opsahl | 2021-04-13 04:58:37 | COPY big row returns ERROR: invalid memory alloc request size |
Previous Message | Laurenz Albe | 2021-04-10 09:28:12 | Re: autovacuum_vacuum_cost_limit |