Multiple disks: RAID 5 or PG Cluster

Поиск
Список
Период
Сортировка
От Yves Vindevogel
Тема Multiple disks: RAID 5 or PG Cluster
Дата
Msg-id 7a1914222f313b7c5e88bedb8a662f12@implements.be
обсуждение исходный текст
Ответы Re: Multiple disks: RAID 5 or PG Cluster  (Vivek Khera <vivek@khera.org>)
Re: Multiple disks: RAID 5 or PG Cluster  (mudfoot@rawbw.com)
Список pgsql-performance
Hi,


We are looking to build a new machine for a big PG database.

We were wondering if a machine with 5 scsi-disks would perform better
if we use a hardware raid 5 controller or if we would go for the
clustering in PG.

If we cluster in PG, do we have redundancy on the data like in a RAID
5 ?


First concern is performance, not redundancy (we can do that a
different way because all data comes from upload files)


Met vriendelijke groeten,

Bien à vous,

Kind regards,


<bold>Yves Vindevogel</bold>

<bold>Implements</bold>

<smaller>

</smaller>Hi,

We are looking to build a new machine for a big PG database.
We were wondering if a machine with 5 scsi-disks would perform better
if we use a hardware raid 5 controller or if we would go for the
clustering in PG.
If we cluster in PG, do we have redundancy on the data like in a RAID 5
?

First concern is performance, not redundancy (we can do that a
different way because all data comes from upload files)

Met vriendelijke groeten,
Bien à vous,
Kind regards,

Yves Vindevogel
Implements

<smaller>


Mail: yves.vindevogel@implements.be  - Mobile: +32 (478) 80 82 91


Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76


Web: http://www.implements.be

<italic><x-tad-smaller>

First they ignore you.  Then they laugh at you.  Then they fight you.
Then you win.

Mahatma Ghandi.</x-tad-smaller></italic></smaller>


Mail: yves.vindevogel@implements.be  - Mobile: +32 (478) 80 82 91

Kempische Steenweg 206 - 3500 Hasselt - Tel-Fax: +32 (11) 43 55 76

Web: http://www.implements.be

First they ignore you.  Then they laugh at you.  Then they fight you.
Then you win.
Mahatma Ghandi.

Вложения

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Needed: Simplified guide to optimal memory
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: Multiple disks: RAID 5 or PG Cluster