X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id CE4D0D1C4D0 for ; Tue, 12 Aug 2003 16:47:33 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 83987-02 for ; Tue, 12 Aug 2003 13:46:00 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id EF6C8D1C4BA for ; Tue, 12 Aug 2003 13:47:22 -0300 (ADT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 19mcIp-0005Da-00 for ; Tue, 12 Aug 2003 12:47:19 -0400 Received: by dba2 (Postfix, from userid 1019) id E43B6D0AE; Tue, 12 Aug 2003 12:47:18 -0400 (EDT) Date: Tue, 12 Aug 2003 12:47:18 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: On Linux Filesystems Message-ID: <20030812164718.GC12976@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <20030810200440.B2396@cookie> <20030812142856.GB12701@libertyrms.info> <200308120936.21099.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200308120936.21099.josh@agliodbs.com> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/208 X-Sequence-Number: 3025 On Tue, Aug 12, 2003 at 09:36:21AM -0700, Josh Berkus wrote: > So it's a tradeoff with loss of performance vs. recovery time. In > a server room with redundant backup power supplies, "clean room" > security and fail-over services, I can certainly imagine that data > journalling would not be needed. You can have all the redundant power, high availability hardware, and ultra-Robocop security going, and still have crashes: so far as I know, _nobody_ makes perfectly reliable hardware, and the harder you push it, the more likely you are to find trouble. And certainly, when you have a surprise outage because the CPU where the kernel happened to be burned itself up, an extra hour or two offline while you do fsck is liable to make you cry out variations of those four letters more than once. :-/ A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110