From: | Si Chen <sichen(at)opensourcestrategies(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: what does pg_activity mean when the database is stuck? |
Date: | 2014-06-13 21:54:19 |
Message-ID: | CAAYSSjOH5k=e_Sa=bUJf8UDgT496CrjqRz9j+5Ga3U1enX+sxQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)hogranch(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Si Chen
Open Source Strategies, Inc.
sichen(at)opensourcestrategies(dot)com
http://www.OpenSourceStrategies.com
LinkedIn: http://www.linkedin.com/in/opentaps
Twitter: http://twitter.com/opentaps
From | Date | Subject | |
---|---|---|---|
Next Message | Jaco Engelbrecht | 2014-06-13 23:26:39 | Re: Spurious Stalls |
Previous Message | Scott Marlowe | 2014-06-13 20:10:19 | Re: Spurious Stalls |