Monday, September 1, 2008

Re: [PERFORM] Best hardware/cost tradoff?

> -----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.


--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

1 comment:

Rustam Sayal said...

latest technology gadgets The use of the best gadgets 2015 in the field of medicine and education has allowed people to acquire the best of treatment and the best of education with great ease and grace; use of smart classrooms with latest gadgets like projectors allow students to understand the sternest of the concepts with great ease and grace.