pool connection
HI,
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?
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