Re: pljava revisited - Mailing list pgsql-hackers

From Thomas Hallgren
Subject Re: pljava revisited
Date
Msg-id br803u$17dd$1@news.hub.org
Whole thread Raw
In response to pljava revisited  ("Thomas Hallgren" <thhal@mailblocks.com>)
List pgsql-hackers
Two comments.
Context switches are of course much cheaper then loading a JVM. No argument
there. The point is that the JVM is loaded once for each connection (when
the connection makes the first call to a java function). Millions of calls
may follow that reuses the same JVM. Each of those calls will suffer from
context switches if the JVM is remote. A 1 to a million (or more) ratio is
in fact very likey when function calls are used in predicates and/or
projections of selects on larger tables.

Regarding C++, as I said, no big deal. I'll change it for the reasons
mentioned before I release my first cut.

Thanks,

- thomas




pgsql-hackers by date:

Previous
From: Robert Treat
Date:
Subject: Re: ERROR: Index pg_toast_8443892_index is not a btree
Next
From: Tom Lane
Date:
Subject: Canonicalization of WHERE clauses considered harmful