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

Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> · Fri, 13 Mar 2015 19:05:04 +0200



    On 13/03/2015 18:01, Fernando Hevia
      wrote:

    
          On Fri, Mar 13, 2015 at 11:31 AM,
            Ryan Thompson <agyant@xxxxxxxxx>
            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