Setup of four 15k SAS disk with LSI raid controller

From: Niels Kristian Schjødt <nielskristian(at)autouncle(dot)com>
To: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Setup of four 15k SAS disk with LSI raid controller
Date: 2013-03-13 17:43:16
Message-ID: AF0D49A8-1E14-4170-B122-B318C52360C5@autouncle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 less optimized for redundancy, as my data is not very crucial and I will be running a streaming replication along side.

Now what would you prefer:

1) 3 disks in RAID 0 containing PGDATA + 1 containing SYSTEM and WAL
2) All four in RAID 10 containing both PGDATA, SYSTEM AND WAL
3) 2 disks in RAID 1 containing PGDATA + 2 disks in RAID 1 containing SYSTEM and WAL
4) Something different?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Vasilis Ventirozos 2013-03-13 18:15:25 Re: Setup of four 15k SAS disk with LSI raid controller
Previous Message Niels Kristian Schjødt 2013-03-13 17:34:19 Re: Risk of data corruption/loss?