autovacuum_vacuum_cost_delay - Mailing list pgsql-general

From Shenavai, Manuel
Subject autovacuum_vacuum_cost_delay
Date
Msg-id AS8PR02MB7416A6B018735D5C73EF8EF8E8DB2@AS8PR02MB7416.eurprd02.prod.outlook.com
Whole thread Raw
Responses Re: autovacuum_vacuum_cost_delay
Re: autovacuum_vacuum_cost_delay
List pgsql-general

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 really means? Would it be OK to set this to 0? If not, why not?

 

Thanks in advance &
Best regards,

Manuel

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: SQL: Chaining versus Pipelining
Next
From: Muhammad Ikram
Date:
Subject: Re: autovacuum_vacuum_cost_delay