Postgres Pro
Downloads
Home   >   mailing lists

Cursor with hold for select takes too long - Mailing list pgsql-sql

From Bindra Bambharoliya
Subject Cursor with hold for select takes too long
Date
Msg-id CAPLVUMDKVU7YmZwUYM=oeXypj-r42++LCqW8aaWXnwPqpSmt6g@mail.gmail.com
Whole thread Raw
Responses Re: Cursor with hold for select takes too long
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: UPDATE with AND clarification
Next
From: Erik Brandsberg
Date:
Subject: Re: Cursor with hold for select takes too long