From: Euler Taveira <euler@eulerto.com>
To: nikolai.berkoff <nikolai.berkoff@pm.me>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Subject: Re: Missing mention of autovacuum_work_mem
Date: Wed, 22 Sep 2021 17:45:57 -0300
Message-ID: <e6deef8f-e165-4ba5-b48f-80ba8e2d4b51@www.fastmail.com> (raw)
In-Reply-To: <2a_0HzEWsHbu9VVZKMxdZ-YxVvFqamXG4crWy1xNkE4NIF-VjRuquYqzrNzmq8-2kJorJymk1D7CDbC2JgYA-BBGibPcxzWQ6R1WTtGMacE=@pm.me>
References: <1kIqf6Q1G-wVkQkeg_BRSpcmy77hNfh9vlLQ3AF1APT-pKHRYT3z1IuDC5K2w83-4Qa016V1SfWJfF1v0Z0qf6141DbLcpIZJY3edlBEkCs=@pm.me>
<b48ec99bfbb9eaf329fd9c3e7a20551810244882.camel@cybertec.at>
<2a_0HzEWsHbu9VVZKMxdZ-YxVvFqamXG4crWy1xNkE4NIF-VjRuquYqzrNzmq8-2kJorJymk1D7CDbC2JgYA-BBGibPcxzWQ6R1WTtGMacE=@pm.me>
On Mon, Sep 20, 2021, at 10:40 AM, nikolai.berkoff wrote:
> Yes that reads better still.
I'm attaching a patch with Laurenz's words.
--
Euler Taveira
EDB https://www.enterprisedb.com/Attachments:v1-0001-Improve-vacumming-indexes-description.patch (text/x-patch, 1.4K) download
From 41f814b15349bcc8eb8ffa4624ed5af80f3476ac Mon Sep 17 00:00:00 2001
From: Euler Taveira <euler.taveira@enterprisedb.com>
Date: Wed, 22 Sep 2021 14:47:12 -0300
Subject: [PATCH v1] Improve vacumming indexes description
Mention autovacuum_work_mem if VACUUM is run by autovacuum.
Reported-by: Nikolai Berkoff
Author: Laurenz Albe
Reviewed-by: Nikolai Berkoff
Discussion: https://postgr.es/m/1kIqf6Q1G-wVkQkeg_BRSpcmy77hNfh9vlLQ3AF1APT-pKHRYT3z1IuDC5K2w83-4Qa016V1SfWJfF1v0Z0qf6141DbLcpIZJY3edlBEkCs%3D%40pm.me
---
doc/src/sgml/monitoring.sgml | 5 +++--
1 file changed, 3 insertions(+), 2 deletions(-)
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgmlindex 2281ba120f..451534602b 100644--- a/doc/src/sgml/monitoring.sgml+++ b/doc/src/sgml/monitoring.sgml@@ -6147,8 +6147,9 @@ SELECT pg_stat_get_backend_pid(s.backendid) AS pid,
<command>VACUUM</command> is currently vacuuming the indexes. If a table has
any indexes, this will happen at least once per vacuum, after the heap
has been completely scanned. It may happen multiple times per vacuum
- if <xref linkend="guc-maintenance-work-mem"/> is insufficient to- store the number of dead tuples found.+ if <xref linkend="guc-maintenance-work-mem"/> (or, in the case of autovacuum,+ <xref linkend="guc-autovacuum-work-mem"/>) is insufficient to store the number+ of dead tuples found.
</entry>
</row>
<row>
--
2.20.1
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: pgsql-docs@postgresql.org
Cc: euler@eulerto.com, nikolai.berkoff@pm.me, laurenz.albe@cybertec.at, pgsql-docs@lists.postgresql.org
Subject: Re: Missing mention of autovacuum_work_mem
In-Reply-To: <e6deef8f-e165-4ba5-b48f-80ba8e2d4b51@www.fastmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox