Re: Bad n_distinct estimation; hacks suggested?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Bad n_distinct estimation; hacks suggested?
Дата
Msg-id 200504221152.51736.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: Bad n_distinct estimation; hacks suggested?  (Marko Ristola <marko.ristola@kolumbus.fi>)
Ответы Re: Bad n_distinct estimation; hacks suggested?  (Josh Berkus <josh@agliodbs.com>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Marko Ristola
Дата:
Сообщение: Re: Bad n_distinct estimation; hacks suggested?
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Bad n_distinct estimation; hacks suggested?