[pgpool-general: 7947] Re: increase in the number of connections from Pgpool to database

[Travis Kirstine]

Does this answer your question?

https://www.pgpool.net/mediawiki/index.php/Relationship_between_max_pool,_num_init_children,_and_max_connections


On Tue, 21 Dec 2021 at 09:48, Nikolay Mastilo (HM) <nikm71 at hotmail.com>
wrote:

> Hello,
>
> Could you clarify how Pgpool works with connections. Our Java
> application has its own Hikari connection pool to connect to the
> database. By default, the minimum and maximum number of pools in Hikari
> CP is 10.
>
> When connecting to PostgreSQL via Pgpool, the application establishes 10
> connections to the database at once. Further, on subsequent connections
> from application, the established connections are not used, but new ones
> are created. On PostgreSQL, the number of connections with the
> application is growing - 12, 15, 20 and more.
>
> However, when the application works with PostgreSQL directly without
> Pgpool, the number of connections in the database remains 10. I would
> like to know the mechanism for managing connections in Pgpool.
>
> Could you tell me about this or point out me please where I can read
> about it.
>
> Thanks in advance.
>
> --
> Regards,
>     Nikolay
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20211221/8cb7bcc6/attachment.htm>