Обсуждение: Performance RAID 0

Hi,
I have a pretty small database on my home computer (~25Gb). I have three 250Gb HDDs.

My setup was 1 HDD for OS (Windows XP) and the other 2  HDD in RAID 0 for postgre database.
Will I see any performance improvement if I instead have 1 HDD for OS, 1 HDD for pg_xlog and 1HDD for the database?

or do you suggest another setup?
(I'm not really concerned about  the redundancy for the database, that's why I used RAID 0 up till now, but would save some time if the performance difference is small compared to 3 independent disks)

/Magnus

> -----Mensaje original-----
> De: mange
>
> Hi,
> I have a pretty small database on my home computer (~25Gb). I
> have three 250Gb HDDs.
>
> My setup was 1 HDD for OS (Windows XP) and the other 2  HDD
> in RAID 0 for postgre database.
> Will I see any performance improvement if I instead have 1
> HDD for OS, 1 HDD for pg_xlog and 1HDD for the database?
>
> or do you suggest another setup?
> (I'm not really concerned about  the redundancy for the
> database, that's why I used RAID 0 up till now, but would
> save some time if the performance difference is small
> compared to 3 independent disks)
>
> /Magnus
>

No. In your scenario, if you proceed in having individual disks attending
data and pg_xlog, I bet performance will be degraded.
For maximum performance you should construct your RAID 0 array with all
three disks for OS and Postgres.
Of course thats quite risky. You are tripling your chances the whole box
will evaporate in case of a disk failure.


Cheers.