<div dir="rtl"><div style="" dir="ltr">A child cant have 3 connections to the same database with the same user right ? In other words, If I have only one database and one user I should set max_pool to 1 ?</div></div><br><div class="gmail_quote"><div dir="rtl">בתאריך יום ו׳, 14 בדצמ׳ 2018 ב-1:29 מאת Bo Peng <<a href="mailto:pengbo@sraoss.co.jp">pengbo@sraoss.co.jp</a>>:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
On Sun, 9 Dec 2018 15:00:33 +0200<br>
Mariel Cherkassky <<a href="mailto:mariel.cherkassky@gmail.com" target="_blank">mariel.cherkassky@gmail.com</a>> wrote:<br>
<br>
> Hi,<br>
> I'm trying to implement pgpool2 in our environment but in our performance<br>
> tests it seems that when we use pgpool the performance are worse.<br>
> Therefore, I wanted to check if pgpool is the right solution based on the<br>
> next info that I read :<br>
> " process opens a new backend connection only if the requested<br>
> [user,database] pair is not already in the cache. So if the application<br>
> uses only one user to connect to only one database, say [pguser1,pgdb1],<br>
> then each child will continue to reuse the first connection and will never<br>
> open a second connection, so in effect pgpool will open no more than 100<br>
> backend connections even though max_pool is set to 3."<br>
> <br>
> In my case, I have 3 databases and for every database I have a dedicated<br>
> user. The application access each of those databases with a dedicated user.<br>
> Now basicaly, if my max_connections is set to 500, pgpool max_pool set to 3<br>
> and the num_of_init_children is set to 100 it means that at every moment I<br>
> can have at most 100 sessions to each one of the databases (with pgpool..).<br>
<br>
If you set <br>
max_pool = 3<br>
num_init_children = 100<br>
<br>
you can have most 300 sessions to backend servers.<br>
<br>
<br>
> Thanks , Mariel.<br>
<br>
<br>
-- <br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
SRA OSS, Inc. Japan<br>
<br>
</blockquote></div>