I have a server with 32GB ram, one intel E3-1245 and four 15k SAS disks with a BB LSI MegaRaid controller. I wan't the optimal performance for my server, which will be pretty write heavy at times, and acceptable with less optimization for redundancy, as my data is not very crucial and I will be running a streaming replication along side.
Now what would be best to go with:
- 3 disks in RAID 0 containing PGDATA + 1 containing SYSTEM and WAL
- All four in RAID 10 containing both PGDATA, SYSTEM AND WAL
- 2 disks in RAID 1 containing PGDATA + 2 disks in RAID 1 containing SYSTEM and WAL
- Something different?