| From: | Craig Ringer <craig(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Evgeny Shishkin <itparanoia(at)gmail(dot)com> |
| Cc: | Niels Kristian Schjødt <nielskristian(at)autouncle(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Do I have a hardware or a software problem? |
| Date: | 2012-12-12 01:29:02 |
| Message-ID: | 50C7DDDE.1000000@2ndQuadrant.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 12/12/2012 09:17 AM, Evgeny Shishkin wrote:
>
> Actually most of low-end SSDs don't do write caching, they do not have
> enough ram for that. Sandforce for example.
>
Or, worse, some of them do limited write caching but don't protect their
write cache from power loss. Instant data corruption!
I would be extremely reluctant to use low-end SSDs for a database server.
> If we are talking about dedicated machine for database with ssd
> drives, why would anybody don't by hardware raid for about 500-700$?
I'd want to consider whether the same money is better spent on faster,
higher quality SSDs with their own fast write caches.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Evgeny Shishkin | 2012-12-12 01:44:24 | Re: Do I have a hardware or a software problem? |
| Previous Message | Evgeny Shishkin | 2012-12-12 01:17:14 | Re: Do I have a hardware or a software problem? |