[pgpool-general: 3202] Re: making sense of the output of "show pool_pools"
kent.tong.mo at gmail.com
Thu Sep 25 18:59:00 JST 2014
Thanks for the clear explanation! Is there any way to find the number of
current connections from pgpool clients?
On Thu, Sep 25, 2014 at 5:43 PM, Yaron Naveh <yaronn01 at gmail.com> wrote:
> Hi Kent
> 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.
> If you have one backend then yes, a pool is a single connection that gets
> reused. So you have exactly num_init_children child processes each
> containing up to max_pool pools (=connections), each one to a different
> db/user combination. If you have multiple backends then each pool will
> contain one connection per backend (for the same db/user combination).
> On Thu, Sep 25, 2014 at 12:18 PM, Kent Tong <kent.tong.mo at gmail.com>
>> 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
>> Thanks in advance!
>> Kent Tong
>> IT author and consultant, child education coach
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
> I'm on Twitter (@YaronNaveh <http://twitter.com/#!/YaronNaveh>)
IT author and consultant, child education coach
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general