[Pgpool-general] num_init_children and max_pool

[E.D.]

On Sun, May 8, 2011 at 8:03 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> > How does child_life_time interact with connection_life_time?
> > Let's say after 300 seconds the connection closes, and after 600 seconds
> the
> > child exits... does the newly spawned child re-open the connection
> > automatically or not?
>
> You mean connection to backend? Yes, anytime child re-open the
> connection automatically if neccessary (and possible). It's a
> transparent processing for clients.
>
>
In that case, and still with the objective of minimizing the memory
footprint,  does this seem like a good compromise:

child_life_time = 1800
connection_life_time = 300

If the server is idle, the child will exit / respawn after 30 min, but after
5 min it will drop the connection to the backend, meaning that an idle child
would only be connected to the backend 1/6th of the time. Is that correct?
Do you see any potential issues with such a setup?

Regards,
ED
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110509/50da5864/attachment.html>