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

From Simon Riggs
Subject Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers
Date
Msg-id CA+U5nMJbwH78uXKZXB9_FQD_CWYsr5-Vrkk8-FdD6tpU1VK=+g@mail.gmail.com
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  (Peter Geoghegan <pg@heroku.com>)
List pgsql-hackers
On 6 May 2014 23:47, Josh Berkus <josh@agliodbs.com> wrote:

> If you're going to make
> an argument in favor of different tuning advice, then do it based on
> something in which you actually believe, based on hard evidence.

The proposed default setting of 4x shared_buffers is unprincipled
*and* lacks hard evidence from you and everybody else.

You've used the phrase "conventional wisdom" to describe things which
you have spoken loudly about.  I personally have not seen sufficient
evidence to rely on that as wisdom.

I note that my detailed comments as to why it is unsafe have been
ignored, again.

-- Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: New pg_lsn type doesn't have hash/btree opclasses
Next
From: Simon Riggs
Date:
Subject: Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers