Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIUaB-0005Fv-P5 for pgsql-performance@arkaria.postgresql.org; Thu, 21 Mar 2013 01:46:19 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UIUaA-0003cB-It for pgsql-performance@arkaria.postgresql.org; Thu, 21 Mar 2013 01:46:18 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIUa8-0003c3-Df for pgsql-performance@postgresql.org; Thu, 21 Mar 2013 01:46:16 +0000 Received: from wsip-70-169-168-7.pn.at.cox.net ([70.169.168.7] helo=fs.denninger.net) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UIUa6-0002Cm-4U for pgsql-performance@postgresql.org; Thu, 21 Mar 2013 01:46:15 +0000 Received: from [127.0.0.1] (localhost [127.0.0.1]) by fs.denninger.net (8.14.6/8.13.1) with ESMTP id r2L1kCDd063885 for ; Wed, 20 Mar 2013 20:46:12 -0500 (CDT) (envelope-from karl@denninger.net) Received: from [127.0.0.1] [192.168.1.40] by Spamblock-sys (LOCAL); Wed Mar 20 20:46:12 2013 Message-ID: <514A665F.4090400@denninger.net> Date: Wed, 20 Mar 2013 20:46:07 -0500 From: Karl Denninger User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20130215 Thunderbird/17.0.3 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: New server setup References: <4D6D1410-2208-4DAA-BD64-69BE1FD94E55@autouncle.com> <513CADB7.4030803@2ndQuadrant.com> <20130314185424.GA28770@momjian.us> <51424333.608@catalyst.net.nz> <51425F52.6040607@boreham.org> In-Reply-To: X-Enigmail-Version: 1.5.1 Content-Type: multipart/alternative; boundary="------------070005020102010009070002" X-Antivirus: avast! (VPS 130320-1, 03/20/2013), Outbound message X-Antivirus-Status: Clean X-Pg-Spam-Score: -0.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 This is a multi-part message in MIME format. --------------070005020102010009070002 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-MIME-Autoconverted: from 8bit to quoted-printable by fs.denninger.net id r2L1kCDd063885 On 3/20/2013 7:44 PM, David Rees wrote: > On Thu, Mar 14, 2013 at 4:37 PM, David Boreham = wrote: >> You might want to evaluate the performance you can achieve with a sing= le-SSD >> (use several for capacity by all means) before considering a RAID card= + SSD >> solution. >> Again I bet it depends on the application but our experience with the = older >> Intel 710 series is that their performance out-runs the CPU, at least = under >> our PG workload. > How many people are using a single enterprise grade SSD for production > without RAID? I've had a few consumer grade SSDs brick themselves - > but are the enterprise grade SSDs, like the new Intel S3700 which you > can get in sizes up to 800GB, reliable enough to run as a single drive > without RAID1? The performance of one is definitely good enough for > most medium sized workloads without the complexity of a BBU RAID and > multiple spinning disks... > > -Dave Two is one, one is none. :-) - -- Karl Denninger /The Market Ticker =AE/ Cuda Systems LLC --------------070005020102010009070002 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
On 3/20/2013 7:44 PM, David Rees wrote:
On Thu, Mar 14, 2013 at 4:37 PM, David Boreham <david_list@boreham.org> wrote:
You might want to evaluate the performance you can achieve with a single-SSD
(use several for capacity by all means) before considering a RAID card + SSD
solution.
Again I bet it depends on the application but our experience with the older
Intel 710 series is that their performance out-runs the CPU, at least under
our PG workload.
How many people are using a single enterprise grade SSD for production
without RAID? I've had a few consumer grade SSDs brick themselves -
but are the enterprise grade SSDs, like the new Intel S3700 which you
can get in sizes up to 800GB, reliable enough to run as a single drive
without RAID1? The performance of one is definitely good enough for
most medium sized workloads without the complexity of a BBU RAID and
multiple spinning disks...

-Dave
Two is one, one is none.
:-)

-
-- Karl Denninger
The Market Ticker ®
Cuda Systems LLC
--------------070005020102010009070002--