<div dir="ltr">Hi Tatsuo,<div><br></div><div>Thank for the information</div><div><br></div><div>> No. client_idle_limit = 5mins means, clients will be disconnected<br>> after 5 minutes idle period, not backend connections.</div><div><span class="gmail-im" style=""><br></span></div><div><span class="gmail-im" style="">Agreed.<br><br></span>> If you want to terminate idle connections from pgpool to backend, you<br>> should use connection_life_time or child_life_time.<br><br>> In your case you already set 600 seconds (that is 10 minutes) to the<br>> parameters, and they would be triggered if no clients connect to<br>> pgpool within 10 minutes. <br></div><div><br></div><div>This is not happening, we can see backend connections from 10-12 hours before as well.</div><div><br></div><div>state | query | backend_start<br>-------+--------------+----------------------------------<br> idle | DISCARD ALL | 27-JUL-20 18:05:35.409933 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:05:35.409931 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:05:35.4094 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:05:35.409005 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:05:35.40897 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:05:35.407784 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:05:35.407632 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:05:35.407399 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:05:35.407044 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:05:35.344228 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:00:35.30343 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:00:35.300526 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:00:35.300472 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:00:35.300048 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:00:35.29958 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:00:35.299185 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:00:35.299048 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:00:35.298708 +05:30<br> idle | DISCARD ALL | 27-JUL-20 18:00:35.296888 +05:30 </div><div><br></div><div>Thanks and Regards,</div><div>Nikhil <br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jul 28, 2020 at 11:09 AM Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">> Hi Team,<br>
> <br>
> We have set below parameters in pgpool.conf for connections:<br>
> <br>
> - serialize_accept = on<br>
> - client_idle_limit = 600<br>
> - child_life_time = 0<br>
> - child_max_connections = 10<br>
> - connection_life_time = 600<br>
> - num_init_children = 4000<br>
> - max_pool = 1<br>
> <br>
> So after executing a query, as per client_idle_limit of 5mins, idle<br>
> sessions should be disconnected after 5mins<br>
<br>
No. client_idle_limit = 5mins means, clients will be disconnected<br>
after 5 minutes idle period, not backend connections.<br>
<br>
> but we can still see a lot of<br>
> idle connections on the database from pgpool.<br>
<br>
If you want to terminate idle connections from pgpool to backend, you<br>
should use connection_life_time or child_life_time.<br>
<br>
In your case you already set 600 seconds (that is 10 minutes) to the<br>
parameters, and they would be triggered if no clients connect to<br>
pgpool within 10 minutes.<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
</blockquote></div>