Re: Proposal - improve eqsel estimates by including histogram bucket numdistinct statistics

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Proposal - improve eqsel estimates by including histogram bucket numdistinct statistics
Дата
Msg-id 12033.1213294051@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Proposal - improve eqsel estimates by including histogram bucket numdistinct statistics  ("Nathan Boley" <npboley@gmail.com>)
Список pgsql-hackers
"Nathan Boley" <npboley@gmail.com> writes:
> Given that, wouldn't it be smarter to consider a value as an mcv
> candidate iff it has a density greater than 0.005, rather than having
> a count greater than 1.5*average?

Yeah, perhaps ... want to experiment with that?  Though I'd be a bit
worried about how to get the threshold right, seeing that it will
depend a whole lot on what the user has selected for random_page_cost
and other parameters.
        regards, tom lane


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

Предыдущее
От: "Nathan Boley"
Дата:
Сообщение: Re: Proposal - improve eqsel estimates by including histogram bucket numdistinct statistics
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: cannot use result of (insert..returning)