On Fri, 2008-11-14 at 02:21 +0000, Gregory Stark wrote: > Simon Riggs <[EMAIL PROTECTED]> 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.com PostgreSQL Training, Services and Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
