Re: Bypassing cursors in postgres_fdw to enable parallel plans - Mailing list pgsql-hackers

From Alexander Pyhalov
Subject Re: Bypassing cursors in postgres_fdw to enable parallel plans
Date
Msg-id e151c0a5ff43772f35dfceb1e041f333@postgrespro.ru
Whole thread Raw
In response to Re: Bypassing cursors in postgres_fdw to enable parallel plans  (Rafia Sabih <rafia.pghackers@gmail.com>)
List pgsql-hackers
Rafia Sabih писал(а) 2025-11-27 13:50:
> On Tue, 25 Nov 2025 at 15:24, KENAN YILMAZ
> <kenan.yilmaz@localus.com.tr> wrote:
> 
>> Hello Hackers,
>> 
>> I have executed use_cursor = true/false with quick tests.
>> 

Hi.

I've looked at this patch, because also was playing with tuplestore in 
PgFdwScanState to have more predictable memory usage with large 
fetch_size. Unfortunately, I've found that you can't use 
TTSOpsMinimalTuple(?) tuplestore to store tuple's ctid. I hoped this 
patch provides some solution for this issue, but no, it seems have the 
same problem. Attaching test case with a reproducer.
-- 
Best regards,
Alexander Pyhalov,
Postgres Professional
Attachment

pgsql-hackers by date:

Previous
From: Jakub Wartak
Date:
Subject: Re: pg_plan_advice
Next
From: "Anders Åstrand"
Date:
Subject: [Proposal] Generate pkg-config for server module development