From: Markus Schiltknecht <markus@bluegap.ch>
To: pgsql-performance@postgresql.org
Subject: dbt2 NOTPM numbers
Date: Mon, 04 Jun 2007 17:00:07 +0200
Message-ID: <466428F7.5010808@bluegap.ch> (raw)
Hi,
I'm currently playing with dbt2 and am wondering, if the results I'm
getting are reasonable. I'm testing a 2x Dual Core Xeon system with 4 GB
of RAM and 8 SATA HDDs attached via Areca RAID Controller w/ battery
backed write cache. Seven of the eight platters are configured as one
RAID6, one spare drive. That should leave five platters for distributing
read only accesses.
The NOTPM numbers I'm getting are suspiciously low, IMO, but maybe I'm
expecting too much. What do you think, is this reasonable or do I have
to twiddle with the configuration somewhat more?
Regards
Markus
Here are my results:
Response Time (s)
Transaction % Average : 90th % Total
Rollbacks %
------------ ----- --------------------- ----------- ---------------
-----
Delivery 3.83 549.046 : 595.280 1212
0 0.00
New Order 45.79 524.659 : 562.016 14494
151 1.05
Order Status 3.98 517.497 : 551.552 1261 0
0.00
Payment 42.50 514.562 : 550.383 13452
0 0.00
Stock Level 3.90 510.610 : 546.957 1236
0 0.00
------------ ----- --------------------- ----------- ---------------
-----
238.39 new-order transactions per minute (NOTPM)
59.5 minute duration
0 total unknown errors
529 second(s) ramping up
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: markus@bluegap.ch
Subject: Re: dbt2 NOTPM numbers
In-Reply-To: <466428F7.5010808@bluegap.ch>
* 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