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

From: Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>
To: Matthew Wakeling <matthew(at)flymine(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
Date: 2009-02-17 13:25:42
Message-ID: a97c77030902170525k4528ddc1kdd8037d8b2a0de16@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Feb 17, 2009 at 5:15 PM, Matthew Wakeling <matthew(at)flymine(dot)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(at)carfax(dot)nildram(dot)co(dot)uk>
>
> --
> 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
>

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jörg Kiegeland 2009-02-17 14:33:40 Cannot interpret EXPLAIN
Previous Message Gregory Stark 2009-02-17 13:10:11 Re: Query composite index range in an efficient way