2010/12/30 pasman pasmański <pasma...@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.gurj...@{ gmail | yahoo }.com Twitter/Skype: singh_gurjeet Mail sent from my BlackLaptop device
