Message-ID: <466428F7.5010808@bluegap.ch>
Date: Mon, 04 Jun 2007 17:00:07 +0200
From: Markus Schiltknecht <markus@bluegap.ch>
User-Agent: Icedove 1.5.0.10 (X11/20070329)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: dbt2 NOTPM numbers
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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