[pgpool-general: 7953] Re: increase in the number of connections from Pgpool to database
Nikolay Mastilo (HM)
nikm71 at hotmail.com
Thu Dec 23 07:41:43 JST 2021
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>
More information about the pgpool-general
mailing list