[Pljava-dev] pljava concurrency

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