Re: Filesystem benchmarking for pg 8.3.3 server

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

In response to

Responses

Browse pgsql-performance by date

  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