Skip site navigation (1) Skip section navigation (2)

Re: Postgres consuming way too much memory???

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "jody brownell" <jody(dot)brownell(at)q1labs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres consuming way too much memory???
Date: 2006-06-15 15:34:39
Message-ID: 28321.1150385679@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"jody brownell" <jody(dot)brownell(at)q1labs(dot)com> writes:
> When postgresql starts to go into this bloating state, I can only make it happen from my java app.

That's interesting.  The JDBC driver uses protocol features that aren't
used by psql, so it's possible that the leak is triggered by one of
those features.  I wouldn't worry too much about duplicating the problem
from psql anyway --- a Java test case will do fine.

> I am going to try closing the connection after each TX to see if this
> resolves it for now. If not, I will write a java app, stored procedure
> (table etc) reproduce it without our application.

Even if that works around it for you, please pursue getting a test case
together so we can find and fix the underlying problem.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2006-06-15 15:44:08
Subject: Re: Postgres consuming way too much memory???
Previous:From: jody brownellDate: 2006-06-15 15:02:50
Subject: Re: Postgres consuming way too much memory???

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group