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

[Nikolay Mastilo (HM)]

Thank you for the interesting information. But, unfortunately, not 
enough to fully understand what is happening. This article says:
"So if the application uses only one user to connect to only one 
database, say [pguser1,pgdb1], then each child will continue to reuse 
the first connection and will never open a second connection"

But, all services for us work each with its own base and under one user, 
i.e. with one pair of "user-database". However, the number of 
connections grows if they are not forcibly killed.

Could you tell me where to find a description of what mechanism of work 
of connections in Pgpool in the following cases:

1. Parameter connection_cache = off.

2. Parameter max_pool = 0

3. In what cases the existing connection with a pair of user-database is 
not reused, but a new one is created.

I would be grateful for clarification, links to articles, documents, 
books, etc.

Thank you in advance.

Regards, Nikolay

On 21.12.2021 17:56, Travis Kirstine wrote:
> 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 
> <mailto: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 <mailto: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/20211223/b94b4ffe/attachment.htm>