Re: [PERFORM] n_distinct way off, but following a pattern.

2003-11-16 Thread Nick Fankhauser
> It would be interesting to see exactly what inputs are going into this > equation. Do you feel like adding some debug printouts into this code? > Or just looking at the variables with a debugger? In 7.3 it's about > line 1060 in src/backend/commands/analyze.c. Tom- I don't really have time

Re: [PERFORM] n_distinct way off, but following a pattern.

2003-11-14 Thread Tom Lane
"Nick Fankhauser" <[EMAIL PROTECTED]> writes: > I'm seeing estimates for n_distinct that are way off for a large table Estimating n_distinct from a small sample is inherently a hard problem. I'm not surprised that the estimates would get better as the sample size increases. But maybe we can do be