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