From: | Vasilis Ventirozos <v(dot)ventirozos(at)gmail(dot)com> |
---|---|
To: | postgres performance list <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Setup of four 15k SAS disk with LSI raid controller |
Date: | 2013-03-13 18:15:25 |
Message-ID: | CAF8jcqoq7KYFsOX6szojN1sTdq3sdQbJ7Sd2JebfE5vNbz143Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)autouncle(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
From | Date | Subject | |
---|---|---|---|
Next Message | Niels Kristian Schjødt | 2013-03-13 18:37:40 | Re: Setup of four 15k SAS disk with LSI raid controller |
Previous Message | Niels Kristian Schjødt | 2013-03-13 17:43:16 | Setup of four 15k SAS disk with LSI raid controller |