<div dir="ltr">Hi Yaron,<div><br></div><div>Thanks for the clear explanation! Is there any way to find the number of current connections from pgpool clients?</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Sep 25, 2014 at 5:43 PM, Yaron Naveh <span dir="ltr"><<a href="mailto:yaronn01@gmail.com" target="_blank">yaronn01@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hi Kent<div><br></div><div>The documentation was updated today (as least in source) to reflect that if you have multiple backends then the number of entries will be num_init_children*max_pools*num_backends. You probably have 2 backends which can be reflected with the backend_id field in pool_pools.</div><div><br></div><div>If you have one backend then yes, a pool is a single connection that gets reused. So you have exactly <span style="font-family:arial,sans-serif;font-size:13px">num_init_children child processes each containing up to </span><font face="arial, sans-serif">max_pool pools (=connections), each one to a different db/user combination.</font> If you have multiple backends then each pool will contain one connection per backend (for the same db/user combination).</div><div><br></div><div>Thanks,</div><div>Yaron</div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">On Thu, Sep 25, 2014 at 12:18 PM, Kent Tong <span dir="ltr"><<a href="mailto:kent.tong.mo@gmail.com" target="_blank">kent.tong.mo@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr"><div>Hi,</div><div><br></div><div>How to interpret the output of "show pool_pools"? What is a "pool" anyway? Is it a single connection that gets reused? My num_init_children is 50 and max_pool lines is 4, the doc says that it will list 200 entries but 400 were listed. Why? In particular, I found entries with identical pool_pid+pool_id.</div><div><br></div><div>Thanks in advance!</div><span><font color="#888888"><div><br></div>-- <br><div>Kent Tong</div><div>IT author and consultant, child education coach</div>
</font></span></div>
<br></div></div>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><span class="HOEnZb"><font color="#888888"><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><p style="text-align:left;direction:ltr">I'm on Twitter (<a href="http://twitter.com/#!/YaronNaveh" target="_blank">@YaronNaveh</a>)</p></div>
</font></span></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div>Kent Tong</div><div>IT author and consultant, child education coach</div>
</div>