[pgpool-general: 8796] Re: Relationship between num_init_children and max_pool?
Tatsuo Ishii
ishii at sraoss.co.jp
Fri Jun 2 09:32:35 JST 2023
> 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
More information about the pgpool-general
mailing list