Re: Auto-tuning work_mem and maintenance_work_mem

On Wed, Oct  9, 2013 at 01:49:23PM -0400, Robert Haas wrote:
> > Having really bad defaults so everyone knows they are bad really isn't
> > user-friendly because the only people who know they are really bad are
> > the people who are tuning them already.  Again, we need to think of the
> > typical user, not us.
> 
> I think a typical user will be happier if we simply raise the default
> rather than stick in an auto-tuning formula that's largely wishful
> thinking.  You're welcome to disagree, but you neither quoted nor
> responded to my points about the sorts of scenarios in which that
> might cause surprising and hard-to-debug results.

Well, pointing out that is will be negative for some users (which I
agree) doesn't refute that it will be better for most users.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +