Re: Simple postgresql.conf wizard

On Fri, 2008-11-14 at 02:21 +0000, Gregory Stark wrote:
> Simon Riggs <simon@2ndQuadrant.com> writes:
> 
> > Your factual comments are accurate, but for Josh's stated target of Data
> > Warehousing, a stats target of 400 is not unreasonable in some cases.
> > What you forget to mention is that sample size is also determined by
> > stats target and for large databases this can be a more important
> > consideration than the points you mention.
> 
> Even for data warehousing I would not recommend setting it as a *default*
> statistics target, at least not without verifying that it doesn't cause any
> problems.

I agree with you that it would be likely misused by many people, simply
because the term "data warehouse" is a very loosely defined concept.

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