Re: DB Connections - Mailing list pgsql-general

From John R Pierce
Subject Re: DB Connections
Date
Msg-id 5503263F.5010600@hogranch.com
Whole thread Raw
In response to DB Connections  (Job <Job@colliniconsulting.it>)
List 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



pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: DB Connections
Next
From: Dara Unglaube
Date:
Subject: Re: Rebuild streaming replication