Skip site navigation (1) Skip section navigation (2)

Re: a few crazy ideas about hash joins

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: "Lawrence, Ramon" <ramon(dot)lawrence(at)ubc(dot)ca>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: a few crazy ideas about hash joins
Date: 2009-04-03 15:45:55
Message-ID: 603c8f070904030845n57d7f8f7u68282a7381a8616e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Fri, Apr 3, 2009 at 11:24 AM, Lawrence, Ramon <ramon(dot)lawrence(at)ubc(dot)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

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-04-03 16:02:51
Subject: Re: 8.4 open items list
Previous:From: Bernd HelmleDate: 2009-04-03 15:39:30
Subject: Re: Documentation Update: Document pg_start_backup checkpoint behavior

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group