[pgpool-general: 5463] Re: about child_life_time

[Lin Yuan]

Great. Thanks for the explanation!

2017-05-12 18:13 GMT+08:00 Tatsuo Ishii <ishii at sraoss.co.jp>:

> > Hello experts
> >
> > I am not quite clear about the meaning of this parameter. From document,
> it
> > says
> >
> > Specifies the time in seconds to terminate a Pgpool-II child process if
> it
> > remains idle. The new child process is immediately spawned by Pgpool-II
> > when it is terminated because of child_life_time.
> >
> > What does "idle" here exactly mean? For example, I set child_life_time to
> > 120, and uses "psql" client to connect to pgpool, and does nothing. From
> > "ps -ef" output on pgpool, I can always see the process is "idle":
> pgpool:
> > postgres postgres x.x.x.x(zzzz) idle. But this child process never exits.
> >
> > So it looks pgpool has different definition of "idle" from ps output?
>
> yeah. In the context of child_life_time, "idle" means "no client is
> connecting". So testing with psql will never trigger child_life_time
> expiration.
>
> 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/20170515/487543c8/attachment.html>