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
>
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 |