[pgpool-general: 6189] Re: Query regarding tp open 1000 connection with postgres using pgpool

Tatsuo Ishii ishii at sraoss.co.jp
Fri Aug 10 11:46:28 JST 2018


> Hi ,
> 
> I  am using postgresql 10.3 and pgpool 3.7 to do load balancing and
> achieving the request of opening 1000+ sessions with postgresql.
> I have configured stream replication and load balancing (master + 3 slave)
> using pgpool. Load balancing is working fine.
> My application is connected with pgpool .
> Issue is happening after running my script to open 1000 connections. It is
> running some time and slowly idle process is  increasing constantly in DB
> and because of that postgreDB is crashing . Below is setting details
> In postgresql.conf
> max_connections : 1800
> 
> IN pgpool.con
> 
> num_init_children = 1400
> 
> max_pool = 1
> 
> child_life_time = 60
> child_max_connections = 0
>  connection_life_time = 60
> 
> Please let me know how to achieve my requirement  and why idle connections
> are not getting closed

Not sure what's going on without seeing the logs of Pgpool-II and
PostgreSQL.  Anyway my wild guess is, kernel resource is not
sufficient on your system, especially file descriptors.

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