Re: Patch Review Complete: Multi-Batch Hash Join Improvements - Mailing list pgsql-hackers

From Joshua Tolley
Subject Re: Patch Review Complete: Multi-Batch Hash Join Improvements
Date
Msg-id 20081119051724.GE10099@polonium.part.net
Whole thread Raw
In response to Re: Patch Review Complete: Multi-Batch Hash Join Improvements  (Jeff Davis <pgsql@j-davis.com>)
List 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

pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: Updated posix fadvise patch v19
Next
From: "Pavel Stehule"
Date:
Subject: add to documentation - upgrade from tsearch2