diff options
| author | Tom Lane | 2006-09-25 22:12:24 +0000 |
|---|---|---|
| committer | Tom Lane | 2006-09-25 22:12:24 +0000 |
| commit | 0f8fc35a5a9824d4f50edef49ce000f104ca5e74 (patch) | |
| tree | 0d1d548f2bab9e4b6cac58d9e07dff84b421752d /doc/src | |
| parent | ffae5cc5a6024b4e25ec920ed5c4dfac649605f8 (diff) | |
Increase default value of effective_cache_size to 128MB, per discussion.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index a4e3eb020bb..b3223e3de43 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.88 2006/09/18 12:11:36 teodor Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.89 2006/09/25 22:12:24 tgl Exp $ --> <chapter Id="runtime-config"> <title>Server Configuration</title> @@ -1905,7 +1905,7 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows <listitem> <para> Sets the planner's assumption about the effective size of the - disk cache that is available to a single index scan. This is + disk cache that is available to a single query. This is factored into estimates of the cost of using an index; a higher value makes it more likely index scans will be used, a lower value makes it more likely sequential scans will be @@ -1913,13 +1913,13 @@ archive_command = 'copy "%p" /mnt/server/archivedir/"%f"' # Windows <productname>PostgreSQL</productname>'s shared buffers and the portion of the kernel's disk cache that will be used for <productname>PostgreSQL</productname> data files. Also, take - into account the expected number of concurrent queries using - different indexes, since they will have to share the available + into account the expected number of concurrent queries on different + tables, since they will have to share the available space. This parameter has no effect on the size of shared memory allocated by <productname>PostgreSQL</productname>, nor does it reserve kernel disk cache; it is used only for estimation purposes. The value is measured in disk pages, - which are normally 8192 bytes each. The default is 1000. + which are normally 8192 bytes each. The default is 16384 (128 MB). </para> </listitem> </varlistentry> |