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

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: Do I have a hardware or a software problem?
Дата
Msg-id 50C7F057.70309@2ndQuadrant.com
обсуждение исходный текст
Ответ на Re: Do I have a hardware or a software problem?  (Evgeny Shishkin <itparanoia@gmail.com>)
Ответы Re: Do I have a hardware or a software problem?  (Niels Kristian Schjødt <nielskristian@autouncle.com>)
Список pgsql-performance
On 12/12/2012 10:13 AM, Evgeny Shishkin wrote:

Yes, i am aware of this issue. Never experienced this neither on intel 520, no ocz vertex 3.


I wouldn't trust either of those drives. The 520 doesn't have Intel's " Enhanced Power Loss Data Protection"; it's going to lose its buffers if it loses power. Similarly, the Vertex 3 doesn't have any kind of power protection. See:

http://www.intel.com/content/www/us/en/solid-state-drives/ssd-320-series-power-loss-data-protection-brief.html
http://ark.intel.com/products/family/56572/Intel-SSD-500-Family

http://www.ocztechnology.com/res/manuals/OCZ_SSD_Breakdown_Q2-11_1.pdf

The only way I'd use those for a production server was if I had synchronous replication running to another machine with trustworthy, durable storage - and if I didn't mind some downtime to restore the corrupt DB from the replica after power loss.

-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services

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

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