Re: benchmarking the query planner

Simon Riggs <simon@2ndQuadrant.com> writes:
> On Fri, 2008-12-12 at 13:18 -0500, Tom Lane wrote:
>> Could we skip the hyperbole please?

> Some of the ndistinct values are very badly off, and in the common cases
> I cited previously, consistently so.

> Once I'm certain the rescue helicopter has seen me, I'll stop waving my
> arms. (But yes, OK).

Well, AFAICT we have agreed in this thread to kick up the default and
maximum stats targets by a factor of 10 for 8.4.  If there's anything
to your thesis that a bigger sample size will help, that should already
make a noticeable difference.  I'm inclined to wait for some field
experience with 8.4 before we start making fundamental changes to the
ANALYZE code.
        regards, tom lane