Re: Query optimizer 8.0.1 (and 8.0) - Mailing list pgsql-hackers

From Bruno Wolff III
Subject Re: Query optimizer 8.0.1 (and 8.0)
Date
Msg-id 20050207171555.GA2179@wolff.to
Whole thread Raw
In response to Re: Query optimizer 8.0.1 (and 8.0)  (pgsql@mohawksoft.com)
Responses Re: Query optimizer 8.0.1 (and 8.0)  (pgsql@mohawksoft.com)
List pgsql-hackers
On Mon, Feb 07, 2005 at 11:27:59 -0500, pgsql@mohawksoft.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.


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Patent issues and 8.1
Next
From: Andrew Dunstan
Date:
Subject: Re: Patent issues and 8.1