diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2014-05-08 21:11:47 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2014-05-08 21:11:47 -0400 |
| commit | b910d7ea358b0134d170ebf4002248df25a5f244 (patch) | |
| tree | f8872b4c8d4f2cd51e3367497b2e83773e67a961 /doc/src | |
| parent | a16d421ca4fc639929bc964b2585e8382cf16e33 (diff) | |
| download | postgresql-b910d7ea358b0134d170ebf4002248df25a5f244.tar.gz postgresql-b910d7ea358b0134d170ebf4002248df25a5f244.zip | |
Increase the default value of effective_cache_size to 4GB.
Per discussion, the old value of 128MB is ridiculously small on modern
machines; in fact, it's not even any larger than the default value of
shared_buffers, which it certainly should be. Increase to 4GB, which
is unlikely to be any worse than the old default for anyone, and should
be noticeably better for most. Eventually we might have an autotuning
scheme for this setting, but the recent attempt crashed and burned,
so for now just do this.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/config.sgml | 4 | ||||
| -rw-r--r-- | doc/src/sgml/release-9.4.sgml | 18 |
2 files changed, 11 insertions, 11 deletions
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index bc5a8870444..d9e5985a16a 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -3194,8 +3194,8 @@ include 'filename' memory allocated by <productname>PostgreSQL</productname>, nor does it reserve kernel disk cache; it is used only for estimation purposes. The system also does not assume data remains in - the disk cache between queries. The default is 128 megabytes - (<literal>128MB</>). + the disk cache between queries. The default is 4 gigabytes + (<literal>4GB</>). </para> </listitem> </varlistentry> diff --git a/doc/src/sgml/release-9.4.sgml b/doc/src/sgml/release-9.4.sgml index 4e4f017e43c..21c6fc77f79 100644 --- a/doc/src/sgml/release-9.4.sgml +++ b/doc/src/sgml/release-9.4.sgml @@ -722,18 +722,10 @@ <listitem> <para> - Auto-tune <link - linkend="guc-effective-cache-size"><varname>effective_cache_size</></link> - to be four-times shared buffers (Bruce Momjian, Tom Lane) - </para> - </listitem> - - <listitem> - <para> Increase <link linkend="guc-work-mem"><varname>work_mem</></link> and <link linkend="guc-maintenance-work-mem"><varname>maintenance_work_mem</></link> - defaults by four-times (Bruce Momjian) + defaults by four times (Bruce Momjian) </para> <para> @@ -743,6 +735,14 @@ <listitem> <para> + Increase the default setting of <link + linkend="guc-effective-cache-size"><varname>effective_cache_size</></link> + to 4GB (Bruce Momjian, Tom Lane) + </para> + </listitem> + + <listitem> + <para> Allow terabyte units to be specified for configuration variable values (Simon Riggs) </para> |