Sent: Monday, September 04, 2006 9:23 AM
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Postgress memory leak with JBoss3.2.6 and large DB
Indika Maligaspe wrote:
> Hey guys,
>
> We are running a Linux 2.4 enterprise edition box with 6GB of RAM,
> **Postgres 8.0.3*
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 ove
On 31-Aug-06, at 1:54 PM, Tom Lane wrote:
"Indika Maligaspe" <[EMAIL PROTECTED]> writes:
The problem is when we are querying a specific set of table (which
all
tables having over 100K of rows), the Postgres user process takes
over or
close 700MB of memory. This is just to return 3000 odd r
"Indika Maligaspe" <[EMAIL PROTECTED]> writes:
> The problem is when we are querying a specific set of table (which all
> tables having over 100K of rows), the Postgres user process takes over or
> close 700MB of memory. This is just to return 3000 odd rows. Even though we
> have lot of data we st