Re: Query optimizer 8.0.1 (and 8.0)

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: pgsql(at)mohawksoft(dot)com
Cc: Bruno Wolff III <bruno(at)wolff(dot)to>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Query optimizer 8.0.1 (and 8.0)
Date: 2005-02-07 22:31:33
Message-ID: 20050207223133.GB30539@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Feb 07, 2005 at 05:16:56PM -0500, pgsql(at)mohawksoft(dot)com wrote:
> > On Mon, Feb 07, 2005 at 13:28:04 -0500,
> >
> > What you are saying here is that if you want more accurate statistics, you
> > need to sample more rows. That is true. However, the size of the sample
> > is essentially only dependent on the accuracy you need and not the size
> > of the population, for large populations.
> >
> That's nonsense.

Huh, have you studied any statistics?

--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"At least to kernel hackers, who really are human, despite occasional
rumors to the contrary" (LWN.net)

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message pgsql 2005-02-07 22:36:27 Re: Query optimizer 8.0.1 (and 8.0)
Previous Message pgsql 2005-02-07 22:16:56 Re: Query optimizer 8.0.1 (and 8.0)