[pgpool-general: 3200] Re: making sense of the output of "show pool_pools"

Yaron Naveh yaronn01 at gmail.com
Thu Sep 25 18:43:43 JST 2014

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> wrote:

> Hi,
> 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.
> Thanks in advance!
> --
> Kent Tong
> IT author and consultant, child education coach
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


I'm on Twitter (@YaronNaveh <http://twitter.com/#!/YaronNaveh>)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140925/b9ae598d/attachment.html>

More information about the pgpool-general mailing list