Re: Odd statistics behaviour in 7.2

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Odd statistics behaviour in 7.2
Date: 2002-02-16 20:20:28
Message-ID: 20020216202028.GA7882@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Feb 15, 2002 at 07:09:42PM -0500,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> 3. The equation is numerically stable even when n is much smaller than
> N, because the only cancellation is in the term (n - f1) which we can
> compute exactly. A lot of the other equations I looked at depend on
> series like (1 - n/N)**i which are going to be really nasty when n/N
> is tiny.

You can work with the above for n << N by using power series. For n << N,
(1 - n/N)**i ~= 1 - in/N.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-02-16 20:34:26 Re: Odd statistics behaviour in 7.2
Previous Message Tom Lane 2002-02-16 19:03:43 Re: 7.2 and current timestamp bug?