Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers
Date
Msg-id 20130911131830.GQ16378@momjian.us
Whole thread Raw
In response to Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers  (Josh Berkus <josh@agliodbs.com>)
Responses Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers
List pgsql-hackers
On Tue, Sep 10, 2013 at 03:08:24PM -0700, Josh Berkus wrote:
> Merlin,
> 
> > I vote 4x on the basis that for this setting (unlike almost all the
> > other memory settings) the ramifications for setting it too high
> > generally aren't too bad.  Also, the o/s and temporary memory usage as
> > a share of total physical memory has been declining over time
> 
> If we're doing that, then we should change our general advice on this
> setting as well.

Uh, what general advice?  I don't see 4x mentioned anywhere.

> Another argument in favor: this is a default setting, and by default,
> shared_buffers won't be 25% of RAM.

So, are you saying you like 4x now?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Compression of full-page-writes
Next
From: Michael Paquier
Date:
Subject: Re: Triggers on foreign tables