<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<p>Thank you for the interesting information. But, unfortunately,
not enough to fully understand what is happening. This article
says:<br>
"<span style="color: rgb(34, 34, 34); font-family: sans-serif;
font-size: 14px; font-style: normal; font-variant-ligatures:
normal; font-variant-caps: normal; font-weight: 400;
letter-spacing: normal; orphans: 2; text-align: start;
text-indent: 0px; text-transform: none; white-space: normal;
widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px;
background-color: rgb(255, 255, 255); text-decoration-thickness:
initial; text-decoration-style: initial; text-decoration-color:
initial; display: inline !important; float: none;">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</span>"<br>
</p>
<p>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.<br>
</p>
<p>Could you tell me where to find a description of what mechanism
of work of connections in Pgpool in the following cases:</p>
<p>1. Parameter connection_cache = off.</p>
<p>2. Parameter max_pool = 0</p>
<p>3. In what cases the existing connection with a pair of
user-database is not reused, but a new one is created.<br>
</p>
<p>I would be grateful for clarification, links to articles,
documents, books, etc.<br>
</p>
<p>Thank you in advance.<br>
</p>
<pre class="moz-signature" cols="72">Regards, Nikolay</pre>
<div class="moz-cite-prefix">On 21.12.2021 17:56, Travis Kirstine
wrote:<br>
</div>
<blockquote type="cite" cite="mid:CALtm4h3Srbw8F=4CcgRakyk7bf7YAq-ZB_9oEXqMmCc6ihC0=g@mail.gmail.com">
<div dir="ltr">
<div>Does this answer your question?</div>
<div><br>
</div>
<div><a href="https://www.pgpool.net/mediawiki/index.php/Relationship_between_max_pool,_num_init_children,_and_max_connections" moz-do-not-send="true">https://www.pgpool.net/mediawiki/index.php/Relationship_between_max_pool,_num_init_children,_and_max_connections</a></div>
<div><br>
</div>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Tue, 21 Dec 2021 at 09:48,
Nikolay Mastilo (HM) <<a href="mailto:nikm71@hotmail.com" moz-do-not-send="true">nikm71@hotmail.com</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hello,<br>
<br>
Could you clarify how Pgpool works with connections. Our Java
<br>
application has its own Hikari connection pool to connect to
the <br>
database. By default, the minimum and maximum number of pools
in Hikari <br>
CP is 10.<br>
<br>
When connecting to PostgreSQL via Pgpool, the application
establishes 10 <br>
connections to the database at once. Further, on subsequent
connections <br>
from application, the established connections are not used,
but new ones <br>
are created. On PostgreSQL, the number of connections with the
<br>
application is growing - 12, 15, 20 and more.<br>
<br>
However, when the application works with PostgreSQL directly
without <br>
Pgpool, the number of connections in the database remains 10.
I would <br>
like to know the mechanism for managing connections in Pgpool.<br>
<br>
Could you tell me about this or point out me please where I
can read <br>
about it.<br>
<br>
Thanks in advance.<br>
<br>
-- <br>
Regards,<br>
Nikolay<br>
<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank" moz-do-not-send="true">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank" moz-do-not-send="true">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</blockquote>
</div>
</blockquote>
</body>
</html>