From: jurka at ejurka.com (Kris Jurka)
Date: Thu, 23 Oct 2008 10:22:49 -0700
Subject: [Pljava-dev] pljava concurrency
In-Reply-To: <20081023131245.33DA117ADE12@pgfoundry.org>
References: <20081023131245.33DA117ADE12@pgfoundry.org>
Message-ID: <4900B2E9.4050502@ejurka.com>

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