[pgpool-general: 5440] Re: Testing max_pool and and num_init_children

Lucas Luengas lucasluengas at gmail.com
Wed May 3 00:38:48 JST 2017

I think it's the expected behaviour, because num_init_children is the
maximum concurrent connection number as explained in

On Tue, May 2, 2017 at 5:24 PM, Lucas Luengas <lucasluengas at gmail.com>

> Hello.
> I am using pgpool-II version 3.4.6 (tataraboshi). I have a test
> environment with 2 servers, with streaming replication.
> I have configured these values in pgpool.conf:
> num_init_children = 6
> max_pool = 4
> From first server, using ssh, I make some connections to pgpool using psql
> with user "user1" to databaes "db1". When number connections is 6 (value of
> num_init_children), then I can't make new connections with pair
> "user1"/"db1" (I think this behaviour is expected), but I can't make new
> connections using other pairs of user/db, such as user postgres. New
> connections are waiting (psql is not responding) until a previous
> "user1/db1" connection is closed.
> Pgpool.log does not show any error messages.
> Is this normal???
> I think I don't understand max_pool and num_init_childres explanation of
> http://www.pgpool.net/mediawiki/index.php/Relationship_between_max_pool,
> _num_init_children,_and_max_connections
> Thanks in advance.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170502/050c83f2/attachment.html>

More information about the pgpool-general mailing list