pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@postgresql.org
Subject: Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
Date: Fri, 13 Mar 2015 19:05:04 +0200
Message-ID: <550318C0.90808@matrix.gatewaynet.com> (raw)
In-Reply-To: <CAGYT1XSn3sjZXGcbnv1EMz8YEgwHjsaV+VqXY8Fzmh4wMb7Y1w@mail.gmail.com>
References: <5502C98F.2090806@matrix.gatewaynet.com>
	<5502CCAF.4030606@commandprompt.com>
	<5502E31E.4020301@matrix.gatewaynet.com>
	<CAOR=d=3ku7EdLAFrEFUe2Qp1pR0T7WJ7cncYudmMv6iZ0nEyog@mail.gmail.com>
	<5502EC3F.4040900@matrix.gatewaynet.com>
	<CAOR=d=2VPmMNAPUN90-uUk9pMpOgY=VCcSv5vcqGgkHfQi8K=A@mail.gmail.com>
	<CABuV55Q6O2cw5S8bt=CtPZcfXHW5anmpKGHRCwAPKWnXgCDQFQ@mail.gmail.com>
	<CAGYT1XSn3sjZXGcbnv1EMz8YEgwHjsaV+VqXY8Fzmh4wMb7Y1w@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

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

view thread (12+ messages)

Message-ID: <550318C0.90808@matrix.gatewaynet.com>
Permalink:  ../550318C0.90808@matrix.gatewaynet.com/
Also on:    postgresql.org/message-id/550318C0.90808@matrix.gatewaynet.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: achill@matrix.gatewaynet.com
  Subject: Re: Samsung SSD 850 PRO 1T : any good for PostgreSQL?
  In-Reply-To: <550318C0.90808@matrix.gatewaynet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox