| From: | Emre Hasegeli <emre(at)hasegeli(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Dilip kumar <dilip(dot)kumar(at)huawei(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Andreas Karlsson <andreas(at)proxel(dot)se>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
| Subject: | Re: Selectivity estimation for inet operators |
| Date: | 2014-09-07 16:09:39 |
| Message-ID: | 20140907160939.GA25883@debian |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > > I updated the patch to cover semi and anti joins with eqjoinsel_semi().
> > > I think it is better than returning a constant.
> >
> > What you did there is utterly unacceptable from a modularity standpoint;
> > and considering that the values will be nowhere near right, the argument
> > that "it's better than returning a constant" seems pretty weak. I think
> > you should just take that out again.
>
> I will try to come up with a better, data type specific implementation
> in a week.
New version with semi join estimation function attached.
| Attachment | Content-Type | Size |
|---|---|---|
| inet-selfuncs-v11.patch | text/x-diff | 28.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Gierth | 2014-09-07 16:52:21 | Re: Final Patch for GROUPING SETS - unrecognized node type: 347 |
| Previous Message | Marko Tiikkaja | 2014-09-07 15:43:19 | Re: Improving PL/PgSQL |