[pgpool-general: 7167] Re: Idle connection in database

[Tatsuo Ishii]

> 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