From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Subject: Re: Tuning guidelines for server with 256GB of RAM and
 SSDs?
To: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
References: <89036cd7-e798-4e2a-a6bd-ab98641a452a@email.android.com>
 <577DE1C2.2010509@catalyst.net.nz>
 <CAHo5iygNZ7UnaYh7hwLK+3T6e-g55wRpmTT8qdrrjfHfKRGD3Q@mail.gmail.com>
 <1467900565304.12481@micron.com>
Message-ID: <577F1A72.4050303@catalyst.net.nz>
Date: Fri, 8 Jul 2016 15:13:54 +1200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.8.0
MIME-Version: 1.0
In-Reply-To: <1467900565304.12481@micron.com>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance