| From: | Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Scott Carey <scott(at)richrelevance(dot)com>, Matthew Wakeling <matthew(at)flymine(dot)org>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller |
| Date: | 2009-02-18 08:44:46 |
| Message-ID: | a97c77030902180044w1efceb6br6cdda66ba06066f4@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
>> Effect of ReadAhead Settings
>> disabled,256(default) , 512,1024
>>
SEQUENTIAL
>> 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?
RANDOM SEEKS /sec
xfs_ra0 6341.0
xfs_ra256 14642.7
xfs_ra512 14415.6
xfs_ra1024 14541.6
the value does not seems to be having much effect
unless its totally disabled.
regds
mallah.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-02-18 08:50:33 | Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller |
| Previous Message | Scott Marlowe | 2009-02-18 08:31:26 | Re: suggestions for postgresql setup on Dell 2950 , PERC6i controller |