[Pljava-dev] Again multithreading

[Thomas Hallgren]

Patrick Peisker wrote:
> (1) PL/Java uses one JVM per connection. Run the PL/Java trigger functions in one "main" JVM or run the functions in the JVM of the actuator (e.g. a JDBC connection unsing the SQL-statement 'insert')?
>
>   
The trigger will be executed in the JVM that becomes embedded in the 
PostgreSQL backend process that represents the connection. PostgreSQL 
spawns a new process for each connection that is opened. The JVM becomes 
part of that process.
> (2) What happens to a thread if it is created in a JVM of an conncetion and the connection is closed?
>
>   
When the connection is closed, the PostgreSQL backend process terminates 
and since the JVM is embedded, it terminates too, in a controlled manner.

> (3) Referring to my first mail about multihreading, is there any chance to ensure that a thread is called again from the backend?
>
>   
No, not unless you do it yourself. If you issue a function call to a 
Java function and let that function sleep for a short period of time, 
other threads that are waiting to use the backend will be released.

Kind Regards,
Thomas Hallgren