Re: Client-server communication for FETCH

2025-12-05 Thread Jan Claeys
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 P

Re: Client-server communication for FETCH

2025-12-03 Thread Tim Fors
Thanks for the quick reply Tom. Let me give you a bit of background info: Oracle has a COBOL pre-processor for embedded SQL, and it supports an option named PREFETCH: The precompiler option PREFETCH allows for more efficient queries by > pre-fetching rows. This decreases the number of server rou

Re: Client-server communication for FETCH

2025-12-03 Thread Tom Lane
Tim Fors writes: > I have a simple C program using libpq V18 to FETCH one row at a time (see > below). Does the server send multiple rows to the client where they are > cached for satisfying the FETCH statements, or does it just send one row at > a time since that's all that each FETCH statement i