Re: autovacuum_vacuum_cost_delay

2024-07-09 Thread Christoph Moench-Tegeder
## Shenavai, Manuel (manuel.shena...@sap.com): > Looking at autovacuum_vacuum_cost_delay: > https://www.postgresql.org/docs/current/runtime-config-autovacuum.html#GUC-AUTOVACUUM-VACUUM-COST-DELAY > > Can someone help to understand what a high or low value of this setting > really means? Would it

Re: autovacuum_vacuum_cost_delay

2024-07-09 Thread Muhammad Ikram
Hi Shenvail, Based on what I could understand, Lower value will cause more frequent run of Autovacuum. Will have less delay between processing data chunks but will put more load on the I/O system. Autovacuum tasks will complete faster. Cleanup of dead tuples and blots will be quicker thus increas