[pgpool-general: 3381] Re: Discard All never complete on primary and secondary

Tatsuo Ishii ishii at postgresql.org
Tue Dec 23 08:34:29 JST 2014


Does not reproduce here. Does it always happen?
What is the pgpool versin?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> The Discard All statements never complete leading to no new connections
> possible. What would prevent them from completing. PostgreSQL 9.2.8,
> streaming.
> 
> num_init_children = 80
> max_pool = 4
> child_life_time = 300
> child_max_connections = 0
> connection_life_time = 0
> client_idle_limit = 0
> connection_cache = on
> reset_query_list = 'ABORT; DISCARD ALL'
> white_function_list = 'ping'
> black_function_list = ''
> 
> postgresql.conf
> 
> max_connections = 340
> 
> Thanks in advance,


More information about the pgpool-general mailing list