pg.ddx.io  pljava-dev@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Subject: [Pljava-dev] Is it safe to use multi-threaded PL/Java in single-threaded postgres process?
Date: Mon, 14 Apr 2014 20:54:51 +0900
Message-ID: <D40AEDF3497A484BBCC1DEB79CD5CB3E@maumau> (raw)
In-Reply-To: <534BAE6D.9050201@tada.se>
References: <30A6B4B499494CED93770BBC4835840C@maumau>
	<A832684586A84610AD7173AB42138F38@maumau>
	<5F50DAFCABA4426FA54E9D8D0B78B38B@maumau>
	<534AA39A.4010906@tada.se>
	<1F2A8D3FBCC3447391A3520631ACBD25@maumau>
	<534BAE6D.9050201@tada.se>

From: "Thomas Hallgren" <thomas at tada.se>
> 3. For a test like yours, the time it takes to execute the actual 
> statement is important. The execution may be so slow that the overhead 
> imposed by the network call becomes negligible. A test using a lightweight 
> "SELECT 1" instead of the heavier "UPDATE testtable" would reveal such 
> issues.

Yeah, I thought this is the most likely.  We are trying to speed up batch 
jobs dramatically, and I hoped PL/Java's in-process architecture would 
contribute to that.

But I wonder why in-process execution didn't make a big difference.  I 
expected several times of difference because I saw the PollPosition 
benchmark results at http://hsqldb.org/.  It compares HSQLDB's in-process 
and client-server execution models.  I assume the client and the server ran 
on the same host.

Anyway, in-process and out-of-process execution doesn't seem to make a big 
difference for batch jobs which issue many SQL statements.

Regards
MauMau





view thread (13+ messages)  latest in thread

Message-ID: <D40AEDF3497A484BBCC1DEB79CD5CB3E@maumau>
Permalink:  ../D40AEDF3497A484BBCC1DEB79CD5CB3E@maumau/
Also on:    postgresql.org/message-id/D40AEDF3497A484BBCC1DEB79CD5CB3E@maumau

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] Is it safe to use multi-threaded PL/Java in single-threaded postgres process?
  In-Reply-To: <D40AEDF3497A484BBCC1DEB79CD5CB3E@maumau>
  References: <30A6B4B499494CED93770BBC4835840C@maumau> <A832684586A84610AD7173AB42138F38@maumau> <5F50DAFCABA4426FA54E9D8D0B78B38B@maumau> <534AA39A.4010906@tada.se> <1F2A8D3FBCC3447391A3520631ACBD25@maumau> <534BAE6D.9050201@tada.se> <D40AEDF3497A484BBCC1DEB79CD5CB3E@maumau>

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

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