Re: SSD and RAID - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: SSD and RAID
Date
Msg-id 4F56ADA5.4040902@catalyst.net.nz
Whole thread Raw
In response to Re: SSD and RAID  (Yeb Havinga <yebhavinga@gmail.com>)
Responses Re: SSD and RAID
List pgsql-performance
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.

Regards

Mark




pgsql-performance by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Advice sought : new database server
Next
From: Yeb Havinga
Date:
Subject: Re: SSD and RAID