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
Attachment:
signature.asc
Description: PGP signature
