Re: Cursors WITH HOLD

Поиск
Список
Период
Сортировка
От Gurjeet Singh
Тема Re: Cursors WITH HOLD
Дата
Msg-id AANLkTi=-G6GAEt10S-n0iV_qmWNkjibKRaYK2Q0JS=xj@mail.gmail.com
обсуждение исходный текст
Ответ на Cursors WITH HOLD  (pasman pasmański <pasman.p@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Andre Lopes
Дата:
Сообщение: Re: Need advise for database structure for non linear data.
Следующее
От: pasman pasmański
Дата:
Сообщение: Re: Cursors WITH HOLD