[Pgpool-general] pgpool behavior...

[Tatsuo Ishii]

> Hello, I've started recently using PostgreSQL for a new application in my
> enterprise, right now I'm using PostgreSQL 8.0.3 and PgPool 2.6.1 and a web
> application in PHP5 using PEAR::DB
> 
>  
> 
> This is my pgpool configuration settings:
> 
> Port = 5433
> 
> Num_init_childern = 64
> 
> Max_pool = 6
> 
> Child_life_time = 300
> 
> Connection_life_time = 0
> 
>  
> 
> When I check my database connection I see 33 postmaster idle connection, do
> I need to tune connection_life_time to avoid idle connections in the
> database server? Any help configuration this settings?

child_life_time = 300 means any idle connection to the PostgreSQL
server will survive no longer than 5 minutes. If you are not fine with
5 minutes, you could either 1) shorten child_life_time or 2) set
connection_life_time less than 300.

I recommend leave child_life_time as it is, and set
connection_life_time to, say 30. This will kill any idle connection
lasting more than 30 seconds.

Hope this helps,
--
SRA OSS, Inc. Japan
Tatsuo Ishii