Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller - Mailing list pgsql-performance

From Rajesh Kumar Mallah
Subject Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
Date
Msg-id a97c77030902170525k4528ddc1kdd8037d8b2a0de16@mail.gmail.com
Whole thread Raw
In response to Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller  (Matthew Wakeling <matthew@flymine.org>)
Responses Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
List pgsql-performance
On Tue, Feb 17, 2009 at 5:15 PM, Matthew Wakeling <matthew@flymine.org> wrote:
> On Tue, 17 Feb 2009, Rajesh Kumar Mallah wrote:
>>
>> 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.
>
> Of course, doing comparisons using a setup like that (on separate
> partitions) will skew the results, because discs' performance differs
> depending on the portion of the disc being accessed. You should perform the
> different filesystem tests on the same partition one after the other
> instead.

point noted . will redo the test on ext3.


>
> Matthew
>
> --
> "We did a risk management review.  We concluded that there was no risk
> of any management."        -- Hugo Mills <hugo@carfax.nildram.co.uk>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Query composite index range in an efficient way
Next
From: Jörg Kiegeland
Date:
Subject: Cannot interpret EXPLAIN