Re: Best hardware/cost tradoff?

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.

In response to

Browse pgsql-performance by date

  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?