Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 75F1CB5DC9D for ; Tue, 25 Oct 2011 12:00:56 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 87328-09 for ; Tue, 25 Oct 2011 15:00:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from mail.nuevasync.com (server13-scl.nuevasync.com [64.13.157.153]) by mail.postgresql.org (Postfix) with ESMTP id 4648EB5DC74 for ; Tue, 25 Oct 2011 12:00:49 -0300 (ADT) Received: from [69.145.82.235] (unknown [69.145.82.235]) by mail.nuevasync.com (Postfix) with ESMTP id E51292B19E8 for ; Tue, 25 Oct 2011 08:35:00 -0600 (MDT) Message-ID: <4EA6CF16.5090001@boreham.org> Date: Tue, 25 Oct 2011 09:00:38 -0600 From: David Boreham User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Choosing between Intel 320, Intel 510 or OCZ Vertex 3 SSD for db server References: <4EA5980E.9050903@boreham.org> <4EA620D1.5090008@boreham.org> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201110/208 X-Sequence-Number: 45430 On 10/25/2011 8:55 AM, Claudio Freire wrote: > But what about unexpected failures. Faulty electronics, stuff like > that? I really don't think a production server can work without at > least raid-1. Same approach : a server either works or it does not. The transition between working and not working may be expected or not expected. The solution is the same : use another machine to perform the work the now not working machine was doing. The big benefit of this approach is that you now do not need to worry about specific kinds of failure or individual components, including storage. If it helps, think of this architecture as raid-1, but with the whole machine being the "drive" rather than individual storage devices.