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 1CD5811F6943 for ; Tue, 28 Mar 2006 17:18:11 -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 19410-01-8 for ; Tue, 28 Mar 2006 17:18:06 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 20D2511F6AA1 for ; Tue, 28 Mar 2006 17:18:05 -0400 (AST) Received: from tada.se (1-1-2-48a.rny.sth.bostream.se [82.182.133.12]) by svr4.postgresql.org (Postfix) with ESMTP id EC6B65AF95E for ; Tue, 28 Mar 2006 19:12:40 +0000 (GMT) Received: from [127.0.0.1] (unverified [127.0.0.1]) by tada.se (SurgeMail 3.7a) with ESMTP id 5654 for multiple; Tue, 28 Mar 2006 21:11:47 +0200 Message-ID: <44298A73.9090303@tada.se> Date: Tue, 28 Mar 2006 21:11:47 +0200 From: Thomas Hallgren User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: Dave Cramer Cc: Tom Lane , Simon Riggs , 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> <1143541439.3839.323.camel@localhost.localdomain> <44295AB0.5060203@tada.se> <2966.1143563883@sss.pgh.pa.us> <44296E24.5010602@tada.se> <27F0779D-C696-4A39-9CA9-0228C6BABF56@fastcrypt.com> In-Reply-To: <27F0779D-C696-4A39-9CA9-0228C6BABF56@fastcrypt.com> 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.102 required=5 tests=[AWL=0.102] X-Spam-Score: 0.102 X-Spam-Level: X-Archive-Number: 200603/1201 X-Sequence-Number: 81599 Dave Cramer wrote: > >> >> I'm not too keen on the term FENCED, since it, in the PL/Java case >> will lead to poorer isolation. Multiple threads running in the same >> JVM will be able to share data and a JVM crash will affect all >> connected sessions. > When was the last time you saw a JVM crash ? These are very rare now. I think that's somewhat dependent on what JVM you're using. For the commercial ones, BEA, IBM, and Sun, i fully agree. > In any case if it does fail, it's a JVM bug and can happen to any code > running and take the server down if it is in process. Crash is perhaps not the right word. My point concerned level of isolation. Code that is badly written may have serious impact on other threads in the same JVM. Let's say you cause an OutOfMemoryException or an endless loop. The former will render the JVM completely useless and the latter will cause low scheduling prio. If the same thing happens using an in-process JVM, the problem is isolated to that one session. Regards, Thomas Hallgren