Re: PostgreSQL run as process in windows

Craig Ringer <craig@xxxxxxxxxxxxxxx> · Tue, 08 Jan 2013 10:31:48 +0800



    On 01/03/2013 12:51 PM, tuanhoanganh
      wrote:

    
        On Thu, Jan 3, 2013 at 11:04 AM, John R
          Pierce <pierce@xxxxxxxxxxxx>
          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