Postgres Pro
Downloads
Home   >   mailing lists

Re: what does pg_activity mean when the database is stuck? - Mailing list pgsql-general

From Si Chen
Subject Re: what does pg_activity mean when the database is stuck?
Date
Msg-id CAAYSSjOH5k=e_Sa=bUJf8UDgT496CrjqRz9j+5Ga3U1enX+sxQ@mail.gmail.com
Whole thread Raw
In response to Re: what does pg_activity mean when the database is stuck?  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
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 <pierce@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.
sichen@opensourcestrategies.com
http://www.OpenSourceStrategies.com
LinkedIn: http://www.linkedin.com/in/opentaps
Twitter: http://twitter.com/opentaps

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Spurious Stalls
Next
From: Jaco Engelbrecht
Date:
Subject: Re: Spurious Stalls