From a37422e042a6114ab0e513f50dac4a47fab22313 Mon Sep 17 00:00:00 2001 From: Andrew Dunstan Date: Tue, 27 Dec 2005 23:54:01 +0000 Subject: Increase amount of shared buffers initdb tries to allocate to 4000, and add logic to try max_fsm_pages up to 200000, plus accompanying minor docs changes. --- doc/src/sgml/config.sgml | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 4317841d123..acc1ec99c37 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1,5 +1,5 @@ Server Configuration @@ -672,7 +672,7 @@ SET ENABLE_SEQSCAN TO OFF; Sets the number of shared memory buffers used by the database - server. The default is typically 1000, but may be less if your + server. The default is typically 4000, but may be less if your kernel settings will not support it (as determined during initdb). Each buffer is 8192 bytes, unless a different value of BLCKSZ was chosen when building @@ -867,8 +867,10 @@ SET ENABLE_SEQSCAN TO OFF; Sets the maximum number of disk pages for which free space will 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 * max_fsm_relations. The default is 20000. - This option can only be set at server start. + 16 * max_fsm_relations. The default is 20000, + but initdb will try to set it as close as possible + to 200000, depending on the amount of available memory. + This option can only be set at server start. -- cgit v1.2.3