Re: Selectivity estimation for inet operators - Mailing list pgsql-hackers

From Dilip kumar
Subject Re: Selectivity estimation for inet operators
Date
Msg-id 4205E661176A124FAF891E0A6BA9135266340A00@szxeml509-mbs.china.huawei.com
Whole thread Raw
In response to Re: Selectivity estimation for inet operators  (Emre Hasegeli <emre@hasegeli.com>)
Responses Re: Selectivity estimation for inet operators  (Emre Hasegeli <emre@hasegeli.com>)
List 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 by date:

Previous
From: Rushabh Lathia
Date:
Subject: Re: "RETURNING PRIMARY KEY" syntax extension
Next
From: Craig Ringer
Date:
Subject: Re: [PATCH] Improve bytea error messages