Cursor with hold for select - Mailing list pgsql-admin

From Bindra Bambharoliya
Subject Cursor with hold for select
Date
Msg-id CAPLVUMAwOBS1aB6h78bTBP+2EBB=Yq1ape2JsViRSV4tJGPSnQ@mail.gmail.com
Whole thread Raw
Responses Re: Cursor with hold for select
List pgsql-admin
Hi,
I am facing issue with postgresql 11.17 version.
When I use normal select it executes within 15 seconds.
When use same query with begin; cursor "sql1" hold for select....
Fetch 100 to "sql1"  it takes 3 minutes and sometime not executing even in 10 minutes. And I need to kill it.
What could be the root cause. And how can we over one form this.

pgsql-admin by date:

Previous
From: Vijaykumar Jain
Date:
Subject: Re: To redirect PgBadger logs
Next
From: James Pang
Date:
Subject: create index concurrently blocked by other query