From: Rory Campbell-Lange <rory@campbell-lange.net>
To: Ants Aasma <ants.aasma@eesti.ee>
Cc: Merlin Moncure <mmoncure@gmail.com>
Cc: Craig James <cjames@emolecules.com>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Advice sought : new database server
Date: Thu, 8 Mar 2012 13:27:37 +0000
Message-ID: <20120308132737.GA3411@campbell-lange.net> (raw)
In-Reply-To: <CA+CSw_udgmESYpkFJ_nDpkom6t+JTQsEtdzH0D8C6bXvrU6OHQ@mail.gmail.com>
References: <20120304095838.GA3064@campbell-lange.net>
<CAOR=d=1L=aunEtULW2sq9c-tAdZzSM6exi6wUw0w_zzjGLBRHQ@mail.gmail.com>
<20120304183630.GA8902@campbell-lange.net>
<CAFwQ8rc01cv61tvcUiyo=Xo_2g+kCges4PDosnPnpLP4x49SxQ@mail.gmail.com>
<CAHyXU0yKEcG_BPMevJXVsLoZ=w7-VU29Ngrwp1eOOkPvvMYQ+A@mail.gmail.com>
<CA+CSw_udgmESYpkFJ_nDpkom6t+JTQsEtdzH0D8C6bXvrU6OHQ@mail.gmail.com>
On 08/03/12, Ants Aasma (ants.aasma@eesti.ee) wrote:
> So regardless if the benchmark is a good representation of the target
> workload or not, it definitely isn't benchmarking the IO system.
At the risk of hijacking the thread I started, I'd be grateful for
comments on the following system IO results. Rather than using pgbench
(which Ants responded about above), this uses fio. Our workload is
several small databases totalling less than 40GB of disk space. The
proposed system has 48GB RAM, 2 * quad core E5620 @ 2.40GHz and 4 WD
Raptors behind an LSI SAS card. Is this IO respectable?
LSI MegaRAID SAS 9260-8i
Firmware: 12.12.0-0090
Kernel: 2.6.39.4
Hard disks: 4x WD6000BLHX
Test done on 256GB volume
BS = blocksize in bytes
RAID 10
--------------------------------------
Read sequential
BS MB/s IOPs
512 0129.26 264730.80
1024 0229.75 235273.40
4096 0363.14 092965.50
16384 0475.02 030401.50
65536 0472.79 007564.65
131072 0428.15 003425.20
--------------------------------------
Write sequential
BS MB/s IOPs
512 0036.08 073908.00
1024 0065.61 067192.60
4096 0170.15 043560.40
16384 0219.80 014067.57
65536 0240.05 003840.91
131072 0243.96 001951.74
--------------------------------------
Random read
BS MB/s IOPs
512 0001.50 003077.20
1024 0002.91 002981.40
4096 0011.59 002968.30
16384 0044.50 002848.28
65536 0156.96 002511.41
131072 0170.65 001365.25
--------------------------------------
Random write
BS MB/s IOPs
512 0000.53 001103.60
1024 0001.15 001179.20
4096 0004.43 001135.30
16384 0017.61 001127.56
65536 0061.39 000982.39
131072 0079.27 000634.16
--------------------------------------
--
Rory Campbell-Lange
rory@campbell-lange.net
Campbell-Lange Workshop
www.campbell-lange.net
0207 6311 555
3 Tottenham Street London W1T 2AF
Registered in England No. 04551928
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: rory@campbell-lange.net, ants.aasma@eesti.ee, mmoncure@gmail.com, cjames@emolecules.com, scott.marlowe@gmail.com
Subject: Re: Advice sought : new database server
In-Reply-To: <20120308132737.GA3411@campbell-lange.net>
* 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