Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 28755632EA6 for ; Thu, 12 Aug 2010 01:30:59 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 58018-08 for ; Thu, 12 Aug 2010 04:30:51 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.10]) by mail.postgresql.org (Postfix) with ESMTP id 9E829632D41 for ; Thu, 12 Aug 2010 01:30:51 -0300 (ADT) Received: from [192.168.1.151] (static-71-179-240-8.bltmmd.fios.verizon.net [71.179.240.8]) by mrelayeu.kundenserver.de (node=mreu2) with ESMTP (Nemesis) id 0MGVFc-1OexRo1OzI-00DmPD; Thu, 12 Aug 2010 06:30:48 +0200 Message-ID: <4C6378F7.9040000@2ndquadrant.com> Date: Thu, 12 Aug 2010 00:30:47 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Scott Carey CC: Michael March , "pgsql-performance@postgresql.org" Subject: Re: Completely un-tuned Postgresql benchmark results: SSD vs desktop HDD References: <4C617C80.9080509@2ndquadrant.com> <72E29316-5F4C-4A01-8924-5340DF2FAE65@richrelevance.com> In-Reply-To: <72E29316-5F4C-4A01-8924-5340DF2FAE65@richrelevance.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:kfyigrSXIJhf2rGd62v2d1l7dGHC93Q0oFshFBeBzgt 4cj1vxjSRwvIf5WnxW9PhoLLivP2a2YeT34jX0vpfX4y7EF4I0 EtjhyZrkfrK4lYyuEiACi8Nx2kta04Jk6fc+CpR9hdvNxzDrlz LRcsC5YX1N7ivHKDxadqDoja407qe3ZgOX0IK522FW/pdjKQLr 3Lp4HXVypNQcrgYGYMKNRlzKaIkteV0DfAidA/Me/0= 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, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201008/140 X-Sequence-Number: 39983 Scott Carey wrote: > What is the likelihood that your RAID card fails, or that the battery that reported 'good health' only lasts 5 minutes and you lose data before power is restored? What is the likelihood of human error? > These are all things that happen sometimes, sure. The problem with the cheap SSDs is that they happen downright often if you actually test for it. If someone is aware of the risk and makes an informed decision, fine. But most of the time I see articles like the one that started this thread that are oblivious to the issue, and that's really bad. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us