[pgpool-general: 5460] Re: about child_life_time

Tatsuo Ishii ishii at sraoss.co.jp
Fri May 12 19:13:13 JST 2017

> 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

Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list