pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mark Kirkwood <markir@paradise.net.nz>
To: pgsql-performance@postgresql.org
Subject: Re: Postgress memory leak with JBoss3.2.6 and large DB
Date: Mon, 04 Sep 2006 15:53:22 +1200
Message-ID: <44FBA332.8020104@paradise.net.nz> (raw)
In-Reply-To: <20060831095135.4292E9D7@dm17.mta.everyone.net>
References: <20060831095135.4292E9D7@dm17.mta.everyone.net>

Indika Maligaspe wrote:
> Hey guys,
> 
>   We are running a Linux 2.4 enterprise edition box with 6GB of RAM, 
> **Postgres 8.0.3**. (snippage)
> 

You might want to consider upgrading to 8.0.8 (see below), and seeing if
the problem still persists.


> As you can see the postmaster users are taking way over the memory that 
> should be taken.
>   
> 
> If any of you can give us some pointers we would really appreciate that 
> and thanks in advance.
> 

I notice that there are a number of fixes for memory leaks since 8.0.3 -
8.0.4 and 8.0.8 is where I see 'em specifically (reading release notes
for 8.0.8). So you may be experiencing an issue that is fixed in the
current 8.0 releases! I recommend upgrading to 8.0.8.

You didn't say what your HW was, but if you are on a 32-bit platform,
then a 2.4 kernel when you have >2G ram may leak noticeable amounts of
memory itself...

Cheers

Mark




view thread (5+ messages)  latest in thread

Message-ID: <44FBA332.8020104@paradise.net.nz>
Permalink:  ../44FBA332.8020104@paradise.net.nz/
Also on:    postgresql.org/message-id/44FBA332.8020104@paradise.net.nz

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: markir@paradise.net.nz
  Subject: Re: Postgress memory leak with JBoss3.2.6 and large DB
  In-Reply-To: <44FBA332.8020104@paradise.net.nz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox