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

From Vasilis Ventirozos
Subject Re: Setup of four 15k SAS disk with LSI raid controller
Date
Msg-id CAF8jcqoq7KYFsOX6szojN1sTdq3sdQbJ7Sd2JebfE5vNbz143Q@mail.gmail.com
Whole thread Raw
In response to Setup of four 15k SAS disk with LSI raid controller  (Niels Kristian Schjødt <nielskristian@autouncle.com>)
Responses Re: Setup of four 15k SAS disk with LSI raid controller
List pgsql-performance
raid0 tends to linear scaling so 3 of them should give something close to 300% increased write speed. So i would say 1. but make sure you test your configuration as soon as you can with bonnie++ or something similar

On Wed, Mar 13, 2013 at 7:43 PM, Niels Kristian Schjødt <nielskristian@autouncle.com> wrote:
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?



--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

Previous
From: Niels Kristian Schjødt
Date:
Subject: Setup of four 15k SAS disk with LSI raid controller
Next
From: Niels Kristian Schjødt
Date:
Subject: Re: Setup of four 15k SAS disk with LSI raid controller