PostgreSQL RAID configuration
- by Yoldar-Zi
I'm stuck how best to configure disk array. We have Hp P2000 G3 disk array with 24 SAS physical disks 300Gb each. We need to configure this array got 2 copies of PostgreSQL 9.2 because two different system. As we know it's recommended to store database and transaction logs(pg_xlog) files on separate disks.
So we must setup 4 logical disk:
2 for transaction logs with RAID 1
2 for database with RAID 10
Is this right scheme of distribution?
Or may be it is best to just make one big RAID 10 with 4 logical disks?