Re: Patch Review Complete: Multi-Batch Hash Join Improvements

From: Joshua Tolley <eggyknap(at)gmail(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, ramon(dot)lawrence(at)ubc(dot)ca, pandasuit(at)gmail(dot)com
Subject: Re: Patch Review Complete: Multi-Batch Hash Join Improvements
Date: 2008-11-19 05:17:24
Message-ID: 20081119051724.GE10099@polonium.part.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Nov 17, 2008 at 10:42:21PM -0800, Jeff Davis wrote:
> On Mon, 2008-11-17 at 23:19 -0700, Joshua Tolley wrote:
> > -- it speeds up joins by fairly significant margins in some cases
>
> The original claim in the message you cite says 10-50% for some data
> distributions. Were you able to observe that kind of speedup?
>
> Regards,
> Jeff Davis
>

Oh, great, and now I can't find my numbers anymore :) After some
reflection I think there's some more formal verification I should expect
of myself before saying I'm done. I can say I saw results that supported
those claims, but I didn't gather enough data to prove them. Stay tuned
for details.

- Josh

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2008-11-19 06:06:13 add to documentation - upgrade from tsearch2
Previous Message Robert Haas 2008-11-19 04:01:11 Re: Updated posix fadvise patch v19