Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WGcZf-00066H-86 for pgsql-performance@arkaria.postgresql.org; Thu, 20 Feb 2014 22:58:35 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WGcZe-00016O-Gc for pgsql-performance@arkaria.postgresql.org; Thu, 20 Feb 2014 22:58:34 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WGcZc-00016F-7J for pgsql-performance@postgresql.org; Thu, 20 Feb 2014 22:58:32 +0000 Received: from mail.gransy.com ([2001:1528:137::f1]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WGcZY-0005GY-3E for pgsql-performance@postgresql.org; Thu, 20 Feb 2014 22:58:31 +0000 Received: from antispam.gransy.com (antispam.gransy.com [77.78.104.124]) by mail.gransy.com (Postfix) with ESMTP id A265448A030 for ; Thu, 20 Feb 2014 23:58:22 +0100 (CET) X-Virus-Scanned: G-Hosting.cz + Station.cz + Klenot.cz + Subreg.cz amavisd-new at antispam.gransy.com Received: from mail.gransy.com ([82.208.29.194]) by antispam.gransy.com (antispam.gransy.com [77.78.104.124]) (amavisd-new, port 10024) with ESMTP id 2cts5xMrIcEz for ; Thu, 20 Feb 2014 23:58:35 +0100 (CET) Received: from [192.168.1.163] (ip-78-45-139-138.net.upcbroadband.cz [78.45.139.138]) (using TLSv1 with cipher DHE-RSA-AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: tv@fuzzy.cz) by mail.gransy.com (Postfix) with ESMTPSA id 9153648A01C; Thu, 20 Feb 2014 23:58:21 +0100 (CET) Message-ID: <530696AE.4010701@fuzzy.cz> Date: Fri, 21 Feb 2014 00:58:38 +0100 From: Tomas Vondra User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.3.0 MIME-Version: 1.0 To: Scott Marlowe CC: "pgsql-performance@postgresql.org" Subject: Re: Optimal settings for RAID controller - optimized for writes References: <5302B5FD.10204@lab.ntt.co.jp> <5303C573.8@fuzzy.cz> <530555F5.7070604@fuzzy.cz> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org On 20.2.2014 02:47, Scott Marlowe wrote: > On Wed, Feb 19, 2014 at 6:10 PM, Tomas Vondra 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-qpi) >>> 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