Tom Lane wrote:
The information we've seen says that the only statistically reliable wayto 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