Re: Selectivity estimation for inet operators

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: Raw Message | Whole Thread | Download mbox | Resend email
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

In response to


Browse pgsql-hackers by date

  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