[pgpool-general: 5460] Re: about child_life_time

[Tatsuo Ishii]

> 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