From: Craig James <craig_james@emolecules.com>
To: pgsql-performance@postgresql.org
Subject: Benchmark: Dell/Perc 6, 8 disk RAID 10
Date: Wed, 12 Mar 2008 21:55:18 -0700
Message-ID: <47D8B3B6.3010606@emolecules.com> (raw)
In-Reply-To: <47D0AFC1.5070305@emolecules.com>
References: <f966c2ee0803052142l6a105678jfe2da92a0d9371@mail.gmail.com>
<f966c2ee0803052143k4570d771o6c300647d3b987d@mail.gmail.com>
<20080306060829.GA21084@a-kretschmer.de>
<bf54be870803052215y5bb56235k5ea05ada1d701022@mail.gmail.com>
<47CF8EA6.8070503@mark.mielke.cc>
<20080306063643.GB21084@a-kretschmer.de>
<f966c2ee0803052243w723e2866gbfc37128620d1c6d@mail.gmail.com>
<B94D3180-BB72-43EB-BA1E-90CF53705386@fastcrypt.com>
<f966c2ee0803060358k14dd7374h8ef3f4ca0818b04@mail.gmail.com>
<3E9C3A51-C28E-4B75-9739-E344DAC72880@fastcrypt.com>
<f966c2ee0803060443j3d9c1b66x5f59e00d084e841c@mail.gmail.com>
<Pine.GSO.4.64.0803060813570.11897@westnet.com>
<47D00DB2.7040007@emolecules.com>
<18451.1204824562@sss.pgh.pa.us>
<47D0AFC1.5070305@emolecules.com>
I just received a new server and thought benchmarks would be interesting. I think this looks pretty good, but maybe there are some suggestions about the configuration file. This is a web app, a mix of read/write, where writes tend to be "insert into ... (select ...)" where the resulting insert is on the order of 100 to 10K rows of two integers. An external process also uses a LOT of CPU power along with each query.
Thanks,
Craig
Configuration:
Dell 2950
8 CPU (Intel 2GHz Xeon)
8 GB memory
Dell Perc 6i with battery-backed cache
RAID 10 of 8x 146GB SAS 10K 2.5" disks
Everything (OS, WAL and databases) are on the one RAID array.
Diffs from original configuration:
max_connections = 1000
shared_buffers = 400MB
work_mem = 256MB
max_fsm_pages = 1000000
max_fsm_relations = 5000
wal_buffers = 256kB
effective_cache_size = 4GB
Bonnie output (slightly reformatted)
------------------------------------------------------------------------------
Delete files in random order...done.
Version 1.03
------Sequential Output------ --Sequential Input- --Random-
-Per Chr- --Block-- -Rewrite- -Per Chr- --Block-- --Seeks--
Size K/sec %CP K/sec %CP K/sec %CP K/sec %CP K/sec %CP /sec %CP
16G 64205 99 234252 38 112924 26 65275 98 293852 24 940.3 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 12203 95 +++++ +++ 19469 94 12297 95 +++++ +++ 15578 82
www.xxx.com,16G,64205,99,234252,38,112924,26,65275,98,293852,24,940.3,1,16,12203,95,+++++,+++,19469,94,12297,95,+++++,+++,15578,82
------------------------------------------------------------------------------
$ pgbench -c 10 -t 10000 -v test -U test
starting vacuum...end.
starting vacuum accounts...end.
transaction type: TPC-B (sort of)
scaling factor: 1
number of clients: 10
number of transactions per client: 10000
number of transactions actually processed: 100000/100000
tps = 2786.377933 (including connections establishing)
tps = 2787.888209 (excluding connections establishing)
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: craig_james@emolecules.com
Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
In-Reply-To: <47D8B3B6.3010606@emolecules.com>
* 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