> -----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. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
