Re: [GENERAL] Cursors WITH HOLD
Thanks for reply. I do some checking and some queries boost very well :) pasman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Cursors WITH HOLD
2010/12/30 pasman pasmański > 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
[GENERAL] Cursors WITH HOLD
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general