Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8FE48650EA1 for ; Wed, 25 Jun 2008 10:57:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 84515-02 for ; Wed, 25 Jun 2008 10:56:50 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id CAD50650E9E for ; Wed, 25 Jun 2008 10:56:55 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id m5PDupcx014357; Wed, 25 Jun 2008 09:56:51 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id m5PDuoX5014350; Wed, 25 Jun 2008 09:56:51 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Wed, 25 Jun 2008 09:56:50 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com To: Henrik cc: pgsql-performance@postgresql.org Subject: Re: Hardware suggestions for high performance 8.3 In-Reply-To: <2B6702BC-3513-407E-AAC2-7E04299CA237@mac.se> Message-ID: References: <2B6702BC-3513-407E-AAC2-7E04299CA237@mac.se> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/137 X-Sequence-Number: 30487 On Wed, 25 Jun 2008, Henrik wrote: > 4 x 146 GB SAS disk in RAID 1+0 for database > 6 x 750 GB SATA disks in RAID 1+0 or RAID 5 for OS and transactions logs. The transaction logs are not that big, and there's very little value to striping them across even two disks. You should just get more SAS disks instead and make them available to the database, adding more spindles for random I/O is much more important. Separating out a single RAID-1 pair from that set to hold the logs is a reasonable practice, with a good battery-backed controller even that might not buy you anything useful. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD