On Fri, Jan 27, 2017 at 11:44 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I'm afraid though that we may have to do something about the
> irrelevant-joinquals issue in order for this to be of much real-world
> use for inner joins.
Maybe, but it's certainly not the case that all inner joins are highly
selective. There are plenty of inner joins in real-world applications
where the join product is 10% or 20% or 50% of the size of the larger
input.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company