@@ -5180,8 +5180,10 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
5180
5180
5181
5181
<para>
5182
5182
These settings control the behavior of the <firstterm>autovacuum</>
5183
- feature. Refer to <xref linkend="autovacuum"> for
5184
- more information.
5183
+ feature. Refer to <xref linkend="autovacuum"> for more information.
5184
+ Note that many of these settings can be overridden on a per-table
5185
+ basis; see <xref linkend="sql-createtable-storage-parameters"
5186
+ endterm="sql-createtable-storage-parameters-title">.
5185
5187
</para>
5186
5188
5187
5189
<variablelist>
@@ -5199,7 +5201,8 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
5199
5201
<xref linkend="guc-track-counts"> must also be enabled for
5200
5202
autovacuum to work.
5201
5203
This parameter can only be set in the <filename>postgresql.conf</>
5202
- file or on the server command line.
5204
+ file or on the server command line; however, autovacuuming can be
5205
+ disabled for individual tables by changing table storage parameters.
5203
5206
</para>
5204
5207
<para>
5205
5208
Note that even when this parameter is disabled, the system
@@ -5227,8 +5230,10 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
5227
5230
set to any value other than <literal>-1</literal>, a message will be
5228
5231
logged if an autovacuum action is skipped due to the existence of a
5229
5232
conflicting lock. Enabling this parameter can be helpful
5230
- in tracking autovacuum activity. This setting can only be set in
5231
- the <filename>postgresql.conf</> file or on the server command line.
5233
+ in tracking autovacuum activity. This parameter can only be set in
5234
+ the <filename>postgresql.conf</> file or on the server command line;
5235
+ but the setting can be overridden for individual tables by
5236
+ changing table storage parameters.
5232
5237
</para>
5233
5238
</listitem>
5234
5239
</varlistentry>
@@ -5242,7 +5247,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
5242
5247
<listitem>
5243
5248
<para>
5244
5249
Specifies the maximum number of autovacuum processes (other than the
5245
- autovacuum launcher)which may be running at any one time. The default
5250
+ autovacuum launcher)that may be running at any one time. The default
5246
5251
is three. This parameter can only be set at server start.
5247
5252
</para>
5248
5253
</listitem>
@@ -5279,9 +5284,9 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
5279
5284
to trigger a <command>VACUUM</> in any one table.
5280
5285
The default is 50 tuples.
5281
5286
This parameter can only be set in the <filename>postgresql.conf</>
5282
- file or on the server command line.
5283
- This setting can be overridden for individual tables by
5284
- changing storage parameters.
5287
+ file or on the server command line;
5288
+ but the setting can be overridden for individual tables by
5289
+ changingtable storage parameters.
5285
5290
</para>
5286
5291
</listitem>
5287
5292
</varlistentry>
@@ -5298,9 +5303,9 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
5298
5303
needed to trigger an <command>ANALYZE</> in any one table.
5299
5304
The default is 50 tuples.
5300
5305
This parameter can only be set in the <filename>postgresql.conf</>
5301
- file or on the server command line.
5302
- This setting can be overridden for individual tables by
5303
- changing storage parameters.
5306
+ file or on the server command line;
5307
+ but the setting can be overridden for individual tables by
5308
+ changingtable storage parameters.
5304
5309
</para>
5305
5310
</listitem>
5306
5311
</varlistentry>
@@ -5318,9 +5323,9 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
5318
5323
when deciding whether to trigger a <command>VACUUM</>.
5319
5324
The default is 0.2 (20% of table size).
5320
5325
This parameter can only be set in the <filename>postgresql.conf</>
5321
- file or on the server command line.
5322
- This setting can be overridden for individual tables by
5323
- changing storage parameters.
5326
+ file or on the server command line;
5327
+ but the setting can be overridden for individual tables by
5328
+ changingtable storage parameters.
5324
5329
</para>
5325
5330
</listitem>
5326
5331
</varlistentry>
@@ -5338,9 +5343,9 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
5338
5343
when deciding whether to trigger an <command>ANALYZE</>.
5339
5344
The default is 0.1 (10% of table size).
5340
5345
This parameter can only be set in the <filename>postgresql.conf</>
5341
- file or on the server command line.
5342
- This setting can be overridden for individual tables by
5343
- changing storage parameters.
5346
+ file or on the server command line;
5347
+ but the setting can be overridden for individual tables by
5348
+ changingtable storage parameters.
5344
5349
</para>
5345
5350
</listitem>
5346
5351
</varlistentry>
@@ -5367,7 +5372,7 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
5367
5372
is a relatively low 200 million transactions.
5368
5373
This parameter can only be set at server start, but the setting
5369
5374
can be reduced for individual tables by
5370
- changing storage parameters.
5375
+ changingtable storage parameters.
5371
5376
For more information see <xref linkend="vacuum-for-wraparound">.
5372
5377
</para>
5373
5378
</listitem>
@@ -5394,8 +5399,8 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
5394
5399
<filename>pg_multixact/members</> and <filename>pg_multixact/offsets</>
5395
5400
subdirectories, which is why the default is a relatively low
5396
5401
400 million multixacts.
5397
- This parameter can only be set at server start, but the setting
5398
- can be reduced for individual tables by changing storage parameters.
5402
+ This parameter can only be set at server start, but the setting can
5403
+ be reduced for individual tables by changing table storage parameters.
5399
5404
For more information see <xref linkend="vacuum-for-multixact-wraparound">.
5400
5405
</para>
5401
5406
</listitem>
@@ -5414,9 +5419,9 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
5414
5419
<xref linkend="guc-vacuum-cost-delay"> value will be used.
5415
5420
The default value is 20 milliseconds.
5416
5421
This parameter can only be set in the <filename>postgresql.conf</>
5417
- file or on the server command line.
5418
- This setting can be overridden for individual tables by
5419
- changing storage parameters.
5422
+ file or on the server command line;
5423
+ but the setting can be overridden for individual tables by
5424
+ changingtable storage parameters.
5420
5425
</para>
5421
5426
</listitem>
5422
5427
</varlistentry>
@@ -5434,12 +5439,12 @@ COPY postgres_log FROM '/full/path/to/logfile.csv' WITH csv;
5434
5439
default), the regular
5435
5440
<xref linkend="guc-vacuum-cost-limit"> value will be used. Note that
5436
5441
the value is distributed proportionally among the running autovacuum
5437
- workers, if there is more than one, so that the sum of the limitsof
5438
- each workernever exceeds thelimit on this variable.
5442
+ workers, if there is more than one, so that the sum of the limitsfor
5443
+ each workerdoes not exceed thevalue of this variable.
5439
5444
This parameter can only be set in the <filename>postgresql.conf</>
5440
- file or on the server command line.
5441
- This setting can be overridden for individual tables by
5442
- changing storage parameters.
5445
+ file or on the server command line;
5446
+ but the setting can be overridden for individual tables by
5447
+ changingtable storage parameters.
5443
5448
</para>
5444
5449
</listitem>
5445
5450
</varlistentry>
@@ -6018,7 +6023,7 @@ SET XML OPTION { DOCUMENT | CONTENT };
6018
6023
the entries in it to the main GIN data structure in bulk.
6019
6024
The default is four megabytes (<literal>4MB</>). This setting
6020
6025
can be overridden for individual GIN indexes by changing
6021
- storage parameters.
6026
+ index storage parameters.
6022
6027
See <xref linkend="gin-fast-update"> and <xref linkend="gin-tips">
6023
6028
for more information.
6024
6029
</para>