agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] Re: preload_libraries and pljava
Date: Sat, 07 May 2005 16:46:18 +0200
Message-ID: <thhal-0QW1YA++HyicTd4/HBTOT0oTggXqNWg@mailblocks.com> (raw)
In-Reply-To: <427CB497.70502@lewczuk.com>
References: <d5i1jd$i0e$1@sea.gmane.org>
	<427C99C2.70703@mailblocks.com>
	<thhal-0RTJYA7+GyicYB4ZVRM4qk3J/CqrBQ2@mailblocks.com>
	<thhal-0RjJYA8GGyicgPwFpmOJbjRBEzPoL8k@mailblocks.com>
	<427CB497.70502@lewczuk.com>
	<427CD4BA.7010305@mailblocks.com>
	<thhal-0P21YA+2Hyic5EEWzLElqAL/BSYRAGf@mailblocks.com>

Marek Lewczuk wrote:

> Thomas Hallgren napisa?(a):
>
>> Marek Lewczuk wrote:
>
>
>> Sure, the pljava can be pre-loaded just like any other module. There 
>> is no particular initialization function though since PL/Java is 
>> initialized when the first call arrives so don't use a ':' in the 
>> preload entry for pljava.
>
> It's working... however I don't see any performance improvments. I have
> this problem with all procedural languages - executing first functions 
> takes about a 1 second. Is there any other solution to make pljava 
> runs faster in first execution ?

No, not really. PL/Java must initialize a Java VM at some point before 
the first call is processed. That will inevitably take some time. A 
connection pool that enables connection reuse is generally the best 
solution. PL/Java is not designed to perform well when connections are 
frequently dropped and re-established.

Regards,
Thomas Hallgren

view thread (4+ messages)

Message-ID: <thhal-0QW1YA++HyicTd4/HBTOT0oTggXqNWg@mailblocks.com>
Permalink:  ../thhal-0QW1YA++HyicTd4%2FHBTOT0oTggXqNWg@mailblocks.com/
Also on:    postgresql.org/message-id/thhal-0QW1YA++HyicTd4/HBTOT0oTggXqNWg@mailblocks.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] Re: preload_libraries and pljava
  In-Reply-To: <thhal-0QW1YA++HyicTd4/HBTOT0oTggXqNWg@mailblocks.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox