Re: Tuning guidelines for server with 256GB of RAM and SSDs? - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: Tuning guidelines for server with 256GB of RAM and SSDs?
Date
Msg-id 577F1A72.4050303@catalyst.net.nz
Whole thread Raw
In response to Re: Tuning guidelines for server with 256GB of RAM and SSDs?  ("Wes Vaske (wvaske)" <wvaske@micron.com>)
List pgsql-performance
On 08/07/16 02:09, Wes Vaske (wvaske) wrote:
> ?The Crucial drive does not have power loss protection. The Samsung drive does.
>
>
> (The Crucial M550 has capacitors to protect data that's already been written to the device but not the entire cache.
Forinstance, if data is read from the device during a garbage collection operation, the M550 will protect that data
insteadof introducing corruption of old data. This is listed as "power loss protection" on the spec sheet but it's not
thelevel of protection that people on this list would expect from a drive) 
>

Yes - the MX200 board (see):

http://www.anandtech.com/show/9258/crucial-mx200-250gb-500gb-1tb-ssd-review

looks to have the same sort of capacitors that the M550 uses, so not
ideal for db or transaction logs!

Cheers

Mark


pgsql-performance by date:

Previous
From: Kaixi Luo
Date:
Subject: Re: Tuning guidelines for server with 256GB of RAM and SSDs?
Next
From: Jean-David Beyer
Date:
Subject: Capacitors, etc., in hard drives and SSD for DBMS machines...