Re: SSD Drives

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Brent Wood <Brent(dot)Wood(at)niwa(dot)co(dot)nz>
Cc: David Rees <drees76(at)gmail(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: SSD Drives
Date: 2014-04-03 22:22:08
Message-ID: CAOR=d=1qTEx-sE2wjXX4KObEq3CCmNOENn5NFHJjPkRZvpQ9fw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Apr 3, 2014 at 1:44 PM, Brent Wood <Brent(dot)Wood(at)niwa(dot)co(dot)nz> wrote:
>
> Hi David,
>
> Does the RAID 1 array give any performance benefits over a single drive? I'd guess that writes may be slower, reads may be faster (if balanced) but data security is improved.

I did some testing on machines with 3xMLC FusionIO Drive2s with 1.2TB.
Comparing 1 drive and 2 drives in RAID-1 the difference in performance
was minimal. However, a 3 drive mirror was noticeably slower. This was
all with ubuntu 12.04 using 3.8.latest kernel and software RAID.
RAID-0 was by far the fastest, about 30% faster than either a single
or a pair of drives in RAID-1

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2014-04-03 22:58:33 Re: Is it safe to stop postgres in between pg_start_backup and pg_stop_backup?
Previous Message Scott Marlowe 2014-04-03 22:19:45 Re: SSD Drives