1
1
<!--
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 $
3
3
-->
4
4
<chapter Id="runtime-config">
5
5
<title>Server Configuration</title>
@@ -867,10 +867,10 @@ SET ENABLE_SEQSCAN TO OFF;
867
867
Sets the maximum number of disk pages for which free space will
868
868
be tracked in the shared free-space map. Six bytes of shared memory
869
869
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.
874
874
</para>
875
875
</listitem>
876
876
</varlistentry>
@@ -2825,8 +2825,11 @@ SELECT * FROM parent WHERE key = 2400;
2825
2825
Controls whether the server should start the
2826
2826
statistics-collection subprocess. This is on by default, but
2827
2827
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.)
2830
2833
</para>
2831
2834
</listitem>
2832
2835
</varlistentry>
@@ -2909,12 +2912,12 @@ SELECT * FROM parent WHERE key = 2400;
2909
2912
2910
2913
<indexterm>
2911
2914
<primary>autovacuum</primary>
2912
- <secondary>global configuration parameters</secondary>
2915
+ <secondary>configuration parameters</secondary>
2913
2916
</indexterm>
2914
2917
2915
2918
<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
2918
2921
more information.
2919
2922
</para>
2920
2923
@@ -2927,10 +2930,10 @@ SELECT * FROM parent WHERE key = 2400;
2927
2930
</indexterm>
2928
2931
<listitem>
2929
2932
<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.
2932
2935
<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 .
2934
2937
This option can only be set at server start or in the
2935
2938
<filename>postgresql.conf</filename> file.
2936
2939
</para>
@@ -2945,7 +2948,7 @@ SELECT * FROM parent WHERE key = 2400;
2945
2948
<listitem>
2946
2949
<para>
2947
2950
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
2949
2952
and issues <command>VACUUM</> and <command>ANALYZE</> commands
2950
2953
as needed for tables in that database. The delay is measured
2951
2954
in seconds, and the default is 60.
0 commit comments