Alternate or Optimization for with hold cursor - Mailing list pgsql-general

From sangeetha
Subject Alternate or Optimization for with hold cursor
Date
Msg-id 1463043450094-5903211.post@n5.nabble.com
Whole thread Raw
Responses Re: Alternate or Optimization for with hold cursor  (Rakesh Kumar <rakeshkumar464a3@gmail.com>)
Re: Alternate or Optimization for with hold cursor  (amulsul <sul_amul@yahoo.co.in>)
Re: Alternate or Optimization for with hold cursor  ("Mike Sofen" <msofen@runbox.com>)
List pgsql-general
Currently , I am using "With hold" cursor. In our case , the With hold cursor
is used to fetch the next record of the given primary key . The performance
is very slow for large data set. Can you provide me some alternative ways
like having own copy of table , or optimization for With hold cursor?

Thanks and Regards,
S.Sangeetha



--
View this message in context:
http://postgresql.nabble.com/Alternate-or-Optimization-for-with-hold-cursor-tp5903211.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Sridhar N Bamandlapally
Date:
Subject: Re: [HACKERS] NULL concatenation
Next
From: Rakesh Kumar
Date:
Subject: Re: Alternate or Optimization for with hold cursor