Re: BUG #14606: Memory usage continue to increase

On Thu, Mar 30, 2017 at 2:28 PM, <sam(dot)dai(at)servicemax(dot)com> wrote:
> I have a java application that uses postgresSQL 9.6.1, found the memory
> usage continue to increase over time, the details is as below:
> (1) At the beginning, the memory usage is Postgresql is 178.3 MB.
> (2) Run performance testing(concurrent user 1800) on this application, when
> active user is 1800 in performance testing, the memory usage of this
> Postgresql is 1.413 GB. After the performance testing is finished, the
> memory usage of this Postgresql is 344.1 MB.
> (3) Wait for 8 hours and don't do anything on this application during this
> time, the memory usage of this container is 360.2 MB after 8 hours. Even I
> restart this application and wait for 2 hours, the memory usage of this
> Postgresql is 350 MB.
> (4)Run this performance testing for 20 times in 20 days, found memory usage
> of this Postgresql is 3.5 GB. If restart Postgres, the memory usage will
> back to about 178.3 MB.
>
> It looks like the memory usage of Postgres increases every time we run
> performance testing, not sure if it's a bug or not.

Are you keeping connections to the server alive for a long time? This
may be a sign of syscache bloat.
--
Michael