Re: DB Connections

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: DB Connections
Date: 2015-03-13 18:02:39
Message-ID: 5503263F.5010600@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/13/2015 2:59 AM, Job wrote:
> The application i use need lots of static DB connections

if lots is much over a 100 or so, I'd strongly advise using a connection
pooler like pgbouncer or whatever is built into your language framework
(for instance, Java frameworks like Tomcat have built in connection
pools), and configuring your app to grab a connection from the pool, do
a transaction and release the connection.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dara Unglaube 2015-03-13 18:47:36 Re: Rebuild streaming replication
Previous Message John R Pierce 2015-03-13 17:59:55 Re: DB Connections