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

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
Date: 2015-03-13 17:05:04
Message-ID: 550318C0.90808@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 13/03/2015 18:01, Fernando Hevia wrote:
>
>
> On Fri, Mar 13, 2015 at 11:31 AM, Ryan Thompson <agyant(at)gmail(dot)com <mailto:agyant(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Aniko Belim 2015-03-13 21:26:00 standby parallel backup
Previous Message Fernando Hevia 2015-03-13 16:01:45 Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?