Postgres Pro
Downloads
Home   >   mailing lists

Thread: vacuum monitoring in the doc

vacuum monitoring in the doc

From
"Marc Mamin"
Date:

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 )

 

best regards,

Marc Mamin

Re: vacuum monitoring in the doc

From
Bruce Momjian
Date:
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. +
Attachment