Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UfKir-0007sD-PN for pgsql-performance@arkaria.postgresql.org; Thu, 23 May 2013 01:53:41 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UfKir-0006n3-9v for pgsql-performance@arkaria.postgresql.org; Thu, 23 May 2013 01:53:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UfKiq-0006my-Hd for pgsql-performance@postgresql.org; Thu, 23 May 2013 01:53:40 +0000 Received: from moutng.kundenserver.de ([212.227.126.186]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UfKij-0003iR-El for pgsql-performance@postgresql.org; Thu, 23 May 2013 01:53:40 +0000 Received: from [192.168.1.110] (mail.highperformancepostgresql.com [71.179.240.8]) by mrelayeu.kundenserver.de (node=mreu0) with ESMTP (Nemesis) id 0MJoUy-1UeEG70zjg-001JoL; Thu, 23 May 2013 03:53:32 +0200 Message-ID: <519D769B.1030406@2ndQuadrant.com> Date: Wed, 22 May 2013 21:53:31 -0400 From: Greg Smith User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:14.0) Gecko/20120713 Thunderbird/14.0 MIME-Version: 1.0 To: Merlin Moncure CC: "Joshua D. Drake" , sthomas@optionshouse.com, Tomas Vondra , pgsql-performance@postgresql.org Subject: Re: Reliability with RAID 10 SSD and Streaming Replication References: <51957499.6050905@fuzzy.cz> <519991EB.8010208@2ndQuadrant.com> <519A8E29.60702@fuzzy.cz> <519C0EFD.9080002@2ndQuadrant.com> <519CF8CC.1030204@optionshouse.com> <519D0921.9080807@2ndQuadrant.com> <519D174A.4050703@commandprompt.com> <519D1CD6.2080607@2ndQuadrant.com> <519D2562.2060604@2ndQuadrant.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:TIQ8wp3nnuTrUXwZ0XjbKgPDUY4rmm7LgwvMtZJkNfm AwMxl+k+gaSjetn6Q+ZqMiboQcjCXVY8x9heU/8h84VB6MBm6p nBHpnvvFi/qJVkyH938QZMdjMk9OPUIzrfK/Veqjnjday4tIo2 WM3ulo7T/Uco0zWJXaM2TUTWbRyI30rNEpsiEOT03jz/K6h0hP 0bZZypnNombKl9TV1Y7VOjitOCPeJ3Ow62UfhfidCTRMBvJUku dPa51TVwP6ZGDGa899sEGgsjZ6B+8ayFd0l2+vxEQSsju5yu+9 ywxTKiHq6dHD7BM/tyPNGjhU3RrEmcRke8YmWulnNAWKZEdI0v Fwva0KD1TgDeP7nEhYWk= 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 5/22/13 4:57 PM, Merlin Moncure wrote: > Oh, the major vendors will still keep their > rip-off going on a little longer selling their storage trays, raid > controllers, entry/mid level SANS, SAS HBAs etc at huge markup to > customers who don't need them (some will still need them, but the bar > suddenly just got spectacularly raised before you have to look into > enterprise gear). The angle to distinguish "enterprise" hardware is moving on to error related capabilities. Soon we'll see SAS drives with the 520 byte sectors and checksumming for example. And while SATA drives have advanced a long way, they haven't caught up with SAS for failure handling. It's still far too easy for a single crazy SATA device to force crippling bus resets for example. Individual SATA ports don't expect to share things with others, while SAS chains have a much better protocol for handling things. -- Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.com -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance