| From: | Dilip kumar <dilip(dot)kumar(at)huawei(dot)com> |
|---|---|
| To: | Emre Hasegeli <emre(at)hasegeli(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Andreas Karlsson <andreas(at)proxel(dot)se>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Re: Selectivity estimation for inet operators |
| Date: | 2014-07-08 04:28:05 |
| Message-ID: | 4205E661176A124FAF891E0A6BA9135266340A00@szxeml509-mbs.china.huawei.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 can match complete MCV, it will give better accuracy.
In other function like eqjoinsel also its matching complete MCV.
Thanks & Regards,
Dilip Kumar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2014-07-08 04:49:56 | Re: [PATCH] Improve bytea error messages |
| Previous Message | Rushabh Lathia | 2014-07-08 04:11:43 | Re: "RETURNING PRIMARY KEY" syntax extension |