Re: Best hardware/cost tradoff?

Поиск
Список
Период
Сортировка
От Fernando Hevia
Тема Re: Best hardware/cost tradoff?
Дата
Msg-id 074401c90c36$1a8dd5c0$8f01010a@iptel.com.ar
обсуждение исходный текст
Ответ на Re: Best hardware/cost tradoff?  (cluster <skrald@amossen.dk>)
Список pgsql-performance

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


В списке pgsql-performance по дате отправления:

Предыдущее
От: "Pavel Stehule"
Дата:
Сообщение: Re: limit clause breaks query planner?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: too many clog files