[pgpool-general: 6241] Re: High memory Usage
Piotr Wojcieszonek
p.wojcieszonek at bosmanager.com
Fri Sep 21 19:38:40 JST 2018
When I stop client, then memory usage starts decreasing, so it’s good assumption that is not memory leak?
What do you mean by self contained test case?
I probably can increase mamry on VM, but what size should be good?
> 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
>>>
>>
More information about the pgpool-general
mailing list