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

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas OSB sIT
Тема Re: Proposal - improve eqsel estimates by including histogram bucket numdistinct statistics
Дата
Msg-id 6DAFE8F5425AB84DB3FCA4537D829A561BBF8B9278@M0164.s-mxs.net
обсуждение исходный текст
Ответ на Re: Proposal - improve eqsel estimates by including histogram bucket numdistinct statistics  (Gregory Stark <stark@enterprisedb.com>)
Ответы Re: Proposal - improve eqsel estimates by including histogram bucket numdistinct statistics
Список pgsql-hackers
Дерево обсуждения 
> > I think for low ndistinct values we will want to know the exact
> > value + counts and not a bin. So I think we will want
> additional stats rows
> > that represent "value 'a1' stats".
>
> Isn't that what our most frequent values list does?

Maybe ? Do we have the relevant stats for each ?
But the trick is to then exclude those values from the histogram bins.

Andreas

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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: Proposal - improve eqsel estimates by including histogram bucket numdistinct statistics
Следующее
От: "Dawid Kuroczko"
Дата:
Сообщение: RFD: ALTER COLUMN .. SET STORAGE COMPRESSED;