From: | "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar> |
---|---|
To: | "'cluster'" <skrald(at)amossen(dot)dk>, <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Best hardware/cost tradoff? |
Date: | 2008-09-01 13:24:46 |
Message-ID: | 074401c90c36$1a8dd5c0$8f01010a@iptel.com.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
> -----Mensaje original-----
> De: pgsql-performance-owner(at)postgresql(dot)org
> [mailto:pgsql-performance-owner(at)postgresql(dot)org] En nombre de cluster
> Enviado el: Sábado, 30 de Agosto de 2008 07:21
> Para: pgsql-performance(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2008-09-01 14:33:59 | Re: too many clog files |
Previous Message | Pavel Stehule | 2008-09-01 12:52:53 | Re: limit clause breaks query planner? |