Re: PoC: prefetching data between executor nodes (e.g. nestloop + indexscan)

From: Tomas Vondra <tomas(at)vondra(dot)me>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PoC: prefetching data between executor nodes (e.g. nestloop + indexscan)
Date: 2024-08-27 10:38:48
Message-ID: d9481d59-ccc4-4fa5-aa7e-d53614757d16@vondra.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 8/26/24 18:06, Tomas Vondra wrote:
>
> I just noticed there's a couple failures in the regression tests, if I
> change the GUC to "true" by default. I haven't looked into that yet, but
> I guess there's some mistake in resetting the child node, or something
> like that. Will investigate.
>

Turned out to be a silly bug - not resetting the queue on rescan. Fixed,
and also removed two not-quite-correct asserts. No other changes.

regards

--
Tomas Vondra

Attachment Content-Type Size
v20240827-0001-nestloop-prefetch-initial-PoC.patch text/x-patch 14.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Shirisha Shirisha 2024-08-27 10:50:40 Redux: Throttle WAL inserts before commit
Previous Message Amit Kapila 2024-08-27 10:24:55 Re: Doc: fix the note related to the GUC "synchronized_standby_slots"