Hi, Today looking for information on hard limits for autovacuum_vacuum_cost_limit I found myself with a very short description in the docs.
This is a patch to add some further description, plus the upper and lower limits it has. -- Martín Marqués select 'martin.marques' || '@' || 'gmail.com' DBA, Programador, Administrador
From 3a1aa5de682ee6f6cbd1086845ce845409156186 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Mart=C3=ADn=20Marqu=C3=A9s?= <martin.marq...@2ndquadrant.com> Date: Tue, 10 Apr 2018 18:03:52 -0300 Subject: [PATCH] Describe better vacuum_cost_limit, mentioning the lower and upper values it can take. --- doc/src/sgml/config.sgml | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 5d5f2d23c4..fe7a6d91df 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1860,8 +1860,9 @@ include_dir 'conf.d' </term> <listitem> <para> - The accumulated cost that will cause the vacuuming process to sleep. - The default value is 200. + This is the accumulated cost that will cause the vacuuming process to sleep + for vacuum_cost_delay. The parameter can take a value between 1 and 10000. + The default is 200. </para> </listitem> </varlistentry> -- 2.13.6