SSD, Postgres and safe write cache

From: Michal Szymanski <mich20061(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: SSD, Postgres and safe write cache
Date: 2012-06-20 14:51:08
Message-ID: f9d6d786-867f-4d25-ad93-646d842e09fd@googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2012-06-20 14:55:52 Re: scale up (postgresql vs mssql)
Previous Message Craig Ringer 2012-06-20 14:11:05 Re: index-only scan is missing the INCLUDE feature