autovacuum_vacuum_cost_delay

From: "Shenavai, Manuel" <manuel(dot)shenavai(at)sap(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: autovacuum_vacuum_cost_delay
Date: 2024-07-09 11:38:40
Message-ID: AS8PR02MB7416A6B018735D5C73EF8EF8E8DB2@AS8PR02MB7416.eurprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Muhammad Ikram 2024-07-09 13:42:11 Re: autovacuum_vacuum_cost_delay
Previous Message Laurenz Albe 2024-07-09 07:48:24 Re: SQL: Chaining versus Pipelining