On 01/03/2013 12:51 PM, tuanhoanganh wrote: > On Thu, Jan 3, 2013 at 11:04 AM, John R Pierce <pie...@hogranch.com > <mailto:pie...@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
