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

Поиск
Список
Период
Сортировка
От Rajesh Kumar Mallah
Тема Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
Дата
Msg-id a97c77030902170525k4528ddc1kdd8037d8b2a0de16@mail.gmail.com
обсуждение исходный текст
Ответ на Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller  (Matthew Wakeling <matthew@flymine.org>)
Ответы Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller  (Scott Carey <scott@richrelevance.com>)
Список 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 по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: Query composite index range in an efficient way
Следующее
От: Jörg Kiegeland
Дата:
Сообщение: Cannot interpret EXPLAIN