Re: Do I have a hardware or a software problem?

Поиск
Список
Период
Сортировка
От Evgeny Shishkin
Тема Re: Do I have a hardware or a software problem?
Дата
Msg-id 8A08ED7E-CF78-4F40-ACF1-1C87CEBBD00A@gmail.com
обсуждение исходный текст
Ответ на Re: Do I have a hardware or a software problem?  (Craig Ringer <craig@2ndQuadrant.com>)
Ответы Re: Do I have a hardware or a software problem?  (David Boreham <david_list@boreham.org>)
Re: Do I have a hardware or a software problem?  (Craig Ringer <craig@2ndQuadrant.com>)
Список pgsql-performance

On Dec 12, 2012, at 6:02 AM, Craig Ringer <craig@2ndQuadrant.com> wrote:

On 12/12/2012 09:44 AM, Evgeny Shishkin wrote:
So far, more than a year already, i bought consumer ssds with 300-400$ hw raid. Cost effective and fast, may be not very safe, but so far so good. All data protection measures from postgresql are on, of course.

You're aware that many low end SSDs lie to the RAID controller about having written data, right? Even if the RAID controller sends a flush command, the SSD might cache the write in non-durable cache. If you're using such SSDs and you lose power, data corruption is extremely likely, because your SSDs are essentially ignoring fsync.

Your RAID controller's BBU won't save you, because once the disks tell the RAID controller the data has hit durable storage, the RAID controller feels free to flush it from its battery backed cache. If the disks are lying...

The only solid way to find out if this is an issue with your SSDs is to do plug-pull testing and find out.


Yes, i am aware of this issue. Never experienced this neither on intel 520, no ocz vertex 3.
Have you heard of them on this list?
-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Do I have a hardware or a software problem?
Следующее
От: David Boreham
Дата:
Сообщение: Re: Do I have a hardware or a software problem?