Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 55E3F125103 for ; Tue, 15 May 2012 14:08:34 -0300 (ADT) Received: from server13-scl.nuevasync.com ([64.13.157.153] helo=mail.nuevasync.com) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SULEc-0007pk-Q8 for pgsql-performance@postgresql.org; Tue, 15 May 2012 17:08:33 +0000 Received: from [192.168.1.2] (69.sub-166-250-164.myvzw.com [166.250.164.69]) by mail.nuevasync.com (Postfix) with ESMTP id 751152B2153 for ; Tue, 15 May 2012 11:08:13 -0600 (MDT) Message-ID: <4FB28D76.8080402@boreham.org> Date: Tue, 15 May 2012 11:08:06 -0600 From: David Boreham User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20120428 Thunderbird/12.0.1 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: SSD selection References: In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201205/95 X-Sequence-Number: 46919 On 5/15/2012 9:21 AM, =D0=92=D1=96=D1=82=D0=B0=D0=BB=D1=96=D0=B9 =D0=A2=D0= =B8=D0=BC=D1=87=D0=B8=D1=88=D0=B8=D0=BD wrote: > > > We've reached to the point when we would like to try SSDs. We've got a=20 > central DB currently 414 GB in size and increasing. Working set does=20 > not fit into our 96GB RAM server anymore. > So, the main question is what to take. Here what we've got: > 1) Intel 320. Good, but slower then current generation sandforce drives > 2) Intel 330. Looks like cheap 520 without capacitor > 3) Intel 520. faster then 320 No capacitor. > 4) OCZ Vertex 3 Pro - No available. Even on OCZ site > 5) OCZ Deneva - can't find in my country :) > Is the 710 series too costly for your deployment ? I ask because that would be the obvious choice for a database (much=20 better write endurance than any of the drives above, and less likely to=20 suffer from firmware bugs or unpleasant GC behavior). We've been running them in production for a few months with zero=20 problems and great performance. The price on the 710's tends to vary on whether they're in stock :=20 NewEgg is currently showing $1100 for the 300G drive, but no stock.