Take advantage of PREPARE (Pool of Conections)

Поиск
Список
Период
Сортировка
От Marcos
Тема Take advantage of PREPARE (Pool of Conections)
Дата
Msg-id 1140173236.1250.16.camel@servidor
обсуждение исходный текст
Ответы Re: Take advantage of PREPARE (Pool of Conections)  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
Hi,

I will have an aplication on the web that will have many connections
because it will be looking for data.

I'm doing the main functions that will be used in PL/PGSQL, they use the
PREPARE resource, but in order to use it, I need the connection to be
permanent because the PLAN generated by PREPARE only exists while the
connection is opened.

This means, if each visitor of the website opens and closes the
connection, PREPARE is useless.

I need the connection pool for POSTGRESQL for Linux, but i don't know
how to do this.

Thanks in advance.

Marcos.



В списке pgsql-general по дате отправления:

Предыдущее
От: William Leite Araújo
Дата:
Сообщение: Re: return setof and Temp tables
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Take advantage of PREPARE (Pool of Conections)