<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 14pt; color: #000000'>Hello everyone in the list. In other mails I asked about this topic, but I have some doubt with this configuration parameters. As I know, connection pooling software like pgpool-II, has a number of connections opened and reuses them whenever a new connection with the same properties comes in.<br><br>About these configuration parameters:<br><br>max_connections: Is the maximum concurrent connections between clients and postgresql server. (postgresql property)<br><br>num_init_children: Like max_connections, it is the maximum concurrent connections between clients and pgpool-II. (pgpool property)<br><br>max_pool: The maximum number of cached connections in pgpool-II children processes. pgpool-II reuses the cached connection if an incoming connection is connecting to the same database with the same username. If not, pgpool-II creates a new connection to the backend. If the number of cached connections exceeds max_pool, the oldest connection will be discarded, and uses that slot for the new connection. (According pgpool-II documentation)<br><br><br>1. Why max_connexion must satisfy this formula max_connexion >= (Nun_init_children * max_pool) and not this max_connexion >= nun_init_children? <br><br>2. A child process only opens one connection in the database server and it can be use concurrently (max_pool), or for each child process, it open a total of max_pool connections in the database server?<br><br>3. When is possible that the number of cached connections exceeds max_pool?<br><br>The answers about these questions are welcome.<br>Thank you very much for your time and sorry for such insistence.<br>Regards<br></div>
<br><html>
<body>
<a href="http://www.uci.cu/">
<img src="http://universidad.uci.cu/email.gif"/>
</body>
</html>
<br></body></html>