Thread: Re: optimize hashjoin

Re: optimize hashjoin

From
Robert Haas
Date:
On Wed, Aug 21, 2024 at 12:31 PM Tomas Vondra <tomas@vondra.me> wrote:
> Anyway, I took a look and the basic idea is simple - when shuffling
> tuples between batches in a hash join, we're currently deforming the
> tuple (->slot) we just read from a batch, only to immediately form it
> (slot->) again and write it to the "correct" batch.

Does skipping this cause any problem if some attributes are toasted?

I suppose not, just something to think about.

--
Robert Haas
EDB: http://www.enterprisedb.com