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

[Tatsuo Ishii]

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