Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UGH1v-00013z-42 for pgsql-performance@arkaria.postgresql.org; Thu, 14 Mar 2013 22:53:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UGH1u-0001NQ-KJ for pgsql-performance@arkaria.postgresql.org; Thu, 14 Mar 2013 22:53:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UGH1t-0001NL-S3 for pgsql-performance@postgresql.org; Thu, 14 Mar 2013 22:53:45 +0000 Received: from [2404:130:0:10::40:2] (helo=mail.catalyst.net.nz) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UGH1q-0006X6-BM for pgsql-performance@postgresql.org; Thu, 14 Mar 2013 22:53:44 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.catalyst.net.nz (Postfix) with ESMTP id EBC8E67807; Fri, 15 Mar 2013 11:53:38 +1300 (NZDT) X-Virus-Scanned: Debian amavisd-new at catalyst.net.nz Received: from mail.catalyst.net.nz ([127.0.0.1]) by localhost (bertrand.catalyst.net.nz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Vz5atH1wkj9Y; Fri, 15 Mar 2013 11:53:38 +1300 (NZDT) Received: from [IPv6:2404:130:0:1000:2c77:81a7:a591:370e] (unknown [IPv6:2404:130:0:1000:2c77:81a7:a591:370e]) (Authenticated sender: mark.kirkwood) by mail.catalyst.net.nz (Postfix) with ESMTPSA id 0130D677FB; Fri, 15 Mar 2013 11:53:37 +1300 (NZDT) Message-ID: <514254F1.8090204@catalyst.net.nz> Date: Fri, 15 Mar 2013 11:53:37 +1300 From: Mark Kirkwood User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130221 Thunderbird/17.0.3 MIME-Version: 1.0 To: Bruce Momjian CC: Gregg Jaskiewicz , Greg Smith , postgres performance list , =?ISO-8859-1?Q?Niels_Kristian_Schj=F8dt?= 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> <20130314223449.GE28770@momjian.us> In-Reply-To: <20130314223449.GE28770@momjian.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Host-Lookup-Failed: Reverse DNS lookup failed for 2404:130:0:10::40:2 (failed) X-Pg-Spam-Score: -1.1 (-) 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 15/03/13 11:34, Bruce Momjian wrote: > > I don't think any drive that corrupts on power-off is suitable for a > database, but for non-db uses, sure, I guess they are OK, though you > have to be pretty money-constrainted to like that tradeoff. > Agreed - really *all* SSD should have capacitor (or equivalent) power off protection...that fact that it's a feature present on only a handful of drives is...disappointing. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance