Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?

Поиск
Список
Период
Сортировка
От Achilleas Mantzios
Тема Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
Дата
Msg-id 550318C0.90808@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?  (Fernando Hevia <fhevia@gmail.com>)
Список pgsql-admin
On 13/03/2015 18:01, Fernando Hevia wrote:


On Fri, Mar 13, 2015 at 11:31 AM, Ryan Thompson <agyant@gmail.com> wrote:
Personally, I'd steer clear of Samsung desktop SSDs for anything mission-critical. I've seen them get ripped apart by standard SATA controllers as well as LSI MegaRAID. My rule of thumb is Samsung is okay as long as we're using RAID 1. 

For data loss, pick up a RAID controller card with BBU or capacitor-based cache protection. That way, in the event of a total power failure, the data integrity is maintained and simply continues writing to disk once power is restored.

I am afraid that won't suffice. The HD will signal the controller that the data has been committed safely - which we know is not the case - and the controller cache data would be discarded to make room for new blocks.



People,

thanks a lot for all your replies. I just hope I won't have to send the next message in this list in full panic mode.

-- 
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt

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

Предыдущее
От: Fernando Hevia
Дата:
Сообщение: Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
Следующее
От: Aniko Belim
Дата:
Сообщение: standby parallel backup