Skip to content

Commit b42f307

Browse files
committed
Marginal improvements in the wording of the autovacuum documentation:
be consistent about whether it's called a daemon or a subprocess, and don't describe the autovacuum setting in exactly the same way as the stats_start_collector setting, because that leaves people thinking (if they aren't paying close attention) that autovacuum can't be changed on the fly.
1 parent 27959dd commit b42f307

File tree

1 file changed

+17
-14
lines changed

1 file changed

+17
-14
lines changed

doc/src/sgml/config.sgml

Lines changed: 17 additions & 14 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.43 2006/01/11 23:14:29 tgl Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.44 2006/01/21 19:34:42 tgl Exp $
33
-->
44
<chapter Id="runtime-config">
55
<title>Server Configuration</title>
@@ -867,10 +867,10 @@ SET ENABLE_SEQSCAN TO OFF;
867867
Sets the maximum number of disk pages for which free space will
868868
be tracked in the shared free-space map. Six bytes of shared memory
869869
are consumed for each page slot. This setting must be more than
870-
16 * <varname>max_fsm_relations</varname>. The default is 20000,
871-
but <application>initdb</> will try to set it as close as possible
872-
to 200000, depending on the amount of available memory.
873-
This option can only be set at server start.
870+
16 * <varname>max_fsm_relations</varname>. The default is chosen
871+
by <application>initdb</> depending on the amount of available memory,
872+
and can range from 20000 to 200000.
873+
This option can only be set at server start.
874874
</para>
875875
</listitem>
876876
</varlistentry>
@@ -2825,8 +2825,11 @@ SELECT * FROM parent WHERE key = 2400;
28252825
Controls whether the server should start the
28262826
statistics-collection subprocess. This is on by default, but
28272827
may be turned off if you know you have no interest in
2828-
collecting statistics. This option can only be set at server
2829-
start.
2828+
collecting statistics or running autovacuum.
2829+
This option can only be set at server start, because the collection
2830+
subprocess cannot be started or stopped on-the-fly. (However, the
2831+
extent to which statistics are actually gathered can be changed while
2832+
the server is running, so long as the subprocess exists.)
28302833
</para>
28312834
</listitem>
28322835
</varlistentry>
@@ -2909,12 +2912,12 @@ SELECT * FROM parent WHERE key = 2400;
29092912

29102913
<indexterm>
29112914
<primary>autovacuum</primary>
2912-
<secondary>global configuration parameters</secondary>
2915+
<secondary>configuration parameters</secondary>
29132916
</indexterm>
29142917

29152918
<para>
2916-
These settings control the default behavior for the <firstterm>autovacuum
2917-
daemon</firstterm>. Please refer to <xref linkend="autovacuum"> for
2919+
These settings control the behavior of the <firstterm>autovacuum</>
2920+
feature. Please refer to <xref linkend="autovacuum"> for
29182921
more information.
29192922
</para>
29202923

@@ -2927,10 +2930,10 @@ SELECT * FROM parent WHERE key = 2400;
29272930
</indexterm>
29282931
<listitem>
29292932
<para>
2930-
Controls whether the server should start the
2931-
autovacuum subprocess. This is off by default.
2933+
Controls whether the server should run the
2934+
autovacuum daemon. This is off by default.
29322935
<varname>stats_start_collector</> and <varname>stats_row_level</>
2933-
must also be on for this to start.
2936+
must also be turned on for autovacuum to work.
29342937
This option can only be set at server start or in the
29352938
<filename>postgresql.conf</filename> file.
29362939
</para>
@@ -2945,7 +2948,7 @@ SELECT * FROM parent WHERE key = 2400;
29452948
<listitem>
29462949
<para>
29472950
Specifies the delay between activity rounds for the autovacuum
2948-
subprocess. In each round the subprocess examines one database
2951+
daemon. In each round the daemon examines one database
29492952
and issues <command>VACUUM</> and <command>ANALYZE</> commands
29502953
as needed for tables in that database. The delay is measured
29512954
in seconds, and the default is 60.

0 commit comments

Comments
 (0)