BUG #17078: Timeout issue in getting large amount data in Dot Net application using cursors

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: aliakbar(dot)pinjari(at)gmail(dot)com
Subject: BUG #17078: Timeout issue in getting large amount data in Dot Net application using cursors
Date: 2021-06-30 11:26:50
Message-ID: 17078-5e5b1bb6a3f1a8c5@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17078
Logged by: Ali Pinjari
Email address: aliakbar(dot)pinjari(at)gmail(dot)com
PostgreSQL version: 10.14
Operating system: AWS Postgres RDS
Description:

Hi Team,

Facing timeout issue in getting large amount data in Dot Net application
using cursors. We are using Npgsql dll of 4.0.10 version.

More details:- We are using a postgress function which returns three cursors
i.e. three table data. When getting data using cursor from the application
taking more time and sometimes getting timeout or connection issues. Where
as same executed in the DB, getting results in seconds.

Exact error:- A connection attempt failed because the connected party did
not properly respond after a period of time, or established connection
failed because connected host has failed to respond at
System.Net.Sockets.Socket.Receive

Do we have any alternative in returning more than one table data from a
function without using ref cursor?

Browse pgsql-bugs by date

  From Date Subject
Next Message Fujii Masao 2021-07-01 00:54:47 Re: BUG #17073: docs - "Improve signal handling reliability"
Previous Message PG Bug reporting form 2021-06-30 06:09:48 BUG #17077: about three parameters in postgresql 13.3