<div dir="rtl"><div style="" dir="ltr">I meant that max_connection is set to 500. I did the same text with num_init_children=500 but same performance(because my app doesnt use in this architecture more then 200 connections..).</div></div><br><div class="gmail_quote"><div dir="rtl">בתאריך יום א׳, 23 בדצמ׳ 2018 ב-10:29 מאת Pierre Timmermans <<a href="mailto:ptim007@yahoo.com">ptim007@yahoo.com</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"><div><div class="gmail-m_-7070008501694393462ydpac6b49f5yahoo-style-wrap" style="font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:16px"><div><div>What do you mean by "My db has 500 max connections" ? If you have 500 concurrent connections, then you should set num_init_children to 500, because now you can have no more than 200 concurrent users (with pgpool a connection is released from the pgpool only if it the session disconnects from postgres)<br></div><div><br></div><div class="gmail-m_-7070008501694393462ydpac6b49f5signature">Pierre</div></div>
<div><br></div><div><br></div>
</div><div id="gmail-m_-7070008501694393462ydpe7d4facyahoo_quoted_6216935295" class="gmail-m_-7070008501694393462ydpe7d4facyahoo_quoted">
<div style="font-family:"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:13px;color:rgb(38,40,42)">
<div>
On Sunday, December 23, 2018, 9:26:17 AM GMT+1, Mariel Cherkassky <<a href="mailto:mariel.cherkassky@gmail.com" target="_blank">mariel.cherkassky@gmail.com</a>> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="gmail-m_-7070008501694393462ydpe7d4facyiv6678940306"><div dir="rtl"><div dir="ltr">Hi,</div><div dir="ltr">I'm using pgpool and I'm suffering from very poor performance issues when using the pool. I have the next architecture :</div><div dir="ltr">1)Node A, contains the application,standby database and pgpool service.</div><div dir="ltr">2)Node B contains the primary db and pgpool service that will be used only in failover.</div><div dir="ltr"><br></div><div dir="ltr">I did the next 2 tests :</div><div dir="ltr">-In the first test, the application on node A access the DB on node B directly, without connecting to the pool. I run one of our application`s major procedures and it took 40s.</div><div dir="ltr">-In the second test, the application on node A access the pool on node A and it redirects the queries to node B. I run the same procedure and it took 3minutes.</div><div dir="ltr"><br></div><div dir="ltr">My db has 500 max connections and the application has only 1 user and 1 db so I set the num_init_children to be 200 and pool_size to be 1.</div><div dir="ltr"><br></div><div dir="ltr">Any idea how can I tune the pgpool ?</div><div dir="ltr"><br></div><div dir="ltr">Thanks.</div></div></div>_______________________________________________<br>pgpool-general mailing list<br><a href="mailto:pgpool-general@pgpool.net" rel="nofollow" target="_blank">pgpool-general@pgpool.net</a><br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="nofollow" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br></div>
</div>
</div></div></blockquote></div>