Re: Expected accuracy of planner statistics

From: "John D(dot) Burger" <john(at)mitre(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Expected accuracy of planner statistics
Date: 2006-09-29 14:53:21
Message-ID: A1E93AA5-9312-4C95-A509-4434FDDD06BD@mitre.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

> The information we've seen says that the only statistically
> reliable way
> to arrive at an accurate n_distinct estimate is to examine most of the
> table :-(.

> IIRC I picked an equation out of the literature partially on the basis
> of it being simple and fairly cheap to compute...

I'm very curious about this - can you recall where you got this, or
at least point me to where in the code this happens?

Thanks.

- John Burger
MITRE

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message km 2006-09-29 14:55:36 Re: 8.1.4 compile problem
Previous Message Erik Jones 2006-09-29 14:39:03 Re: using schema's for data separation