Message-ID: <4F572E25.1000307@gmail.com>
Date: Wed, 07 Mar 2012 10:45:09 +0100
From: Yeb Havinga <yebhavinga@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 5.1;
	rv:9.0) Gecko/20111222 Thunderbird/9.0.1
MIME-Version: 1.0
To: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
CC: pgsql-performance@postgresql.org
Subject: Re: SSD and RAID
References: <4F554025.9040101@catalyst.net.nz> <4F55C802.8040401@gmail.com>
	<4F56ADA5.4040902@catalyst.net.nz>
In-Reply-To: <4F56ADA5.4040902@catalyst.net.nz>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 2012-03-07 01:36, Mark Kirkwood wrote:
> On 06/03/12 21:17, Yeb Havinga wrote:
>>
>>
>> One thing to note is that linux software raid with md doesn't support 
>> discard, which might shorten the drive's expected lifetime. To get 
>> some numbers I tested the raid 1 of ssd's setup for mediawear under a 
>> PostgreSQL load earlier, see 
>> http://archives.postgresql.org/pgsql-general/2011-11/msg00141.php
>>
>>
>
> Right, which is a bit of a pain - we are considering either formatting 
> the drive with less capacity and using md RAID 1 or else doing the 
> mirror in LVM to enable a working discard/trim.

When I measured the write durability without discard on the enterprise 
disks, I got numbers that in normal production use would outlive the 
lifetime of the servers. It would be interesting to see durability 
numbers for the desktop SSDs, even when partitioned to a part of the disk.

regards,
Yeb Havinga