| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | Henry Francisco Garcia Cortez <garcortez(at)gmail(dot)com>, 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-10 01:50:23 |
| Message-ID: | 20210410015023.GA13248@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
--
Álvaro Herrera Valdivia, Chile
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2021-04-10 09:28:12 | Re: autovacuum_vacuum_cost_limit |
| Previous Message | Laurenz Albe | 2021-04-10 01:43:17 | Re: autovacuum_vacuum_cost_limit |