Re: [PERFORM] Postgress memory leak with JBoss3.2.6 and large DB

2006-09-04 Thread Indika Maligaspe
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*

Re: [PERFORM] Postgress memory leak with JBoss3.2.6 and large DB

2006-09-03 Thread Mark Kirkwood
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

Re: [PERFORM] Postgress memory leak with JBoss3.2.6 and large DB

2006-08-31 Thread Dave Cramer
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

Re: [PERFORM] Postgress memory leak with JBoss3.2.6 and large DB

2006-08-31 Thread Tom Lane
"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