[pgpool-general: 6242] Re: High memory Usage

[Tatsuo Ishii]

> When I stop client, then memory usage starts decreasing, so it’s good assumption that is not memory leak?

Probably child_life_time affects here. If Pgpool-II child process are
in ilde state because clients gets diconnected, they sucide after 300
seconds (according to your pgpool.conf) passed.

> What do you mean by self contained test case?

A test case which can be executed by someone else (Pgpool-II
developers).

> I probably can increase mamry on VM, but what size should be good?

No idea at this point. If the memory usage is caused by memory leak,
there will be no memory usage limit. If that is not caused by memory
leak, the only way to guess the value is observe the memory usage
until they go into a steady state.

>> Wiadomość napisana przez Tatsuo Ishii <ishii at sraoss.co.jp> w dniu 21.09.2018, o godz. 01:26:
>> 
>> Is it possible for you to provide a self contained test case?
>> 
>> You have 175 pgpool process. So each process allows to use up to
>> 16GB/175 = 93.6MB RAM (of course this number does not include the
>> memory for OS).  With this number, it is hard to tell if it's caused
>> by memory leak or normal, since if applications send large SQL texts
>> or receive large data set returned from PostgreSQL, they could easily
>> eat this amount of memory. So self contained case is essential to know
>> whether this is a memory leak or normal thing.
>> 
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>> 
>>> Hi,
>>> OS - Ubuntu 16.04
>>> pgpool.conf - https://gist.github.com/pwojcieszonek/c0a8f670982f021f5e3f4fba2a7b52ae <https://gist.github.com/pwojcieszonek/c0a8f670982f021f5e3f4fba2a7b52ae>
>>> 
>>> 
>>>> Wiadomość napisana przez Bo Peng <pengbo at sraoss.co.jp> w dniu 20.09.2018, o godz. 08:04:
>>>> 
>>>> Which OS do you use?
>>>> And could you provide pgpool.conf?
>>>> 
>>>> On Wed, 19 Sep 2018 14:09:21 +0200
>>>> Piotr Wojcieszonek <p.wojcieszonek at bosmanager.com> wrote:
>>>> 
>>>>> Hi,
>>>>> I have problem with PG-POOL with high memory usage. 
>>>>> After couple of minutes it consume all of 16GB of ram and start using SWAP.
>>>>> When I restart service it start to slowly alocate all of available memory.
>>>>> I check on 3.7.4 and 3.7.5
>>>>> 
>>>>> _______________________________________________
>>>>> pgpool-general mailing list
>>>>> pgpool-general at pgpool.net
>>>>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>>>> 
>>>> 
>>>> 
>>>> -- 
>>>> Bo Peng <pengbo at sraoss.co.jp>
>>>> SRA OSS, Inc. Japan
>>>> 
>>> 
>