Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id DE6758B63D8 for ; Wed, 20 Jun 2012 12:17:41 -0300 (ADT) Received: from news.hub.org ([200.46.204.72]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ShMf6-0004js-KY for pgsql-performance@postgresql.org; Wed, 20 Jun 2012 15:17:41 +0000 Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.5/8.14.5) with ESMTP id q5KFHR97058023 for ; Wed, 20 Jun 2012 12:17:27 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.5/8.14.5/Submit) id q5KEp9oV031725 for pgsql-performance@postgresql.org; Wed, 20 Jun 2012 11:51:09 -0300 (ADT) (envelope-from news) From: Michal Szymanski X-Newsgroups: pgsql.performance Subject: SSD, Postgres and safe write cache Date: Wed, 20 Jun 2012 07:51:08 -0700 (PDT) Organization: http://groups.google.com Lines: 7 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 X-Complaints-To: groups-abuse@google.com Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=80.50.125.74; posting-account=Yw-CPAkAAAC8M11Mi_RZuujjejymecX- User-Agent: G2/1.0 To: pgsql-performance@postgresql.org X-Pg-Spam-Score: 0.8 (/) X-Archive-Number: 201206/127 X-Sequence-Number: 47153 Hi, We started to think about using SSD drive for our telco system DB. Because we have many "almost" read-only data I think SSD is good candidate for our task. We would like to speed up process of read operation. I've read post (http://blog.2ndquadrant.com/intel_ssd_now_off_the_sherr_sh/) about SSD which have write safe functionality and two drive are recommended Intel 320 and Vertex2 Pro. Both drive are rather inexpensive but both using old SATA II. I tried to find newer faster version of Vertex because production Vertex 2 Pro is stopped but there is no information about new drives that has similar functionality and are cheap. Do you recommend cheap SSD drives that are suitable for DB needs? Regards Michal Szymanski