[pgpool-general: 3200] Re: making sense of the output of "show pool_pools"
yaronn01 at gmail.com
Thu Sep 25 18:43:43 JST 2014
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> wrote:
> 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>)
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general