Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 672B5B5DBE1 for ; Mon, 15 Aug 2011 20:50:00 -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 91756-01 for ; Mon, 15 Aug 2011 23:49:53 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.171]) by mail.postgresql.org (Postfix) with ESMTP id 7A716B5DBD5 for ; Mon, 15 Aug 2011 20:49:53 -0300 (ADT) Received: from [192.168.1.6] (mail.highperformancepostgresql.com [71.179.240.8]) by mrelayeu.kundenserver.de (node=mreu4) with ESMTP (Nemesis) id 0MJZaJ-1QrCJ93KJv-0033GE; Tue, 16 Aug 2011 01:49:53 +0200 Message-ID: <4E49B0A0.2060705@2ndQuadrant.com> Date: Mon, 15 Aug 2011 19:49:52 -0400 From: Greg Smith User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.16) Gecko/20110702 Icedove/3.0.11 MIME-Version: 1.0 To: "pgsql-performance@postgresql.org" Subject: Reports from SSD purgatory Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:Ozo3HqgULYMTGs1QrqyfdtO0Fgq4lisHo/Llxl0YQch fcYM+8KY0EUJUcSSuLROXCYbQxmpR/jc2wbJ48d6VdXD7bmwN+ wn60AQui0yIxC0LJpeQGZdLKox820aPhL1prap8KYj8aXVchnX M0JH8/wj8K8KOnitzI6dbjMKbpG3nNS66BxoAKnSnhn2Ylj3uc rYwnQo1AupFJ8RUoZ2eZ2oc4caTxMMViNiZnX06lLQ= 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: 201108/165 X-Sequence-Number: 44612 News update for anyone else who's trapped like me, waiting for a fix to the Intel 320 SSD bug where they can truncate themselves to 8MB. Over the weekend Intel has announced a firmware fix for the problem is done, and is due to ship "within the next two weeks": http://communities.intel.com/thread/24121 On the larger SSD reliability front, Tom's Hardware surveyed heavy SSD users they're friendly with who use Intel drives. The most interesting data came from Softlayer: http://www.tomshardware.com/reviews/ssd-reliability-failure-rate,2923-6.html This supports two claims I made before based on my private data that were controversial: -Annualized SSD failure rates are not significantly lower than traditional drives in the first couple of years. Jury is still out on whether they will spike upwards starting at 3 years as mechanical ones do. -The most common source of dead drives is sudden, catastrophic electronics failure. These are not predicted by SMART, and have nothing to do with hitting the drive's wear limits. -- Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us