Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL run as process in windows - Mailing list pgsql-general

From Craig Ringer
Subject Re: PostgreSQL run as process in windows
Date
Msg-id 50EB8514.7020703@2ndQuadrant.com
Whole thread Raw
In response to Re: PostgreSQL run as process in windows  (tuanhoanganh <hatuan05@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Craig Ringer
Date:
Subject: Re: PostgreSQL run as process in windows
Next
From: Craig Ringer
Date:
Subject: Re: Database Design: Maintain Audit Trail of Changes