[pgpool-general: 6703] pgpool 3.4 becomes unresponsive under load

Travis Kirstine tkirstine at firstbasesolutions.com
Tue Sep 10 03:12:47 JST 2019

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:

num_init_children = 40
max_pool = 5
child_life_time = 300
child_max_connections = 0
connection_life_time = 0
client_idle_limit = 600

listen_backlog_multiplier = 10

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.

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.

Any advise on how to trouble shoot this issue would be greatly appreciated

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190909/19372116/attachment.html>

More information about the pgpool-general mailing list