Request a Demo
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 [email protected]
Whole thread Raw
In response to Re: PostgreSQL run as process in windows  (tuanhoanganh <[email protected]>)
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 <[email protected]> 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