Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4EE9E9FA32A for ; Tue, 14 Aug 2007 18:31:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 85844-03-2 for ; Tue, 14 Aug 2007 18:31:55 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 3E8519FA326 for ; Tue, 14 Aug 2007 18:31:55 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 3AC9F56527; Tue, 14 Aug 2007 16:31:54 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Tue, 14 Aug 2007 16:31:50 -0500 Date: Tue, 14 Aug 2007 16:31:50 -0500 From: Decibel! To: Michael Ben-Nes Cc: PostgreSQL Performance Subject: Re: RAID 10 or RAID 10 + RAID 1 Message-ID: <20070814213150.GT54135@nasby.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="AGZzQgpsuUlWC1xT" Content-Disposition: inline In-Reply-To: X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:070814:miki@epoch.co.il::5DD30qVeN/OmP5hY:038N4 X-Hashcash: 1:20:070814:pgsql-performance@postgresql.org::iaalhUlkeAbvtzUL:00000 000000000000000000000000L10c X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/151 X-Sequence-Number: 26281 --AGZzQgpsuUlWC1xT Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Aug 14, 2007 at 01:14:39PM +0300, Michael Ben-Nes wrote: > Hello, >=20 > I need to setup a web server with PostgreSQL. The heaviest application wi= ll > be product comparisons engine that will analyze 5-10 Million products. >=20 > I have 6 SAS 15K disks, how should I set them up: >=20 > RAID 10 on all 6 disks ( OS + Apache + PostgreSQL ) > RAID 1 on 2 disks ( OS + Apache ) + RAID 10 on 4 disks ( PostgreSQL ) =20 If the controller is any good and has a battery-backed write cache, you'll probably do better with a 6 disk RAID10. If not, I'd put all the data on a 4 disk RAID10, and everything else (including pg_xlog!) on a mirror. > What is the recommended stripe size ( The computer is Dell PowerEdge 2950= ) If you search through the archives I think you'll find some stuff about stripe size and performance. As always, your best bet is to benchmark both approaches with your actual application. --=20 Decibel!, aka Jim Nasby decibel@decibel.org EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) --AGZzQgpsuUlWC1xT Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iD8DBQFGwh9GdO30qud8SkgRArifAJ9NXTTvY8JiV30sE5FB5IvzA8557QCgmG7/ HirSW2zxzIXeBShQ/PrcmqA= =KJHr -----END PGP SIGNATURE----- --AGZzQgpsuUlWC1xT--