Re: SSDs

From: Arjen van der Meijden <acmmailing(at)tweakers(dot)net>
To: James Mansion <james(at)mansionfamily(dot)plus(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: SSDs
Date: 2008-04-02 06:44:39
Message-ID: 47F32B57.9020701@tweakers.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

My colleague has tested a single Mtron Mobo's and a set of 4. He also
mentioned the write performance was pretty bad compared to a Western
Digital Raptor. He had a solution for that however, just plug the SSD in
a raid-controller with decent cache performance (his favorites are the
Areca controllers) and the "bad" write performance is masked by the
controller's cache. It wood probably be really nice if you'd get tuned
controllers for ssd's so they use less cache for reads and more for writes.

Best regards,

Arjen

On 2-4-2008 8:16, James Mansion wrote:
> Tried harder to find info on the write cycles: found som CFs that claim
> 2million
> cycles, and found the Mtron SSDs which claim to have very advanced wear
> levelling and a suitably long lifetime as a result even with an
> assumption that
> the underlying flash can do 100k writes only.
>
> The 'consumer' MTrons are not shabby on the face of it and not too
> expensive,
> and the pro models even faster.
>
> But ... the spec pdf shows really hight performance for average access,
> stream
> read *and* write, random read ... and absolutely pants performance for
> random
> write. Like 130/s, for .5k and 4k writes.
>
> Its so pants it looks like a misprint and it doesn't seem to square with
> the
> review on tomshardware:
> http://www.tomshardware.com/2007/11/21/mtron_ssd_32_gb/page7.html
>
> Even there, the database IO rate does seem lower than you might hope,
> and this *might* be because the random reads are very very fast and the
> random writes ... aren't. Which is a shame, because that's exactly the
> bit I'd hope was fast.
>
> So, more work to do somewhere.
>
>
>

In response to

  • SSDs at 2008-04-02 06:16:20 from James Mansion

Browse pgsql-performance by date

  From Date Subject
Next Message Hell, Robert 2008-04-02 10:11:06 Re: Cursors and different settings for default_statistics_target
Previous Message James Mansion 2008-04-02 06:16:20 SSDs