public inbox for [email protected]  

help / color / mirror / Atom feed

From: Christoph Moench-Tegeder <[email protected]>
To: Shenavai, Manuel <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: autovacuum_vacuum_cost_delay
Date: Tue, 9 Jul 2024 18:23:50 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <AS8PR02MB7416A6B018735D5C73EF8EF8E8DB2@AS8PR02MB7416.eurprd02.prod.outlook.com>
References: <AS8PR02MB7416A6B018735D5C73EF8EF8E8DB2@AS8PR02MB7416.eurprd02.prod.outlook.com>

## Shenavai, Manuel ([email protected]):

> Looking at autovacuum_vacuum_cost_delay:
> https://www.postgresql.org/docs/current/runtime-config-autovacuum.html#GUC-AUTOVACUUM-VACUUM-COST-DE...
> 
> 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?

The autovacuum settings link to the docs of the regular vacuum settings:
https://www.postgresql.org/docs/current/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-VACUUM-...
which explains the parameters at least as good as I could do here.
You can set autovacuum_vacuum_cost_delay to 0 - that would give you
"unlimited" autovacuum bandwidth (limited by whatever your system and
your other configuration can give you). That might create very
noticeable performance impact on the actual workload, which is most
often rather undesirable.
In short: it's possible to set that parameter to 0, but that could
well be a not-so-good idea.

Regards,
Christoph

-- 
Spare Space

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: autovacuum_vacuum_cost_delay
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox