Friday, August 22, 2008

Re: [GENERAL] Postgresql 8.3 statistic stadistinct value dead wrong even with default_statistics_target=1000

Maxim Boguk <mboguk@masterhost.ru> writes:
> [ ndistinct estimates way off ]

Estimating the number of distinct values in a distribution with a long
tail is just a really hard problem :-(

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: