[Pljava-dev] doubtful PL/Java's activity

Hello

On Mon, 9 Dec 2013 11:16:01 +0000
"Taniguchi, Yasunori" <taniguchi.yasu at jp.fujitsu.com> wrote:

> Hi,
>
> I'm investigating PL/Java and find out a doubtful fact.
>
> Postgres is compiled as a single thread application
> and linked with JavaVM(.so/.dll) which is a multi thread library.
> Sp, I think PL/Java's activity may not be assured.
>
> Thread-unsafe functions and global variables used in single thread
> standard libraries may be inconsistent with multi thread libraries.

If I understood it correctly, every PostgreSQL connection has its own
process and for every such process one separate JVM is started.
This model ensures that different connections never end up in the
same JVM. Inside one connection queries are always executed one after
another. Therefore the JVM can internally do what ever it likes, even
multithreaded.

Best Regards

-christian-