pgsql: Increase the default value of effective_cache_size to 4GB.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Increase the default value of effective_cache_size to 4GB.
Date: 2014-05-09 01:11:53
Message-ID: E1WiZLt-0004Fo-8B@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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.

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/b910d7ea358b0134d170ebf4002248df25a5f244

Modified Files
--------------
doc/src/sgml/config.sgml | 4 ++--
doc/src/sgml/release-9.4.sgml | 18 +++++++++---------
src/backend/utils/misc/postgresql.conf.sample | 2 +-
src/include/optimizer/cost.h | 2 +-
4 files changed, 13 insertions(+), 13 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2014-05-09 01:46:04 pgsql: Document permissions needed for pg_database_size and pg_tablespa
Previous Message Tom Lane 2014-05-09 00:49:53 pgsql: Revert "Auto-tune effective_cache size to be 4x shared buffers"