Re: optimize hashjoin - Mailing list pgsql-hackers

From Robert Haas
Subject Re: optimize hashjoin
Date
Msg-id CA+TgmoZVEZ9-CD5gSzRzPrWbYYwnMb0sc-DPFsA19KkZBjibaQ@mail.gmail.com
Whole thread Raw
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [PATCH] Add get_bytes() and set_bytes() functions
Next
From: Alvaro Herrera
Date:
Subject: Re: MultiXact\SLRU buffers configuration