Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UGGjg-00081I-V6 for pgsql-performance@arkaria.postgresql.org; Thu, 14 Mar 2013 22:34:57 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UGGjg-0007aC-4n for pgsql-performance@arkaria.postgresql.org; Thu, 14 Mar 2013 22:34:56 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UGGjf-0007a6-1B for pgsql-performance@postgresql.org; Thu, 14 Mar 2013 22:34:55 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UGGjd-0000lj-Oh for pgsql-performance@postgresql.org; Thu, 14 Mar 2013 22:34:54 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1UGGjZ-00020O-1E; Thu, 14 Mar 2013 18:34:49 -0400 Date: Thu, 14 Mar 2013 18:34:49 -0400 From: Bruce Momjian To: Mark Kirkwood Cc: Gregg Jaskiewicz , Greg Smith , postgres performance list , Niels Kristian =?iso-8859-1?Q?Schj=F8dt?= Subject: Re: New server setup Message-ID: <20130314223449.GE28770@momjian.us> References: <4D6D1410-2208-4DAA-BD64-69BE1FD94E55@autouncle.com> <513CADB7.4030803@2ndQuadrant.com> <20130314185424.GA28770@momjian.us> <51424333.608@catalyst.net.nz> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <51424333.608@catalyst.net.nz> User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -4.3 (----) 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 Fri, Mar 15, 2013 at 10:37:55AM +1300, Mark Kirkwood wrote: > On 15/03/13 07:54, Bruce Momjian wrote: > >Only use SSDs with a BBU cache, and don't set SSD caches to > >write-through because an SSD needs to cache the write to avoid wearing > >out the chips early, see: > > > > http://momjian.us/main/blogs/pgblog/2012.html#August_3_2012 > > > > I not convinced about the need for BBU with SSD - you *can* use them > without one, just need to make sure about suitable longevity and > also the presence of (proven) power off protection (as discussed > previously). It is worth noting that using unproven or SSD known to > be lacking power off protection with a BBU will *not* save you from > massive corruption (or device failure) upon unexpected power loss. 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. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance