Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <bruce@momjian.us>) id 1T79kN-0006gD-O8
	for pgsql-docs@postgresql.org; Thu, 30 Aug 2012 18:45:43 +0000
Received: from momjian.us ([72.94.173.45])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <bruce@momjian.us>) id 1T79kL-0003NN-A0
	for pgsql-docs@postgresql.org; Thu, 30 Aug 2012 18:45:43 +0000
Received: from bruce by momjian.us with local (Exim 4.72)
	(envelope-from <bruce@momjian.us>)
	id 1T79kJ-0008Re-Ci; Thu, 30 Aug 2012 14:45:39 -0400
Date: Thu, 30 Aug 2012 14:45:39 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Marc Mamin <M.Mamin@intershop.de>
Cc: pgsql-docs@postgresql.org
Subject: Re: vacuum monitoring in the doc
Message-ID: <20120830184539.GQ8753@momjian.us>
References: 
 <C4DAC901169B624F933534A26ED7DF310861B55B@JENMAIL01.ad.intershop.net>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="V88s5gaDVPzZ0KCq"
Content-Disposition: inline
In-Reply-To: 
 <C4DAC901169B624F933534A26ED7DF310861B55B@JENMAIL01.ad.intershop.net>
User-Agent: Mutt/1.5.20 (2009-06-14)
X-Pg-Spam-Score: -2.1 (--)
X-Archive-Number: 201208/54
X-Sequence-Number: 7447


--V88s5gaDVPzZ0KCq
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

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  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

--V88s5gaDVPzZ0KCq
Content-Type: text/x-diff; charset=us-ascii
Content-Disposition: attachment; filename="autovac.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>

--V88s5gaDVPzZ0KCq--