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

[Lucas Luengas]

I think it's the expected behaviour, because num_init_children is the
maximum concurrent connection number as explained in
http://www.pgpool.net/docs/latest/en/html/runtime-config-connection.html#GUC-NUM-INIT-CHILDREN

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

> 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>