Re: what does pg_activity mean when the database is stuck?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: what does pg_activity mean when the database is stuck?
Date: 2014-06-12 23:55:27
Message-ID: 539A3DEF.4060005@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-06-13 01:27:02 Re: Memory leak with CREATE TEMP TABLE ON COMMIT DROP?
Previous Message Scott Marlowe 2014-06-12 23:30:07 Re: Spurious Stalls