Postgres Pro
Downloads
Home   >   mailing lists

Setup of four 15k SAS disk with LSI raid controller - Mailing list pgsql-performance

From Niels Kristian Schjødt
Subject Setup of four 15k SAS disk with LSI raid controller
Date
Msg-id AF0D49A8-1E14-4170-B122-B318C52360C5@autouncle.com
Whole thread Raw
Responses Re: Setup of four 15k SAS disk with LSI raid controller  (Vasilis Ventirozos <v.ventirozos@gmail.com>)
List pgsql-performance
Tree view 
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
optimalperformance for my server, which will be pretty write heavy at times, and less optimized for redundancy, as my
datais 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?

pgsql-performance by date:

Previous
From: Niels Kristian Schjødt
Date:
Subject: Re: Risk of data corruption/loss?
Next
From: Vasilis Ventirozos
Date:
Subject: Re: Setup of four 15k SAS disk with LSI raid controller