Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 2FB8E9FA0EB for ; Thu, 1 Nov 2007 01:37:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 96708-09 for ; Thu, 1 Nov 2007 01:37:09 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from wdscexfe01.sc.wdc.com (wdscexfe01.sc.wdc.com [129.253.170.53]) by postgresql.org (Postfix) with ESMTP id DAC6F9FC32D for ; Thu, 1 Nov 2007 01:07:49 -0300 (ADT) Received: from wdmyexbe03.my.asia.wdc.com ([129.253.105.55]) by wdscexfe01.sc.wdc.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 31 Oct 2007 21:07:32 -0700 Received: from 129.253.107.232 ([129.253.107.232]) by wdmyexbe03.my.asia.wdc.com ([129.253.105.55]) with Microsoft Exchange Server HTTP-DAV ; Thu, 1 Nov 2007 04:07:28 +0000 Received: from neuromancer by 129.253.105.55; 01 Nov 2007 12:07:14 +0800 Subject: Re: Hardware for PostgreSQL From: Ow Mun Heng To: Tomas Vondra Cc: Ketema , pgsql-performance@postgresql.org In-Reply-To: <4728FAA1.7060905@fuzzy.cz> References: <1193849108.591961.103570@22g2000hsm.googlegroups.com> <4728FAA1.7060905@fuzzy.cz> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Thu, 01 Nov 2007 11:53:02 +0800 Message-Id: <1193889182.7999.71.camel@neuromancer.home.net> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 X-OriginalArrivalTime: 01 Nov 2007 04:07:32.0608 (UTC) FILETIME=[BA1C2000:01C81C3C] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.23 tagged_above=0 required=5 tests=AWL=-0.652, BAYES_40=-0.185, RCVD_NUMERIC_HELO=2.067 X-Spam-Level: * X-Archive-Number: 200711/2 X-Sequence-Number: 27417 On Wed, 2007-10-31 at 22:58 +0100, Tomas Vondra wrote: > 2) separate the transaction log from the database > > It's mostly written, and it's the most valuable data you have. And in > case you use PITR, this is the only thing that really needs to be > backed up. My main DB datastore is in a raid1 array and the xlog is still maintained in a single OS drive. Is this considered OK?