agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] out of memory
Date: Tue, 11 Apr 2006 17:33:06 +0200
Message-ID: <443BCC32.2090306@tada.se> (raw)
In-Reply-To: <443BC400.4030806@lewczuk.com>
References: <e1fn29$od1$1@sea.gmane.org>
	<443B63F0.4050803@tada.se>
	<443BC400.4030806@lewczuk.com>

Marek Lewczuk wrote:
> If it isn't high, so why pljava hangs - it doesn't throw any error, 
> postgresql process is working but pljava function do nothing (I need 
> to kill process manually in order unlock postgresql resources). I will 
> try to execute it again and see how much memory it consumes.
>
I don't know why it hangs. An out-of-memory would typically cause a 
termination, not a hanging. Which JVM are you using and on which 
platform? What is the behavior of your hung process? Is it consuming 
lots of CPU cycles or none at all?

> Latest, stable release - 1.2. My pljava function doesn't return a set, 
> so I don't think that this will fix my problem.
>
Well, if you have a chance, please try out the new stuff. The fix 
regarding set returning functions is not the only change since 1.2 and 
I'd hate to spend time on something that's not an issue in the new code.

> I close every statement and this should close automatically all 
> ResultSet related to the statement.
OK, to rephrase my question - Do you rely on that ResultSets are closed 
by the Statement close or do you close them too explicitly?

Regards,
Thomas Hallgren

view thread (12+ messages)  latest in thread

Message-ID: <443BCC32.2090306@tada.se>
Permalink:  ../443BCC32.2090306@tada.se/
Also on:    postgresql.org/message-id/443BCC32.2090306@tada.se

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: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] out of memory
  In-Reply-To: <443BCC32.2090306@tada.se>

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

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