Skip site navigation (1) Skip section navigation (2)

Re: SSD and RAID

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: Yeb Havinga <yebhavinga(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: SSD and RAID
Date: 2012-03-07 00:36:53
Message-ID: 4F56ADA5.4040902@catalyst.net.nz (view raw or flat)
Thread:
Lists: 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




In response to

Responses

pgsql-performance by date

Next:From: Yeb HavingaDate: 2012-03-07 09:45:09
Subject: Re: SSD and RAID
Previous:From: Steve CrawfordDate: 2012-03-07 00:32:30
Subject: Re: Advice sought : new database server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group