Re: Experimenting with hash join prefetch - Mailing list pgsql-hackers

From Dmitry Dolgov
Subject Re: Experimenting with hash join prefetch
Date
Msg-id CA+q6zcXg5-Rc4k0JY+7=gEDGWjCVp0X9t7JdnCuaAfeNmtTEZQ@mail.gmail.com
Whole thread Raw
In response to Re: Experimenting with hash join prefetch  (Andrey Borodin <x4mmm@yandex-team.ru>)
Responses Re: Experimenting with hash join prefetch  (Thomas Munro <thomas.munro@enterprisedb.com>)
List pgsql-hackers
> On Sun, 14 Oct 2018 at 06:19, Thomas Munro <thomas.munro@enterprisedb.com> wrote:
>
> Cache-oblivious hash joins cause a lot of TLB and cache misses.
> ...
> (There is another class of cache-aware hash join algorithms that partition
> carefully up front to avoid them; that's not us.)

Just out of curiosity, can you please elaborate more on this part (with
references)? I'm thinking about this topic for a while, and I'm wondering, if
by another class you mean something like this [1], then even if it's not us
today, are there any issues that prevent from experimenting in this area?

[1]: https://www.cse.ust.hk/catalac/papers/coqp_tods08.pdf


pgsql-hackers by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: B-tree cache prefetches
Next
From: Thomas Munro
Date:
Subject: Re: Experimenting with hash join prefetch