Re: ANALYZE sampling is too good

From: Greg Stark <stark(at)mit(dot)edu>
To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>
Subject: Re: ANALYZE sampling is too good
Date: 2013-12-10 14:02:35
Message-ID: CAM-w4HPdMtPiS9A3cj1gfO0vjUT4eK3KXyKpv8FLrnv1cN529w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 10 Dec 2013 08:28, "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:
>
>
> Doesn't all that assume a normally distributed random variable?

I don't think so because of the law of large numbers. If you have a large
population and sample it the sample behaves like a normal distribution when
if the distribution of the population isn't.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2013-12-10 14:24:56 Re: New option for pg_basebackup, to specify a different directory for pg_xlog
Previous Message Claudio Freire 2013-12-10 13:55:58 Re: Optimize kernel readahead using buffer access strategy