Re: RAID 0 not as fast as expected - Mailing list pgsql-performance

From Bucky Jordan
Subject Re: RAID 0 not as fast as expected
Date
Msg-id 78ED28FACE63744386D68D8A9D1CF5D42099AF@MAIL.corp.lumeta.com
Whole thread Raw
In response to Re: RAID 0 not as fast as expected  ("Luke Lonergan" <llonergan@greenplum.com>)
Responses Re: RAID 0 not as fast as expected
List pgsql-performance
>When we first started working with Solaris ZFS, we were getting about
>400-600 MB/s, and after working with the Solaris Engineering team we
now >get
>rates approaching 2GB/s.  The updates needed to Solaris are part of the
>Solaris 10 U3 available in October (and already in Solaris Express, aka
>Solaris 11).

Luke,

What other file systems have you had good success with? Solaris would be
nice, but it looks like I'm stuck running on FreeBSD (6.1, amd64) so
UFS2 would be the default. Not sure about XFS on BSD, and I'm not sure
at the moment that ext2/3 provide enough benefit over UFS to spend much
time on.

Also, has anyone had any experience with gmirror (good or bad)? I'm
thinking of trying to use it to stripe two hardware mirrored sets since
HW RAID10 wasn't doing as well as I had hoped (Dell Perc5/I controller).
For a 4 disk RAID 10 (10k rpm SAS/SCSI disks) what would be a good
target performance number? Right now, dd shows 224 MB/s.

And lastly, for a more OLAP style database, would I be correct in
assuming that sequential access speed would be more important than is
normally the case? (I have a relatively small number of connections, but
each running on pretty large data sets).

Thanks,

Bucky

pgsql-performance by date:

Previous
From: Arjen van der Meijden
Date:
Subject: Re: Optimize SQL
Next
From: Benjamin Minshall
Date:
Subject: Performance of IN (...) vs. = ANY array[...]