Tom Lane <tgl@sss.pgh.pa.us> writes:
> I can't get all *that* excited about complicating hash joins as
> proposed. The query is still fundamentally going to be slow because
> you won't get out of having to seqscan the large table. The only way
> to make it really fast is to not read all of the large table, and
> nestloop-with-inner-indexscan is the only plan type with a hope of
> doing that.
That sounds somewhat like Loose Indexscan as described in the following
wiki page, right?
http://wiki.postgresql.org/wiki/Loose_indexscan
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support