[Pgpool-general] DB Connections / Child Process

[Tatsuo Ishii]

> It seems as though I am only achieving 1 db connection per 
> child although I have the max_pool setting = 4.

Because you always use the same user/database combo to connect to
pgpool.

> I have two clients try to access a single pgpool child. 
> The second client waits for a db connection until the 
> first client completes. It then receives the connection 
> and proceeds.
> 
> Can you please explain why I am experiencing this 
> behaviour.

It's indented. Pgpool designed to limit number of connections to
PostgreSQL to reduce the resource usage. If you have enough resource,
you can increase num_init_children not to be blocked by pgpool.
--
Tatsuo Ishii
SRA OSS, Inc. Japan