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

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
Дата
Msg-id dcc563d10902180031l217d2bcdnffa4c5699580a53a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller  (Rajesh Kumar Mallah <mallah.rajesh@gmail.com>)
Ответы Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller  (Rajesh Kumar Mallah <mallah.rajesh@gmail.com>)
Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller  (Scott Carey <scott@richrelevance.com>)
Список pgsql-performance
On Wed, Feb 18, 2009 at 12:52 AM, Rajesh Kumar Mallah
<mallah.rajesh@gmail.com> wrote:
> the raid10 voulme was benchmarked again
> taking in consideration above points

> Effect of ReadAhead Settings
> disabled,256(default) , 512,1024
>
> xfs_ra0                 414741 ,   66144
> xfs_ra256            403647,  545026                 all tests on sda6
> xfs_ra512            411357,  564769
> xfs_ra1024          404392,  431168
>
> looks like 512 was the best setting for this controller

That's only known for sequential access.
How did it perform under the random access, or did the numbers not
change too much?

> Considering these two figures
> xfs25                   350661,   474481                (/dev/sda7)
> 25xfs                   404291  , 547672                (/dev/sda6)
>
> looks like the beginning of the drives are  15% faster
> than the ending sections , considering this is it worth
> creating a special tablespace at the begining of drives

It's also good because you will be short stroking the drives.  They
will naturally have a smaller space to move back and forth in and this
can increase the random speed access at the same time.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller
Следующее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller