Re: PostgreSQL run as process in windows

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: PostgreSQL run as process in windows
Дата
Msg-id 50EB8514.7020703@2ndQuadrant.com
обсуждение исходный текст
Ответ на Re: PostgreSQL run as process in windows  (tuanhoanganh <hatuan05@gmail.com>)
Список pgsql-general
Дерево обсуждения
On 01/03/2013 12:51 PM, tuanhoanganh wrote:
On Thu, Jan 3, 2013 at 11:04 AM, John R Pierce <pierce@hogranch.com> wrote:
of course, a pooler only works right if the client applications are modified to open a connection, do a transaction, and close the connection.  if the clients continue to hold idle connections, the pooler won't do anything useful for you.

:-( My application continue to hold idle connections.
Idle CONNECTIONS are fine.

What you need to avoid is open transactions being held open and idle for long periods.

-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: PostgreSQL run as process in windows
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Database Design: Maintain Audit Trail of Changes