Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 0CBD4B5DC1E for ; Mon, 24 Oct 2011 20:18:26 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 14984-09 for ; Mon, 24 Oct 2011 23:18:20 +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 10266B5DC45 for ; Mon, 24 Oct 2011 20:18:20 -0300 (ADT) Received: from [69.145.82.243] (unknown [69.145.82.243]) by mail.nuevasync.com (Postfix) with ESMTP id C7A272B19E8 for ; Mon, 24 Oct 2011 16:52:33 -0600 (MDT) Message-ID: <4EA5F23A.4040900@boreham.org> Date: Mon, 24 Oct 2011 17:18:18 -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> 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/197 X-Sequence-Number: 45419 On 10/24/2011 3:31 PM, Merlin Moncure wrote: >> 4. Consider using Intel 710 series rather than 320 (pay for them with the >> > money saved from #3 above). Those devices have much, much higher specified >> > endurance than the 320s and since your DB is quite small you only need to >> > buy one of them. > 710 is good idea if and only if you are worried about write durability > (in which case it's a great idea). I disagree with this (that it is the only reason to select 710 series). The write endurance (specified at least) is orders of magnitude higher. Doing 100's of TPS constantly it is possible to burn through the 320's endurance lifetime in a year or two.