Re: Client-server communication for FETCH

From: Jan Claeys <lists(at)janc(dot)be>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Client-server communication for FETCH
Date: 2025-12-05 09:08:53
Message-ID: 8350a74f301180a0e5449da5a97d837800e4d6fa.camel@janc.be
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 2025-12-03 at 14:45 -0500, Tim Fors wrote:
> Do you have any further thoughts re: addressing this requirement
> (client-side cursor support)? Is this a requirement that the PGSQL
> community would consider implementing in libpq? Without it, it seems
> like a huge impediment to adoption of PGSQL for COBOL applications,
> and as you probably know, COBOL applications are still very
> pervasive. (C programs using ECPG would of course hit the same issue,
> so it's not just a COBOL-specific problem.)

Sounds to me like this ought to be implemented in ECPG and/or its COBOL
equivalent, not in libpq?

That's where the "Embedded SQL" is implemented after all, and also the
equivalent of where Oracle implements its PREFETCH, I think?

And I suppose nobody would be opposed to such improvements, if someone
contributes them or pays for their development...

--
Jan Claeys

(please don't CC me when replying to the list)

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message MentionTheElephant 2025-12-05 10:30:38 Seeking guidance on extremely slow pg_restore despite strong I/O performance
Previous Message Pavel Stehule 2025-12-05 06:50:25 Re: proposal: schema variables