Skip to content

Commit 39712d1

Browse files
author
Neil Conway
committed
Make a few marginal improvements to the documentation for the AV
launcher daemon.
1 parent 513836c commit 39712d1

File tree

1 file changed

+13
-17
lines changed

1 file changed

+13
-17
lines changed

doc/src/sgml/maintenance.sgml

+13-17
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.73 2007/05/03 15:47:48 alvherre Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.74 2007/05/15 15:52:40 neilc Exp $ -->
22

33
<chapter id="maintenance">
44
<title>Routine Database Maintenance Tasks</title>
@@ -485,28 +485,24 @@ HINT: Stop the postmaster and use a standalone backend to VACUUM in "mydb".
485485
multi-process architecture: there is a daemon process, called the
486486
<firstterm>autovacuum launcher</firstterm>, which is in charge of starting
487487
an <firstterm>autovacuum worker</firstterm> process on each database every
488-
<xref linkend="guc-autovacuum-naptime"> seconds.
488+
<xref linkend="guc-autovacuum-naptime"> seconds. On each run, the worker
489+
process checks each table within that database, and <command>VACUUM</> or
490+
<command>ANALYZE</> commands are issued as needed.
489491
</para>
490492

491493
<para>
492494
There is a limit of <xref linkend="guc-autovacuum-max-workers"> worker
493495
processes that may be running at any time, so if the <command>VACUUM</>
494496
and <command>ANALYZE</> work to do takes too long to run, the deadline may
495497
be failed to meet for other databases. Also, if a particular database
496-
takes long to process, more than one worker may be processing it
498+
takes a long time to process, more than one worker may be processing it
497499
simultaneously. The workers are smart enough to avoid repeating work that
498500
other workers have done, so this is normally not a problem. Note that the
499501
number of running workers does not count towards the <xref
500502
linkend="guc-max-connections"> nor the <xref
501503
linkend="guc-superuser-reserved-connections"> limits.
502504
</para>
503505

504-
<para>
505-
On each run, the worker process checks each table within that database, and
506-
<command>VACUUM</command> or <command>ANALYZE</command> commands are
507-
issued as needed.
508-
</para>
509-
510506
<para>
511507
Tables whose <structfield>relfrozenxid</> value is more than
512508
<varname>autovacuum_freeze_max_age</> transactions old are always
@@ -591,19 +587,19 @@ analyze threshold = analyze base threshold + analyze scale factor * number of tu
591587
<caution>
592588
<para>
593589
The contents of the <structname>pg_autovacuum</structname> system
594-
catalog are currently not saved in database dumps created by
595-
the tools <command>pg_dump</command> and <command>pg_dumpall</command>.
596-
If you want to preserve them across a dump/reload cycle, make sure you
597-
dump the catalog manually.
590+
catalog are currently not saved in database dumps created by the
591+
tools <application>pg_dump</> and <application>pg_dumpall</>. If
592+
you want to preserve them across a dump/reload cycle, make sure
593+
you dump the catalog manually.
598594
</para>
599595
</caution>
600596

601597
<para>
602-
When multiple workers are running, the cost limit is "balanced" among all
603-
the running workers, so that the total impact on the system is the same,
604-
regardless of the number of workers actually running.
598+
When multiple workers are running, the cost limit is
599+
<quote>balanced</quote> among all the running workers, so that the
600+
total impact on the system is the same, regardless of the number
601+
of workers actually running.
605602
</para>
606-
607603
</sect2>
608604
</sect1>
609605

0 commit comments

Comments
 (0)