Re: Cursors WITH HOLD - Mailing list pgsql-general

From Gurjeet Singh
Subject Re: Cursors WITH HOLD
Date
Msg-id AANLkTi=-G6GAEt10S-n0iV_qmWNkjibKRaYK2Q0JS=xj@mail.gmail.com
Whole thread Raw
In response to Cursors WITH HOLD  (pasman pasmański <pasman.p@gmail.com>)
List pgsql-general
2010/12/30 pasman pasmański <pasman.p@gmail.com>
Hello.

I use Postgres 8.4.5 via perl DBI.
And i try to use cursors WITH HOLD to materialize
often used queries.

My question is how many cursors may be
declared per session and which memory setting s
to adjust for them ?

I believe there's no maximum limit to the number of cursors in Postgres. It is limited only by the amount of memory available to the Postgres process.

Regards,
--
gurjeet.singh
@ EnterpriseDB - The Enterprise Postgres Company
http://www.EnterpriseDB.com

singh.gurjeet@{ gmail | yahoo }.com
Twitter/Skype: singh_gurjeet

Mail sent from my BlackLaptop device

pgsql-general by date:

Previous
From: Andre Lopes
Date:
Subject: Re: Need advise for database structure for non linear data.
Next
From: pasman pasmański
Date:
Subject: Re: Cursors WITH HOLD