On Sun, May 8, 2011 at 8:03 PM, Tatsuo Ishii <[email protected]> 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
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general

Reply via email to