[pgpool-general: 6223] Re: Significance of NUM_INIT_CHILDREN & MAX_POOL

[Bo Peng]

Hi,

On Tue, 04 Sep 2018 19:04:41 +0530
Nitish Kumar <itcell.mpwz at mp.gov.in> wrote:

> Hi Team,
> 
> I am using PgPool II 3.7.5 in my production environment in Master/Slave streaming mode.
> 
> I have 1 Master DB and 2 Slave DBs. 
> 
> I am not using PgPool II 's connection pooling i.e Connection Pooling in pgpool.conf file is set to OFF.

Do you mean "connection_cache = off"?
 
> In this scenario I want to know the complete detail of how the num_init_children & max_pool parameter will behave ? What is their significance
> when PgPool II 's connection pooling is set to OFF.

The connections to database will not be cached.

> Here is my configuration for DB's
> 
> max_connections = 130
> 
> Configuration in pgpool.conf file
> 
> num_init_children = 25
> max_pool = 2

If connection_cache = off, max conections from pgpool to database will be 25.
 
> Kindly guide me with clear understanding of these parameters. 
> 
> Thanks in advance guys !
> 
> Regards,
> Nitish Kumar


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