<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none"><!--P{margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr" style="font-size:10pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>I have pgpool 3.4 running in front of a pg 9.4 two node cluster running in streaming replication mode with connection pooling. Under moderate load pgpool will become unresponsive and will need to be restarted. The system is being used with a PHP / Python
based web applications that can generate a number of concurrent selects / inserts (20 -100 queries per second). The database seems to be able to handle the load however pgpool will fail under stress. The database had 9 unique database / user combinations
and I have pgpool configured with:</p>
<p> </p>
<p>num_init_children = 40<br>
max_pool = 5<br>
child_life_time = 300<br>
child_max_connections = 0<br>
connection_life_time = 0<br>
client_idle_limit = 600</p>
<p><br>
</p>
<p>listen_backlog_multiplier = 10</p>
<p><br>
</p>
<p>Postgresql is configured with 250 max connections. I could increase the num_init_children and max_pool however I'm to sure if this would resolve the issue. The server supports up to 100,000 open files and appears to have around 15,000 open files when operational.<br>
</p>
<p><br>
</p>
<p>The issue I'm having is that it is not clear what could be causing the issue as there is no indication in the logs what is failing.<br>
</p>
<p><br>
</p>
<p>Any advise on how to trouble shoot this issue would be greatly appreciated <br>
</p>
<p><br>
<br>
</p>
<p><br>
</p>
<div id="Signature">
<div name="divtagdefaultwrapper" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:; margin:0">
</div>
</div>
</body>
</html>