public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bruce Momjian <[email protected]>
To: Marc Mamin <[email protected]>
Cc: [email protected]
Subject: Re: vacuum monitoring in the doc
Date: Thu, 30 Aug 2012 14:45:39 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <C4DAC901169B624F933534A26ED7DF310861B55B@JENMAIL01.ad.intershop.net>
References: <C4DAC901169B624F933534A26ED7DF310861B55B@JENMAIL01.ad.intershop.net>
On Tue, May 22, 2012 at 10:57:28AM +0200, Marc Mamin wrote:
> Hello,
>
> I find that 2 informations on vacuum are quite hard to find in the doc:
>
> - "log_autovacuum_min_duration" is not listed in "What to log"
>
> ( http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html#
> RUNTIME-CONFIG-LOGGING-WHAT )
>
> - There is no hint on how to monitor vaccum in the main chapter
>
> ( http://www.postgresql.org/docs/9.1/static/routine-vacuuming.html )
>
> A hint on pg_stat_all_tables would be helpful.
>
> ( http://www.postgresql.org/docs/9.1/static/monitoring-stats.html#
> MONITORING-STATS-VIEWS-TABLE )
Good point. Corrected with the attached, applied patch. I ended up
adding it to the autovacuum section.
--
Bruce Momjian <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
Attachments:
[text/x-diff] autovac.diff (1.0K, 2-autovac.diff)
download | inline diff:
diff --git a/doc/src/sgml/maintenance.sgml b/doc/src/sgml/maintenance.sgml
new file mode 100644
index fb705b2..ab01da1
*** a/doc/src/sgml/maintenance.sgml
--- b/doc/src/sgml/maintenance.sgml
*************** HINT: Stop the postmaster and use a sta
*** 632,638 ****
<varname>autovacuum_max_workers</> databases to be processed,
the next database will be processed as soon as the first worker finishes.
Each worker process will check each table within its database and
! execute <command>VACUUM</> and/or <command>ANALYZE</> as needed.
</para>
<para>
--- 632,640 ----
<varname>autovacuum_max_workers</> databases to be processed,
the next database will be processed as soon as the first worker finishes.
Each worker process will check each table within its database and
! execute <command>VACUUM</> and/or <command>ANALYZE</> as needed.
! <varname>log_autovacuum_min_duration</varname> can be used to monitor
! autovacuum activity.
</para>
<para>
view thread (2+ messages)
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: vacuum monitoring in the doc
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