Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id CEFCA64FD63
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon,  1 Sep 2008 10:23:32 -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 29264-10 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon,  1 Sep 2008 10:23:24 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from pyxis.powervt.com.ar (host6.powervt.com.ar [200.43.63.66])
	by postgresql.org (Postfix) with ESMTP id 4A03664FCDF
	for <pgsql-performance@postgresql.org>;
	Mon,  1 Sep 2008 10:23:28 -0300 (ADT)
Received: from pcfhevia ([201.216.249.98])
	by pyxis.powervt.com.ar (IPGroup Mail Server) with ESMTP id 1OT48953;
	Mon, 01 Sep 2008 10:23:19 -0300
From: "Fernando Hevia" <fhevia@ip-tel.com.ar>
To: "'cluster'" <skrald@amossen.dk>,
	<pgsql-performance@postgresql.org>
References: <g96ttt$2l3m$1@news.hub.org>	
	<064701c90949$51d117d0$8f01010a@iptel.com.ar>	
	<48B709A5.3090906@emolecules.com> <g975b3$5gv$1@news.hub.org>
	<dcc563d10808281503w1c58ce4ex211e838cc239087c@mail.gmail.com>
	<g9b6v7$1ujm$1@news.hub.org>
Subject: Re: Best hardware/cost tradoff?
Date: Mon, 1 Sep 2008 10:24:46 -0300
Organization: IP-TEL
Message-ID: <074401c90c36$1a8dd5c0$8f01010a@iptel.com.ar>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Mailer: Microsoft Office Outlook 11
In-Reply-To: <g9b6v7$1ujm$1@news.hub.org>
Thread-Index: AckKi3U23jAw4Ua6TCaF3hko03XU6QBphyrg
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200809/7
X-Sequence-Number: 31320

=20

> -----Mensaje original-----
> De: pgsql-performance-owner@postgresql.org=20
> [mailto:pgsql-performance-owner@postgresql.org] En nombre de cluster
> Enviado el: S=E1bado, 30 de Agosto de 2008 07:21
> Para: pgsql-performance@postgresql.org
> Asunto: Re: [PERFORM] Best hardware/cost tradoff?
>=20
> We are now leaning towards just buying 4 SAS disks.
>=20
> So should I just make one large RAID-10 partition or make two=20
> RAID-1's having the log on one RAID and everything else on=20
> the second RAID?
> How can I get the best read/write performance out of these four disks?
> (Remember, that it is a combined web-/database server).
>=20

Make a single RAID 10. It=B4s simpler and it will provide you better =
write
performance which is where your bottleneck will be. I think you should
minimize the web server role in this equation as it should mostly work =
on
cached data.