Re: pljava revisited

From: "Thomas Hallgren" <thhal(at)mailblocks(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pljava revisited
Date: 2003-12-10 20:39:01
Message-ID: br803u$17dd$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2003-12-10 21:39:13 Re: Strange permission problem regarding pg_settings
Previous Message Robert Treat 2003-12-10 20:15:36 Re: ERROR: Index pg_toast_8443892_index is not a btree