Constantly increasing per connection memory usage on pg 9.2

From: Eliott <eliott100(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Constantly increasing per connection memory usage on pg 9.2
Date: 2013-12-07 09:10:27
Message-ID: 52A2E603.1020607@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear Community,

we've recently moved one of our production databases from a 8.3 based
server to a 9.2 installation. Our usage patterns remained the same,
however, we noticed that the swap space in the server started to
decrease with time.

We have roughly 16 connections to this database in an almost constant
basis, pooled by a java connection pooler on the app side. This
connections never expire (nor did they do with the 8.3 db).
However, as you can see on this memory usage chart
http://i.imgur.com/2sRRj1J.png it shows a rolleccoaster like pattern.
When we restart our application, the connections are closed and the
memory is freed.

Our work_mem is 2MB, so it does not warrant the large memory allocation.
Also I am completely sure that this is the pg connection process that's
eating up the memory.

I've been digging the net for info for days, but this is the first time
I haven't found anything event remotely resembling our scenario. The
exact version number is: psql (EnterpriseDB) 9.2.1.3

Does anybody have any ideas what causes this?

regards
Eliott

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Torsten Förtsch 2013-12-07 12:48:08 Is it possible to avoid the VACUUM FREEZE when upgrading to 9.3.2?
Previous Message John R Pierce 2013-12-06 20:04:06 Re: Fwd: Help!Why CPU Usage and LoadAverage Jump up Suddenly