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

From John R Pierce
Subject Re: what does pg_activity mean when the database is stuck?
Date
Msg-id 539A3DEF.4060005@hogranch.com
Whole thread Raw
In response to Re: what does pg_activity mean when the database is stuck?  (Si Chen <sichen@opensourcestrategies.com>)
Responses Re: what does pg_activity mean when the database is stuck?
List pgsql-general
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



pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Spurious Stalls
Next
From: Tom Lane
Date:
Subject: Re: Memory leak with CREATE TEMP TABLE ON COMMIT DROP?