vacuum monitoring in the doc

From M.Mamin@intershop.de Mon Jun 1 08:15:52 2026 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-- From bruce@momjian.us Mon Jun 1 08:15:52 2026 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) 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 ) 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 ) id 1T79kJ-0008Re-Ci; Thu, 30 Aug 2012 14:45:39 -0400 Date: Thu, 30 Aug 2012 14:45:39 -0400 From: Bruce Momjian To: Marc Mamin Cc: pgsql-docs@postgresql.org Subject: Re: vacuum monitoring in the doc Message-ID: <20120830184539.GQ8753@momjian.us> References: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="V88s5gaDVPzZ0KCq" Content-Disposition: inline In-Reply-To: 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 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 **** 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 VACUUM and/or ANALYZE as needed. --- 632,640 ---- 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 VACUUM and/or ANALYZE as needed. ! log_autovacuum_min_duration can be used to monitor ! autovacuum activity. --V88s5gaDVPzZ0KCq--