pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tomas Vondra <tv@fuzzy.cz>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Optimal settings for RAID controller - optimized for writes
Date: Fri, 21 Feb 2014 00:58:38 +0100
Message-ID: <530696AE.4010701@fuzzy.cz> (raw)
In-Reply-To: <CAOR=d=0rwTdXXv7CJsWq4CcHP=WBOXTG38h16XuefVrbUSQRJg@mail.gmail.com>
References: <D89BE95F-60D2-431B-A82D-53378392AAC3@autouncle.com>
	<CALqvQ1MRopjqc3W8Q_U061Lmm04Eip65cDNtfqB6mhj0wbA94g@mail.gmail.com>
	<bc5e841fac96910a36a563e844dfb80a.squirrel@sq.gransy.com>
	<5302B5FD.10204@lab.ntt.co.jp>
	<5303C573.8@fuzzy.cz>
	<CAHyXU0x6koA5UwHqNpJOP09DFvJsp73Rar-3gkbz1UjbYRQCtg@mail.gmail.com>
	<CAOR=d=2cZ87iE-HQO1_2jSQkH007JC4Nuh_wG=dnH9bfoZB5OA@mail.gmail.com>
	<530555F5.7070604@fuzzy.cz>
	<CAOR=d=0rwTdXXv7CJsWq4CcHP=WBOXTG38h16XuefVrbUSQRJg@mail.gmail.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>

On 20.2.2014 02:47, Scott Marlowe wrote:
> On Wed, Feb 19, 2014 at 6:10 PM, Tomas Vondra <tv@fuzzy.cz> wrote:
>> On 19.2.2014 19:09, Scott Marlowe wrote:
> 
>>> Right now I'm testing on a machine with 2x Intel E5-2690s
>>> (http://ark.intel.com/products/64596/intel-xeon-processor-e5-2690-20m-cache-2_90-ghz-8_00-gts-intel-q...)
>>> 512GB RAM and 6x600GB Intel SSDs (not sure which ones) under a LSI
>>
>> Most likely S3500. S3700 are not offered with 600GB capacity.
>>
>>> MegaRAID 9266. I'm able to crank out 6500 to 7200 TPS under pgbench on
>>> a scale 1000 db at 8 to 60 clients on that machine. It's not cheap,
>>> but storage wise it's WAY cheaper than most SANS and very fast.
>>> pg_xlog is on a pair of non-descript SATA spinners btw.
>>
>> Nice. I've done some testing with fusionio iodrive duo (2 devices in
>> RAID0) ~ year ago, and I got 12k TPS (or ~15k with WAL on SAS RAID). So
>> considering the price, the 7.2k TPS is really good IMHO.
> 
> The part number reported by the LSI is: SSDSC2BB600G4 so I'm assuming
> it's an SLC drive. Done some further testing, I keep well over 6k tps
> right up to 128 clients. At no time is there any IOWait under vmstat,
> and if I turn off fsync speed goes up by some tiny amount, so I'm
> guessing I'm CPU bound at this point. This machine has dual 8 core HT
> Intels CPUs.

No, it's S3500, which is a MLC drive.

http://ark.intel.com/products/74944/Intel-SSD-DC-S3500-Series-600GB-2_5in-SATA-6Gbs-20nm-MLC

Tomas



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



view thread (20+ messages)  latest in thread

Message-ID: <530696AE.4010701@fuzzy.cz>
Permalink:  ../530696AE.4010701@fuzzy.cz/
Also on:    postgresql.org/message-id/530696AE.4010701@fuzzy.cz

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tv@fuzzy.cz, scott.marlowe@gmail.com
  Subject: Re: Optimal settings for RAID controller - optimized for writes
  In-Reply-To: <530696AE.4010701@fuzzy.cz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox