[pgpool-general: 8796] Re: Relationship between num_init_children and max_pool?

[Tatsuo Ishii]

> PgPool 4.3.6
> 
> https://www.pgpool.net/docs/43/en/html/runtime-config-connection.html
> https://www.pgpool.net/docs/43/en/html/runtime-config-connection-pooling.html
> 
> According to my reading of those docs, when num_init_children=60, and
> max_pool=2, I should see 120 connections to the backend Postgresql
> primary.
> 
> However, I only see 60 connections.  What am I misunderstanding?

Pgpool-II does not create new connections if there's a connection pool
which has same connection property (username and database). I guess
this is your case. You can check the connection pool property by using
SHOW POOL_POOL command.

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp