Thomas Hallgren <thomas@tada.se> writes:
> Tom Lane wrote:
>> 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.
>>
> If I'm right, and the most common scenario is clients using connection pools, then it's very
> likely that you don't get any advantages at all. Paying for nothing with a 440% increase in
> calling time (at best) seems expensive :-)
You are focused too narrowly on a few performance numbers. In my mind
the primary advantage is that it will *work*. I do not actually believe
that you'll ever get the embedded-JVM approach to production-grade
reliability, because of the fundamental problems with threading, error
processing, etc.
regards, tom lane