Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller

BTW

our Machine got build with 8 15k drives in raid10 ,
from bonnie++ results its looks like the machine is
able to do 400 Mbytes/s seq write and 550 Mbytes/s
read. the BB cache is enabled with 256MB

sda6 --> xfs with default formatting options.
sda7 --> mkfs.xfs -f -d sunit=128,swidth=512 /dev/sda7
sda8 --> ext3 (default)

it looks like mkfs.xfs options sunit=128 and swidth=512 did not improve
io throughtput as such in bonnie++ tests .

it looks like ext3 with default options performed worst in my case.

regds
-- mallah

NOTE: observations made in this post are interpretations by the poster
only which may or may not be indicative of the true suitablity of the
filesystem.

On Mon, Feb 16, 2009 at 7:01 PM, Gregory Stark <stark(at)enterprisedb(dot)com> wrote:
> Arjen van der Meijden <acmmailing(at)tweakers(dot)net> writes:
>
>> When we purchased our Perc 5/e with MD1000 filled with 15 15k rpm sas disks, my
>> colleague actually spend some time benchmarking the PERC and a ICP Vortex
>> (basically a overclocked Adaptec) on those drives. Unfortunately he doesn't
>> have too many comparable results, but it basically boiled down to quite good
>> scores for the PERC and a bit less for the ICP Vortex.
>> IOMeter sequential reads are above 300MB/s for the RAID5 and above 240MB/s for
>> a RAID10 (and winbench99 versions range from 400+ to 600+MB/s).
>
> FWIW those are pretty terrible numbers for fifteen 15k rpm drives. They're
> about what you would expect if for a PCI-X card which was bus bandwidth
> limited. A PCI-e card should be able to get about 3x that from the drives.
>
> --
> Gregory Stark
> EnterpriseDB http://www.enterprisedb.com
> Ask me about EnterpriseDB's RemoteDBA services!
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>