From: Henrik <henke@mac.se>
To: Decibel! <decibel@decibel.org>
Cc: Jeff <threshar@torgo.978.org>
Cc: david@lang.hm, Luke Lonergan <LLonergan@greenplum.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Filesystem benchmarking for pg 8.3.3 server
Date: Wed, 13 Aug 2008 21:54:43 +0200
Message-ID: <32CD744F-2C1A-4BE2-B4BA-90CFD3A86DF7@mac.se> (raw)
In-Reply-To: <8795DFE4-BFE1-49A5-8341-A6823DF2BE4E@decibel.org>
References: <014F2941B0A1EA47BD61D21526B806E903509704@MI8NYCMAIL08.Mi8.com>
<F54DECFD-927B-4F64-B913-E8D903892435@mac.se>
<alpine.DEB.1.10.0808081917080.4561@asgard.lang.hm>
<AC012133-6932-46DD-A723-B2DCF98E5380@mac.se>
<2DBD3E73-D9E5-4DFA-832F-3FD53480B284@torgo.978.org>
<8795DFE4-BFE1-49A5-8341-A6823DF2BE4E@decibel.org>
13 aug 2008 kl. 17.13 skrev Decibel!:
> 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.
But it still needs to do 2 reads and 2 writes for every write, correct?
I did some bonnie++ tests just to give some new more reasonable numbers.
This is with RAID10 on 4 SAS 15k drives with write-back cache.
Version 1.03b ------Sequential Output------ --Sequential Input-
--Random-
-Per Chr- --Block-- -Rewrite- -Per Chr- --Block--
--Seeks--
Machine Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec
%CP /sec %CP
safecube04 32136M 73245 95 213092 16 89456 11 64923 81 219341
16 839.9 1
------Sequential Create------ --------Random
Create--------
-Create-- --Read--- -Delete-- -Create-- --Read---
-Delete--
files /sec %CP /sec %CP /sec %CP /sec %CP /sec
%CP /sec %CP
16 6178 99 +++++ +++ +++++ +++ 6452 100 +++++ +++
20633 99
safecube04,32136M,
73245,95,213092,16,89456,11,64923,81,219341,16,839.9,1,16,6178,99,++++
+,+++,+++++,+++,6452,100,+++++,+++,20633,99
>
> --
> Decibel!, aka Jim C. Nasby, Database Architect decibel@decibel.org
> Give your computer some brain candy! www.distributed.net Team #1828
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: henke@mac.se, decibel@decibel.org, threshar@torgo.978.org, LLonergan@greenplum.com
Subject: Re: Filesystem benchmarking for pg 8.3.3 server
In-Reply-To: <32CD744F-2C1A-4BE2-B4BA-90CFD3A86DF7@mac.se>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox