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. +