Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 917852E02D9 for ; Tue, 4 Mar 2008 06:42:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 82669-02 for ; Tue, 4 Mar 2008 06:42:20 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id A3B2F2E019D for ; Tue, 4 Mar 2008 06:42:20 -0400 (AST) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1JWUb9-0006SO-Bs for pgsql-performance@postgresql.org; Tue, 04 Mar 2008 10:42:15 +0000 Received: from lara.cc.fer.hr ([161.53.72.113]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 04 Mar 2008 10:42:15 +0000 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 04 Mar 2008 10:42:15 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org From: Ivan Voras Subject: Re: How to allocate 8 disks Date: Tue, 04 Mar 2008 11:45:52 +0100 Lines: 11 Message-ID: References: <1204285894.11773.33.camel@franck-gusty> <1204296705.11773.51.camel@franck-gusty> <47C88826.4040209@paradise.net.nz> <47C99B3E.4010606@emolecules.com> <20080301130347.0832b323@commandprompt.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr User-Agent: Thunderbird 2.0.0.6 (X11/20071022) In-Reply-To: <20080301130347.0832b323@commandprompt.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL=0.001 X-Spam-Level: X-Archive-Number: 200803/45 X-Sequence-Number: 28999 Joshua D. Drake wrote: > This scares me... You lose WAL you are a goner. Combine your OS and > WAL into a RAID 1. Can someone elaborate on this? From the WAL concept and documentation at http://www.postgresql.org/docs/8.3/interactive/wal-intro.html I'd say the only data that should be lost are the transactions currently in the log but not yet transferred to permanent storage (database files proper).