[Pgpool-general] pgpool behavior...

[cristian at clickdiario.com]

Thanks a lot man! it has been very helpful!

Quoting Tatsuo Ishii <t-ishii at sra.co.jp>:

>> 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
>



----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.