The maximum number of connections is an important parameter in configuring a database. Each client connection consumes memory, thus also affecting the total amount of memory that can be allocated for other purposes. The max_connections configuration parameter's default value is 100; lowering this value allows the database administrator to increase the work_mem setting. In general, it is good practice to use connection-pooling software to reduce the amount of memory used and increase performance, as killing and establishing a connection wastes time. There are a lot of connection-pooling tools, but the most mature ones are:

• PgBouncer
• Pgpool-II

Also, one could use connection pooling on the business level. For example, for Java there are many alternatives for connection pooling, such as Hikari, the Apache Tomcat connection pool, dbcp2, and c3p0.