2010/12/30 pasman pasmaÅski <pasman.p@xxxxxxxxx>
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,
-- 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
