<div dir="ltr"><div><div><div><div><div><div><div><div><div><div><div><div>Hi!<br><br></div>Sorry, but it's still not clean for me:<br><br></div>OK, I can count/plan the number of connections according to this document, or a similar one: <a href="http://www.pgpool.net/mediawiki/index.php/Relationship_between_max_pool,_num_init_children,_and_max_connections">http://www.pgpool.net/mediawiki/index.php/Relationship_between_max_pool,_num_init_children,_and_max_connections</a><br>
<br></div>But... it is not clean that the pgpool cluster is counted as one, or the numbers are for a single node.<br><br></div>to be more specific:<br></div>pool-1 and<br></div>pool-2 are the pgpool nodes, with the same settings:<br>
<br></div>num_init_children: 48<br></div>max_pool: 3<br><br></div>and the same backend databases (one master, one RO slave)<br><br></div><div>There are a few apps on pool-1 and pool-2 as well, all connects its "own pool" locally<br>
</div><div><br></div>Now how many connection can exists from the pool nodes alltogether to the backends?<br><br></div>In other words: are the pools in the same "cluster" sharing the connection data?<br><br></div>
<div>Currently we are facing the problem, that after a while, when the app is tested against many connections, pool connections just hangs, and never get a backend connection to run on.<br></div><div><br></div>Regards,<br>
<br>Attila<br><div><div><br><br></div></div></div>