SSD, Postgres and safe write cache

Поиск
Список
Период
Сортировка
От Michal Szymanski
Тема SSD, Postgres and safe write cache
Дата
Msg-id f9d6d786-867f-4d25-ad93-646d842e09fd@googlegroups.com
обсуждение исходный текст
Ответы Re: SSD, Postgres and safe write cache  (Yeb Havinga <yebhavinga@gmail.com>)
Re: SSD, Postgres and safe write cache  (Greg Smith <greg@2ndQuadrant.com>)
Список 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
functionalityand two drive are recommended Intel 320 and Vertex2 Pro. Both drive are rather inexpensive but both using
oldSATA II. 
I tried to find newer faster version of Vertex because production Vertex 2 Pro is stopped but there is no information
aboutnew drives that has similar functionality and are cheap. Do you recommend cheap SSD drives that are suitable for
DBneeds? 

Regards
Michal Szymanski

В списке pgsql-performance по дате отправления:

Предыдущее
От: philippe.beaudoin@bull.net
Дата:
Сообщение: random char or text variable in pgbench
Следующее
От: Andy Halsall
Дата:
Сообщение: Can I do better than this heapscan and sort?