[pgpool-general: 6563] Re: regarding connection pooling max

[Bo Peng]

Hi,

On Fri, 10 May 2019 15:55:58 +0200
Natus <natus at riseup.net> wrote:

> Hi all 
>  
> I have some bad software which create hundred of connection with the same 
> user. 
>  
> I tested pgpool to limit those connections and pool them together. 
>   
> If the software ask for 100 connection, I would like pgpool to deliver
> 100 connections but actually create 20 connections. 

How did you set "max_pool" and "num_init_children"?

Pgpool can reach "num_init_children" * "max_pool" connections in total.

> Is that possible ? 
>  
> Right now, my first tests show pgpool does not opent 100 connection but
> is limited by num_init_children 
>   
> Is pgpool able to help me for this use case ? 
>    
> thanks 
> 
> -- 
>                         regards, natus
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
> 


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan