[pgpool-general: 5403] pgpool connections in DISCARD status

Madhusudan, Dhanya dhanya.madhusudan at hpe.com
Fri Mar 31 15:26:56 JST 2017


Hi,

We are using EDB 9.5 and pgpool 3.4.3.
We see increasing number of pgpool connections in the DISCARD/ABORT status in spite of the configuring client_idle_limit.
ps -aef | grep pgpool | grep DISCARD | wc -l
290

We are killing these processes manually now, to avoid a situation where there are no free connections available.

Please find attached our pgpool configuration and recommend any changes that would release these connections.

TIA,
Dhanya
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170331/f0125675/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 33728 bytes
Desc: pgpool.conf
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170331/f0125675/attachment-0001.obj>


More information about the pgpool-general mailing list