Yes, that would be nice, but it's a big app a lot of which we didn't write, etc.--you can imagine the rest ;)
Is there even a way for postgreql to get me all the queries that has gone through a particular process, so we can see what the app was trying to do that left the connection hanging? On Thu, Jun 12, 2014 at 4:55 PM, John R Pierce <pie...@hogranch.com> wrote: > On 6/12/2014 4:24 PM, Si Chen wrote: > >> PgBouncer looks pretty cool. Do you recommend using it with jdbc with >> about 50 - 100 normal connections? >> > > Java has quite a few built in connection pooling options. > > they all work best if your software is configured to grab a connection, > use it for a transaction, then release it back to the pool. > > -- > john r pierce 37N 122W > somewhere on the middle of the left coast > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Si Chen Open Source Strategies, Inc. sic...@opensourcestrategies.com http://www.OpenSourceStrategies.com LinkedIn: http://www.linkedin.com/in/opentaps Twitter: http://twitter.com/opentaps
