Re: New style of hash join proposal - Mailing list pgsql-hackers

From Tom Lane
Subject Re: New style of hash join proposal
Date
Msg-id 21264.1205721256@sss.pgh.pa.us
Whole thread Raw
In response to New style of hash join proposal  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: New style of hash join proposal  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Gregory Stark <stark@enterprisedb.com> writes:
> We currently execute a lot of joins as Nested Loops which would be more
> efficient if we could batch together all the outer keys and execute a single
> inner bitmap index scan for all of them together.

Please give an example of what you're talking about that you think we
can't do now.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Commit fest?
Next
From: Cristian Gafton
Date:
Subject: Re: Single table forcing sequential scans on query plans