Re: Tuning guidelines for server with 256GB of RAM and SSDs?

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Tuning guidelines for server with 256GB of RAM and SSDs?
Date: 2016-07-08 03:13:54
Message-ID: 577F1A72.4050303@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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. For instance, if data is read from the device during a garbage collection operation, the M550 will protect that data instead of introducing corruption of old data. This is listed as "power loss protection" on the spec sheet but it's not the level 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jean-David Beyer 2016-07-08 10:23:38 Capacitors, etc., in hard drives and SSD for DBMS machines...
Previous Message Kaixi Luo 2016-07-07 21:06:53 Re: Tuning guidelines for server with 256GB of RAM and SSDs?