Re: Bad n_distinct estimation; hacks suggested? - Mailing list pgsql-performance

Marko,

> Sometimes, if the random number generator, that PostgreSQL uses,
> isn't good enough, the randomly selected pages for the statistics
> might not be random enough.
>
> Solaris is unknown to me. Maybe the used random number generator there
> isn't good enough?

Hmmm.  Good point.  Will have to test on Linux.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco