Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit25434e3

Browse files
committed
Add documentation stating how to determine if FSM settings are too low
--- look at a database-wide VACUUM VERBOSE.
1 parente092828 commit25434e3

File tree

1 file changed

+9
-1
lines changed

1 file changed

+9
-1
lines changed

‎doc/src/sgml/runtime.sgml

Lines changed: 9 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.314 2005/04/21 19:18:12 tgl Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.315 2005/04/23 03:27:40 momjian Exp $
33
-->
44

55
<chapter Id="runtime">
@@ -1151,6 +1151,10 @@ SET ENABLE_SEQSCAN TO OFF;
11511151
be tracked in the shared free-space map. Six bytes of shared memory
11521152
are consumed for each page slot. This setting must be more than
11531153
16 * <varname>max_fsm_relations</varname>. The default is 20000.
1154+
The last few lines of a database-wide <command>VACUUM VERBOSE</>
1155+
can help in determining if the the default setting is suitable.
1156+
A <literal>NOTICE</> message is also printed during such an operation
1157+
if the current setting is too low.
11541158
This option can only be set at server start.
11551159
</para>
11561160
</listitem>
@@ -1167,6 +1171,10 @@ SET ENABLE_SEQSCAN TO OFF;
11671171
free space will be tracked in the shared free-space map. Roughly
11681172
fifty bytes of shared memory are consumed for each slot.
11691173
The default is 1000.
1174+
The last few lines of a database-wide <command>VACUUM VERBOSE</>
1175+
can help in determining if the the default setting is suitable.
1176+
A <literal>NOTICE</> message is also printed during such an operation
1177+
if the current setting is too low.
11701178
This option can only be set at server start.
11711179
</para>
11721180
</listitem>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp