Re: Selectivity estimation for inet operators

Поиск
Список
Период
Сортировка
От Dilip kumar
Тема Re: Selectivity estimation for inet operators
Дата
Msg-id 4205E661176A124FAF891E0A6BA9135266340A00@szxeml509-mbs.china.huawei.com
обсуждение исходный текст
Ответ на Re: Selectivity estimation for inet operators  (Emre Hasegeli <emre@hasegeli.com>)
Ответы Re: Selectivity estimation for inet operators  (Emre Hasegeli <emre@hasegeli.com>)
Список pgsql-hackers
On 06 July 2014 20:33, Emre Hasegeli Wrote,
> 
> > Apart from that there is one spell check you can correct
> > -- in inet_his_inclusion_selec comments histogram boundies  ->
> > histogram boundaries :)
> 
> I fixed it.  New version attached.  The debug log statements are also
> removed.

I have done with the review, patch seems fine to me

I have one last comment, after clarifying this I can move it to "ready for committer".
1. In networkjoinsel, For avoiding the case of huge statistics, only some of the values from mcv and histograms are
used(calculated using SQRT).
 
-- But in my opinion, if histograms and mcv both are exist then its fine, but if only mcv's are there in that case, we
canmatch complete MCV, it will give better accuracy.  In other function like eqjoinsel also its matching complete MCV.
 



Thanks & Regards,
Dilip Kumar

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

Предыдущее
От: Rushabh Lathia
Дата:
Сообщение: Re: "RETURNING PRIMARY KEY" syntax extension
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: [PATCH] Improve bytea error messages