From: | Decibel! <decibel(at)decibel(dot)org> |
---|---|
To: | Jeff <threshar(at)torgo(dot)978(dot)org> |
Cc: | Henrik <henke(at)mac(dot)se>, david(at)lang(dot)hm, Luke Lonergan <LLonergan(at)greenplum(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Filesystem benchmarking for pg 8.3.3 server |
Date: | 2008-08-13 15:13:34 |
Message-ID: | 8795DFE4-BFE1-49A5-8341-A6823DF2BE4E@decibel.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Aug 11, 2008, at 9:01 AM, Jeff wrote:
> On Aug 11, 2008, at 5:17 AM, Henrik wrote:
>
>> OK, changed the SAS RAID 10 to RAID 5 and now my random writes are
>> handing 112 MB/ sek. So it is almsot twice as fast as the RAID10
>> with the same disks. Any ideas why?
>>
>> Is the iozone tests faulty?
>
>
> does IOzone disable the os caches?
> If not you need to use a size of 2xRAM for true results.
>
> regardless - the test only took 10 seconds of wall time - which
> isn't very long at all. You'd probably want to run it longer anyway.
Additionally, you need to be careful of what size writes you're
using. If you're doing random writes that perfectly align with the
raid stripe size, you'll see virtually no RAID5 overhead, and you'll
get the performance of N-1 drives, as opposed to RAID10 giving you N/2.
--
Decibel!, aka Jim C. Nasby, Database Architect decibel(at)decibel(dot)org
Give your computer some brain candy! www.distributed.net Team #1828
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2008-08-13 16:55:38 | Re: Filesystem benchmarking for pg 8.3.3 server |
Previous Message | Decibel! | 2008-08-13 14:59:49 | Re: Incorrect estimates on correlated filters |