On Fri, Dec 29, 2017 at 11:47:01AM +0100, hmidi slim wrote:
> I'm trying to understand the utility of pool connection, I found that it's
> useful to enhance the performance of a database. However I want to know if
> it is a good option to put a large number in max_connection option to
> handle a large number of connection in an app?
A couple of hundred connections is already a lot as a point of
contention is snapshot build, which is particularly painful for OLTP
workloads. If you reach a point where you need hundreds of connections,
I would recommend using pgbouncer. This will save your server much CPU
by minimizing the effects of connections still around but idle.
--
Michael