Re: BUG #14606: Memory usage continue to increase

Is it possible this issue is caused by the cache or buffer of Postgresql
server? I guess when we run performance testing, will read/update
different records, Postgresql might use some new memory for cache or buffer
some records, and some these cache or buffer will not be cleaned after
performance test is finished. so the new increased memory is for cache or
buffer.
Not sure if my guess is reasonable or not.

Thanks,
Sam

On Thu, Mar 30, 2017 at 9:42 PM, Sam Dai <sam(dot)dai(at)servicemax(dot)com> wrote:

> I run Postgresql server in docker container, I run command "docker stats"
> to measure memory , for example in the below command result, the memory
> usage of docker container is 1.413 GB.
>
> c137012d8af9 793.64% 1.413 GB / 67.55 GB 2.09%
> 5.927 GB / 7.249 GB 0 B / 10.32 GB 0
>
> Thanks,
>
> Sam
>
>
>
> On Thu, Mar 30, 2017 at 9:32 PM, Michael Paquier <
> michael(dot)paquier(at)gmail(dot)com> wrote:
>
>> On Thu, Mar 30, 2017 at 10:24 PM, Sam Dai <sam(dot)dai(at)servicemax(dot)com> wrote:
>>
>> (please do not top-post, this breaks the thread logic)
>>
>> > My application used ComboPooledDataSource to connect to Postgresql
>> server,
>> > the setting is as below, if this issue is syscache bloat, what is the
>> > solution of this issue?
>>
>> Just a question: how are you measuring memory?
>>
>> > <property name="maxConnectionAge" value="300" /> <!-- 5 min -->
>> > <property name="maxIdleTime" value="180" /> <!-- 3 min -->
>>
>> Seeing that, likely this is not syscache.
>> --
>> Michael
>>
>
>