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