agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] PL/Java functions and JDBC
Date: Fri, 24 Feb 2006 21:40:56 +0100
Message-ID: <43FF6F58.9040300@tada.se> (raw)
In-Reply-To: <44D9FC40FD695B4E85F1C59965C27E0FAA4D79@man3>
References: <44D9FC40FD695B4E85F1C59965C27E0FAA4D79@man3>

Tim Clarke wrote:
> Thomas/Patrick
> May I jump in with a question on that point? If each connection uses its
> own JVM then
> 1) Have you any idea what the approximate memory overhead is?
>   
I've measured between 20-40MB virtual memory and 6-13MB real memory per 
session using a standard Sun JVM with no special tuning. It might become 
more of course. It all depends on what you are doing.
> 2) How do we force the JVM to unload when a new JAR is released? I am
> having fun with that at the moment - I am dropping the connection
> entirely which is a bit cumbersome. This is going to give me a problem
> when I go live shortly.
>
>   
There's no way to do that at present. It wouldn't be too hard to write a 
C function that does it though, but I've had problems reloading the JVM 
after that. I'm not sure JNI is designed to handle multiple load/unload 
in a good way, nor am I sure that a JVM unload will free up a 
significant amount of memory.

Are you using a connection pool at present?

Regards,
Thomas Hallgren

view thread (5+ messages)  latest in thread

Message-ID: <43FF6F58.9040300@tada.se>
Permalink:  ../43FF6F58.9040300@tada.se/
Also on:    postgresql.org/message-id/43FF6F58.9040300@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] PL/Java functions and JDBC
  In-Reply-To: <43FF6F58.9040300@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