Re: autovacuum_vacuum_cost_limit

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

If the three autovacuum workers allowed by autovacuum_max_workers are already enough
to strain your I/O resources, consider getting more powerful storage.

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






[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux