On 6 May 2014 23:47, Josh Berkus <j...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers