diff options
| author | Bruce Momjian | 2005-04-23 03:27:40 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2005-04-23 03:27:40 +0000 |
| commit | 25434e32cb1cf4e7c61a21482832ecc5b33e1f5a (patch) | |
| tree | 08f6e93165c4a459659ee16b632ddab7f4219dfd /doc/src | |
| parent | e0928282419237cc95c576b20ab376110ea2a8e2 (diff) | |
Add documentation stating how to determine if FSM settings are too low
--- look at a database-wide VACUUM VERBOSE.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/runtime.sgml | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index 72bc1ff17e3..cb527bedbc1 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.314 2005/04/21 19:18:12 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/runtime.sgml,v 1.315 2005/04/23 03:27:40 momjian Exp $ --> <chapter Id="runtime"> @@ -1151,6 +1151,10 @@ SET ENABLE_SEQSCAN TO OFF; be tracked in the shared free-space map. Six bytes of shared memory are consumed for each page slot. This setting must be more than 16 * <varname>max_fsm_relations</varname>. The default is 20000. + The last few lines of a database-wide <command>VACUUM VERBOSE</> + can help in determining if the the default setting is suitable. + A <literal>NOTICE</> message is also printed during such an operation + if the current setting is too low. This option can only be set at server start. </para> </listitem> @@ -1167,6 +1171,10 @@ SET ENABLE_SEQSCAN TO OFF; free space will be tracked in the shared free-space map. Roughly fifty bytes of shared memory are consumed for each slot. The default is 1000. + The last few lines of a database-wide <command>VACUUM VERBOSE</> + can help in determining if the the default setting is suitable. + A <literal>NOTICE</> message is also printed during such an operation + if the current setting is too low. This option can only be set at server start. </para> </listitem> |