X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E3BE59DCAAE for ; Fri, 2 Dec 2005 09:02:32 -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 90820-02 for ; Fri, 2 Dec 2005 09:02:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from vms048pub.verizon.net (vms048pub.verizon.net [206.46.252.48]) by postgresql.org (Postfix) with ESMTP id 9D7BB9DCAA6 for ; Fri, 2 Dec 2005 09:02:23 -0400 (AST) Received: from osgiliath.mathom.us ([70.108.54.76]) by vms048.mailsrvcs.net (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPA id <0IQV0035UG7TBON4@vms048.mailsrvcs.net> for pgsql-performance@postgresql.org; Fri, 02 Dec 2005 07:02:25 -0600 (CST) Received: from localhost (localhost [127.0.0.1]) by osgiliath.mathom.us (Postfix) with ESMTP id B4D90600349; Fri, 02 Dec 2005 08:02:16 -0500 (EST) Received: from osgiliath.mathom.us ([127.0.0.1]) by localhost (osgiliath [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 23264-02; Fri, 02 Dec 2005 08:02:16 -0500 (EST) Received: by osgiliath.mathom.us (Postfix, from userid 1000) id 902826001C6; Fri, 02 Dec 2005 08:02:16 -0500 (EST) Date: Fri, 02 Dec 2005 08:02:16 -0500 From: Michael Stone Subject: Re: 15,000 tables In-reply-to: <6.2.5.6.0.20051202030859.0360c1a8@earthlink.net> To: Ron Cc: Tom Lane , pgsql-performance@postgresql.org Mail-followup-to: Ron , Tom Lane , pgsql-performance@postgresql.org Message-id: <20051202130216.GE7330@mathom.us> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-disposition: inline X-Pgp-Fingerprint: 53 FF 38 00 E7 DD 0A 9C 84 52 84 C5 EE DF 7C 88 X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at mathom.us References: <9A858930-1CA6-4238-92D4-D1E945683653@ehpg.net> <1133462407.5734.43.camel@Andrea.peacock.de> <6.2.5.6.0.20051201134344.035fed60@earthlink.net> <15739.1133463453@sss.pgh.pa.us> <6.2.5.6.0.20051202030859.0360c1a8@earthlink.net> User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/61 X-Sequence-Number: 15882 On Fri, Dec 02, 2005 at 03:15:00AM -0500, Ron wrote: >I've seen enough HD failures that I tend to be paranoid and log the >metadata of fs dedicated to WAL as well, but that may very well be overkill. Especially since it wouldn't gain anything. Journalling doesn't give you any advantage whatsoever in the face of a HD failure. Mike Stone