[pgpool-general: 7167] Re: Idle connection in database
Tatsuo Ishii
ishii at sraoss.co.jp
Tue Jul 28 14:38:57 JST 2020
> Hi Team,
>
> We have set below parameters in pgpool.conf for connections:
>
> - serialize_accept = on
> - client_idle_limit = 600
> - child_life_time = 0
> - child_max_connections = 10
> - connection_life_time = 600
> - num_init_children = 4000
> - max_pool = 1
>
> So after executing a query, as per client_idle_limit of 5mins, idle
> sessions should be disconnected after 5mins
No. client_idle_limit = 5mins means, clients will be disconnected
after 5 minutes idle period, not backend connections.
> but we can still see a lot of
> idle connections on the database from pgpool.
If you want to terminate idle connections from pgpool to backend, you
should use connection_life_time or child_life_time.
In your case you already set 600 seconds (that is 10 minutes) to the
parameters, and they would be triggered if no clients connect to
pgpool within 10 minutes.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
More information about the pgpool-general
mailing list