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 > real

Re: autovacuum_vacuum_cost_delay

2024-07-09 Thread Muhammad Ikram
Tue, Jul 9, 2024 at 4:38 PM Shenavai, Manuel wrote: > Hi everyone, > > > > We are doing some tests with different autovacuum settings. > > > > Looking at autovacuum_vacuum_cost_delay: > > > https://www.postgresql.org/docs/current/runtime-config-autovacuum.h

autovacuum_vacuum_cost_delay

2024-07-09 Thread Shenavai, Manuel
Hi everyone, We are doing some tests with different autovacuum settings. 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

Re: Difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"?

2018-08-17 Thread Adrian Klaver
-autovacuum.html What is the difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"? What is the difference between "autovacuum launcher process" and "autovacuum worker process"? How to control the number of "autovacuum launcher proc

Re: Difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"?

2018-08-16 Thread Raghavendra Rao J S V
Thank you very much for your response. Could you clarify me below things,please? What is the difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"? What is the difference between "autovacuum launcher process" and "autovacuum worker proc

Re: Difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"?

2018-08-16 Thread Joshua D. Drake
On 08/16/2018 06:10 PM, Raghavendra Rao J S V wrote: Hi All, I have gone through several documents but I am still have confusion related to "autovacuum_naptime" and "autovacuum_vacuum_cost_delay". Could you clarify me with an example. When Auto vacuum worke

Difference between "autovacuum_naptime" and "autovacuum_vacuum_cost_delay"?

2018-08-16 Thread Raghavendra Rao J S V
Hi All, I have gone through several documents but I am still have confusion related to "autovacuum_naptime" and "autovacuum_vacuum_cost_delay". Could you clarify me with an example. When Auto vacuum worker process will start? When Auto vacuum worker process will stop? Doe