public inbox for [email protected]
help / color / mirror / Atom feedvacuum monitoring in the doc
2+ messages / 2 participants
[nested] [flat]
* vacuum monitoring in the doc
@ 2012-05-22 08:57 Marc Mamin <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Marc Mamin @ 2012-05-22 08:57 UTC (permalink / raw)
To: pgsql-docs
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: vacuum monitoring in the doc
@ 2012-08-30 18:45 Bruce Momjian <[email protected]>
parent: Marc Mamin <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2012-08-30 18:45 UTC (permalink / raw)
To: Marc Mamin <[email protected]>; +Cc: pgsql-docs
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 <[email protected]> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
Attachments:
[text/x-diff] autovac.diff (1.0K, 2-autovac.diff)
download | inline 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 ****
<varname>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 <command>VACUUM</> and/or <command>ANALYZE</> as needed.
</para>
<para>
--- 632,640 ----
<varname>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 <command>VACUUM</> and/or <command>ANALYZE</> as needed.
! <varname>log_autovacuum_min_duration</varname> can be used to monitor
! autovacuum activity.
</para>
<para>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-08-30 18:45 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-05-22 08:57 vacuum monitoring in the doc Marc Mamin <[email protected]>
2012-08-30 18:45 ` Bruce Momjian <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox