[pgpool-general: 3550] Re: pgpool 3.3.4 not responding to new SQL connections

[Jose Baez]

Ok, thanks.  :)



On 18 March 2015 at 09:28, Tatsuo Ishii <ishii at postgresql.org> wrote:

> > OK, thanks.
> >
> > That was it.
> >
> > After reading documentarion I didn't get properly the connection pool
> from
> > pgpool. Now I know "num_init_children" is the number of accepted
> > connections from Psql clients.
> >
> >>From what I understand, Pgpool's pool is not similar to other pools where
> > there are many external connections sharing fewer connections to backend.
> > Instead, Pgpool accepts external connections and then multiply them to
> the
> > backend! I dont get what is the advantage when you've got 'permanent'
> > external connections (unless the cached connections can be shared among
> > every child).
>
> Pgpool expects that connections from client (for example psql) to
> pgpool are short lived. If those psql sessions use same user/database,
> the connections from pgpool to PostgreSQL can be reused. That's the
> idea.
>
> > external connections (unless the cached connections can be shared among
> > every child).
>
> Even if the cached connections are not shared among every child, there
> will be great chance to be reused by clients in the long run.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150318/855fed32/attachment.html>