[Pljava-dev] pljava concurrency

[Kris Jurka]

Peter Mengaziol wrote:
> In my searches on the web I once came across a document that
> described the Backend locking that pl/java used. I cannot find it
> anymore. Can you point me to it?

I'm not sure specifically what you're referring to.

> I have been running pl/java under MacOSX and I have a question that I
> was trying to research. That above document  said that pljava locked
> the backend and that implied only a single pljava 'task' could run at
> a time. I am trying to port some rather time consuming tasks from
> another DB and it seems that pljava queues them up. Is this correct?
> 


A given pl/java function can be multi-threaded, but only one of those 
threads may execute a query at a time.  To get concurrency you need a 
separate connection and function execution.  That's not a separate 
connection to jdbc:default:connection, but another real connection that 
starts up another backend.

Kris Jurka