From: Fernando Hevia <fhevia@ip-tel.com.ar>
To: 'cluster' <skrald@amossen.dk>
To: pgsql-performance@postgresql.org
Subject: Re: Best hardware/cost tradoff?
Date: Mon, 1 Sep 2008 10:24:46 -0300
Message-ID: <074401c90c36$1a8dd5c0$8f01010a@iptel.com.ar> (raw)
In-Reply-To: <g9b6v7$1ujm$1@news.hub.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>
> -----Mensaje original-----
> De: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.org] En nombre de cluster
> Enviado el: Sábado, 30 de Agosto de 2008 07:21
> Para: pgsql-performance@postgresql.org
> Asunto: Re: [PERFORM] Best hardware/cost tradoff?
>
> We are now leaning towards just buying 4 SAS disks.
>
> So should I just make one large RAID-10 partition or make two
> RAID-1's having the log on one RAID and everything else on
> 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).
>
Make a single RAID 10. It´s 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: fhevia@ip-tel.com.ar, skrald@amossen.dk
Subject: Re: Best hardware/cost tradoff?
In-Reply-To: <074401c90c36$1a8dd5c0$8f01010a@iptel.com.ar>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox