Cursor with hold for select takes too long
Bindra Bambharoliya <bindra.bambharoliya@gmail.com>
From: Bindra Bambharoliya <bindra.bambharoliya@gmail.com>
To: pgsql-sql@lists.postgresql.org
Date: 2024-03-22T16:50:04Z
Lists: pgsql-sql
Hi team, I am facing issues with cursor with hold for select. If I execute select quaery without cursor it takes 13 seconds, If execute it like Begin; Cursor "sql1" with hold for select.... ;fetch 100 to "sql1" It takes more than 3 minutes. Even sometimes it takes more than 10 minutes. What could be the problem? Request to help on this ASAP. I am facing this issue on production. I checked locks etc. But nothing like that. Thanks & Regards Bindra