Tom Lane <t...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
