Tom,
Thank you for your prompt reply.
On Tue, Apr 29, 2008 at 10:19 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Len Shapiro <[EMAIL PROTECTED]> writes:
> > 1. Why does Postgres come up with a negative n_distinct?
>
> It's a fractional representation. Per the d
alues are 1
and 5, each occuring twice, so the histogram {1,5} is appropriate.
If I run the query
EXPLAIN SELECT * from sailors where rank = const;
for any const not in the MVC list, I get the plan
Seq Scan on sailors (cost=0.00..1.38 rows=2 width=21)
Filter: (rank = const)
The "rows=2"
