Re: Client-server communication for FETCH - Mailing list pgsql-performance

From Jan Claeys
Subject Re: Client-server communication for FETCH
Date
Msg-id 8350a74f301180a0e5449da5a97d837800e4d6fa.camel@janc.be
Whole thread Raw
In response to Re: Client-server communication for FETCH  (Tim Fors <tim4stheenchanter@gmail.com>)
List 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)



pgsql-performance by date:

Previous
From: Vincent Veyron
Date:
Subject: Re: Why is my query 3 times faster on my workstation than on my server?
Next
From: MentionTheElephant
Date:
Subject: Seeking guidance on extremely slow pg_restore despite strong I/O performance