Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 421779FA568 for ; Thu, 1 Nov 2007 04:46:40 -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 49367-09 for ; Thu, 1 Nov 2007 04:46:32 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from wdscexfe02.sc.wdc.com (wdscexfe02.sc.wdc.com [129.253.170.52]) by postgresql.org (Postfix) with ESMTP id 45F4C9FA56A for ; Thu, 1 Nov 2007 04:46:36 -0300 (ADT) Received: from wdmyexbe03.my.asia.wdc.com ([129.253.105.55]) by wdscexfe02.sc.wdc.com with Microsoft SMTPSVC(6.0.3790.1830); Thu, 1 Nov 2007 00:46:19 -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 07:46:15 +0000 Received: from neuromancer by 129.253.105.55; 01 Nov 2007 15:46:01 +0800 Subject: Re: Hardware for PostgreSQL From: Ow Mun Heng To: Magnus Hagander Cc: Tomas Vondra , Ketema , pgsql-performance@postgresql.org In-Reply-To: <4729783A.2030201@hagander.net> References: <1193849108.591961.103570@22g2000hsm.googlegroups.com> <4728FAA1.7060905@fuzzy.cz> <1193889182.7999.71.camel@neuromancer.home.net> <4729783A.2030201@hagander.net> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Thu, 01 Nov 2007 15:46:01 +0800 Message-Id: <1193903161.9148.27.camel@neuromancer.home.net> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 X-OriginalArrivalTime: 01 Nov 2007 07:46:19.0097 (UTC) FILETIME=[4A1B6490:01C81C5B] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.025 tagged_above=0 required=5 tests=AWL=0.557, BAYES_00=-2.599, RCVD_NUMERIC_HELO=2.067 X-Spam-Level: X-Archive-Number: 200711/6 X-Sequence-Number: 27421 On Thu, 2007-11-01 at 07:54 +0100, Magnus Hagander wrote: > Ow Mun Heng wrote: > > 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? > > Is your OS not RAIDed? I'd keep everything RAIDed one way or another - > otherwise you are certain to get downtime if the disk fails. Nope it's not raided. It's a very low end "server" running on IDE, max 4 drives. 1x80G system and 3x500G Raid1+1 hot spare > > Also, if you don't have a *dedicated* disk for the xlog (putting it on > the OS disk doesn't make it dedicated), you miss out on most of the > performance advantage of doing it. The advantage is in that the writes > will be sequential so the disks don't have to seek, but if you have > other access on the same disk, that's not true anymore. As of right now, budget constraints is making me make do with that I've got/(and it's not a whole lot) > > You're likely better off (performance-wise) putting it on the same disk > as the database itself if that one has better RAID, for example. I'm thinking along the lines of since nothing much writes to the OS Disk, I should(keyword) be safe. Thanks for the food for thought. Now.. time to find some dough to throw around. :-)