Postgres Pro
Downloads
Home   >   mailing lists

Thread: Cursors WITH HOLD

Cursors WITH HOLD

From
pasman pasmański
Date:
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 ?

regards.

------------
pasman

Re: Cursors WITH HOLD

From
Gurjeet Singh
Date:
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

Re: Cursors WITH HOLD

From
pasman pasmański
Date:
Thanks for reply.

I do some checking and
some queries boost very well :)


------------
pasman