[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