dbt2 NOTPM numbers
От | Markus Schiltknecht |
---|---|
Тема | dbt2 NOTPM numbers |
Дата | |
Msg-id | 466428F7.5010808@bluegap.ch обсуждение исходный текст |
Ответы |
Re: dbt2 NOTPM numbers
|
Список | pgsql-performance |
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
В списке pgsql-performance по дате отправления: