Re: a few crazy ideas about hash joins - Mailing list pgsql-hackers

From Robert Haas
Subject Re: a few crazy ideas about hash joins
Date
Msg-id 603c8f070904030845n57d7f8f7u68282a7381a8616e@mail.gmail.com
Whole thread Raw
In response to Re: a few crazy ideas about hash joins  ("Lawrence, Ramon" <ramon.lawrence@ubc.ca>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Bernd Helmle
Date:
Subject: Re: Documentation Update: Document pg_start_backup checkpoint behavior
Next
From: Tom Lane
Date:
Subject: Re: 8.4 open items list