Re: Shared memory - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Shared memory
Date
Msg-id 14559.1143473507@sss.pgh.pa.us
Whole thread Raw
In response to Re: Shared memory  (Thomas Hallgren <thomas@tada.se>)
Responses Re: Shared memory  (Thomas Hallgren <thomas@tada.se>)
List pgsql-hackers
Thomas Hallgren <thomas@tada.se> writes:
> The real downside is that a call from SQL to PL/Java using the current
> in-process approach is really fast. It takes about 5 micro secs on my
> 2.8GHz i386 box. The overhead of an IPC-call on that box is about 18
> micro secs on Linux and 64 micro secs on Windows. That's an overhead
> of between 440% and 1300% due to context switching alone. Yet, for
> some applications, perhaps that overhead is acceptable?

It's only that much difference?  Given all the other advantages of
separating the JVM from the backends, I'd say you should gladly pay
that price.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Recovery from multi trouble
Next
From: Thomas Hallgren
Date:
Subject: Re: Shared memory