X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E4C579DC83D for ; Mon, 27 Mar 2006 14:09:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26297-08 for ; Mon, 27 Mar 2006 14:09:52 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from tada.se (1-1-2-48a.rny.sth.bostream.se [82.182.133.12]) by postgresql.org (Postfix) with ESMTP id EFA419DC873 for ; Mon, 27 Mar 2006 14:09:49 -0400 (AST) Received: from [127.0.0.1] (unverified [127.0.0.1]) by tada.se (SurgeMail 3.7a) with ESMTP id 5550 for multiple; Mon, 27 Mar 2006 20:09:44 +0200 Message-ID: <44282A68.7030208@tada.se> Date: Mon, 27 Mar 2006 20:09:44 +0200 From: Thomas Hallgren User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: Tom Lane CC: Martijn van Oosterhout , PostgreSQL-development , PL/Java Development Subject: Re: Shared memory References: <4423CF32.3060406@tada.se> <20060324125851.GC8718@svana.org> <4427A8F1.3020009@tada.se> <14559.1143473507@sss.pgh.pa.us> <4428125D.7000707@tada.se> <15055.1143477148@sss.pgh.pa.us> In-Reply-To: <15055.1143477148@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Server: High Performance Mail Server - http://surgemail.com r=849097733 X-Authenticated-User: thomas@tada.se X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.105 required=5 tests=[AWL=0.105] X-Spam-Score: 0.105 X-Spam-Level: X-Archive-Number: 200603/1155 X-Sequence-Number: 81553 Tom Lane wrote: > Thomas Hallgren 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. > My focus with PL/Java over the last year has been to make it a production-grade product and I think I've succeeded pretty well. The current list of open bugs is second to none. What fundamental problems are you thinking of that hasn't been solved already? Regards, Thomas Hallgren