Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 0AEC5EDF36D for ; Tue, 22 May 2012 05:57:47 -0300 (ADT) Received: from mailgate.intershop.de ([195.110.60.6]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SWkuX-0000ca-Qs for pgsql-docs@postgresql.org; Tue, 22 May 2012 08:57:47 +0000 Received: from JENMAIL01.ad.intershop.net ([10.0.87.43]) by mailgate.intershop.de (8.14.5/8.13.6) with ESMTP id q4M8v7v7003322 for ; Tue, 22 May 2012 10:57:09 +0200 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01CD37F8.EA194092" Subject: vacuum monitoring in the doc Date: Tue, 22 May 2012 10:57:28 +0200 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: vacuum monitoring in the doc Thread-Index: Ac03+Opuu08YE+zTQ9+yZ+sgyr7h2g== From: "Marc Mamin" To: X-Pg-Spam-Score: -0.0 (/) X-Archive-Number: 201205/26 X-Sequence-Number: 7351 This is a multi-part message in MIME format. ------_=_NextPart_001_01CD37F8.EA194092 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello,=20 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#RU NTIME-CONFIG-LOGGING-WHAT ) - There is no hint on how to monitor vaccum in the main chapter=20 ( 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#MONITORI NG-STATS-VIEWS-TABLE ) =20 best regards, Marc Mamin ------_=_NextPart_001_01CD37F8.EA194092 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable vacuum monitoring in the doc

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-vacuum= ing.html )

  A hint = on pg_stat_all_tables would be helpful.

  = ( http://www.postgresql.org/docs/9.1/static/monitoring-sta= ts.html#MONITORING-STATS-VIEWS-TABLE )

  =

best = regards,

Marc = Mamin

------_=_NextPart_001_01CD37F8.EA194092--