Re: Revisiting default_statistics_target

On Sun, 2009-06-07 at 12:13 -0400, Tom Lane wrote:

> In any case, what we seem to have here is evidence that there are some
> cases where the new default value of default_statistics_target is too
> high and you can get a benefit by lowering it.  I'm not sure we should
> panic about that.  Default values ought to be compromises.  If people
> only ever change the default in one direction then it's probably not a
> very good compromise.  We know that there are applications for which
> 100 is still too low, so maybe now we have got the pain spread out
> roughly evenly...

I'm certainly happy with 100 as the default.

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support