Re: Problem with n_distinct being consistently inaccurate.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problem with n_distinct being consistently inaccurate.
Дата
Msg-id 22374.1064349244@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Problem with n_distinct being consistently inaccurate.  ("Nick Fankhauser" <nickf@ontko.com>)
Ответы Re: Problem with n_distinct being consistently inaccurate.  ("Nick Fankhauser" <nickf@ontko.com>)
Список pgsql-admin
Дерево обсуждения 
"Nick Fankhauser" <nickf@ontko.com> writes:
> So... I updated stadistinct to the actual value of 92,000 as you suggested
> and as you predicted, it did not change the plan a bit.

Just out of curiosity, what happens if you make it bigger than 92k?
Does a value 10x or 100x reality change the plan?

            regards, tom lane

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

Предыдущее
От: "Mark Carew"
Дата:
Сообщение: Re: steps to ensure referential integrity
Следующее
От: "Nick Fankhauser"
Дата:
Сообщение: Re: Problem with n_distinct being consistently inaccurate.