<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 14pt; color: #000000'>Tatsuo, sorry for my questions. It is not my intention to criticize the documentation because I think the documentation of pgpool-II is very good. I just write you because I need understand some things that I do not know. Maybe my questions are not writen in a good way.<br> <br>When max_pool has a value such as 4. It means that the same child process can be opened 4 connections regardless of the connections that can be reused?<br><br>Thank you very much for your time.<br><br>Regards.<br><br><hr id="zwchr"><blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;">> 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>Have you read this section in the pgpool doc? If yes and still have<br>questions please clarify. I would love to hear from you to enhance our<br>document.<br><br><dt><a name="MAX_POOL"></a>max_pool</dt><br> <dd><br> <p>The maximum number of cached connections in pgpool-II children processes.<br> pgpool-II reuses the cached connection if an incoming connection is<br> connecting to the same database with the same username.<br> If not, pgpool-II creates a new connection to the backend.<br> If the number of cached connections exceeds max_pool,<br> the oldest connection will be discarded, and uses that slot for the new connection.<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>> <br>> <br>> 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...<br>> CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br>> <br>> http://www.uci.cu<br>> http://www.facebook.com/universidad.uci<br>> http://www.flickr.com/photos/universidad_uci<br><br>10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...<br>CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION<br><br>http://www.uci.cu<br>http://www.facebook.com/universidad.uci<br>http://www.flickr.com/photos/universidad_uci<br></blockquote><br></div>
<br><html>
<body>
<a href="http://www.uci.cu/">
<img src="http://universidad.uci.cu/email.gif"/>
</body>
</html>
<br></body></html>