vacuum monitoring in the doc

Started by Marc Maminalmost 14 years ago2 messagesdocs
Jump to latest
#1Marc Mamin
M.Mamin@intershop.de

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#RU
NTIME-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#MONITORI
NG-STATS-VIEWS-TABLE )

best regards,

Marc Mamin

#2Bruce Momjian
bruce@momjian.us
In reply to: Marc Mamin (#1)
Re: vacuum monitoring in the doc

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. +

Attachments:

autovac.difftext/x-diff; charset=us-asciiDownload+4-4