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