On Fri, Apr 3, 2009 at 11:24 AM, Lawrence, Ramon <ramon.lawrence@ubc.ca> wrote:
> I would be interested in working with you on any of these changes to
> hash join if you decide to pursue them. I am especially interested in
> looking at the hash aggregation code and potentially improving its
> efficiency.
Wow, that would be great!
> We have implemented a multi-way hash join (can join more than 2 tables
> at a time) which may help with cases #3 and #4. Performance results
> look very good, and we are planning on building a patch for this over
> the summer.
I'd be interested in hearing you cope with this on the planner end of things.
...Robert