Re: Query optimizer 8.0.1 (and 8.0)

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: pgsql(at)mohawksoft(dot)com
Cc: 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 17:15:55
Message-ID: 20050207171555.GA2179@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Feb 07, 2005 at 11:27:59 -0500,
pgsql(at)mohawksoft(dot)com wrote:
>
> It is inarguable that increasing the sample size increases the accuracy of
> a study, especially when diversity of the subject is unknown. It is known
> that reducing a sample size increases probability of error in any poll or
> study. The required sample size depends on the variance of the whole. It
> is mathmatically unsound to ASSUME any sample size is valid without
> understanding the standard deviation of the set.

For large populations the accuracy of estimates of statistics based on random
samples from that population are not very sensitve to population size and
depends primarily on the sample size. So that you would not expect to need
to use larger sample sizes on larger data sets for data sets over some
minimum size.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2005-02-07 17:16:41 Re: Is there a way to make VACUUM run completely outside
Previous Message Andrew Dunstan 2005-02-07 17:10:20 Re: Patent issues and 8.1