| From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | Markus Schiltknecht <markus(at)bluegap(dot)ch> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: dbt2 NOTPM numbers |
| Date: | 2007-06-04 15:09:39 |
| Message-ID: | 46642B33.6030101@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Markus Schiltknecht wrote:
> 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?
There's clearly something wrong. The response times are ridiculously
high, they should be < 5 seconds (except for stock level transaction) to
pass a TPC-C test. I wonder if you built any indexes at all?
The configuration I'm running here has 3 data drives, and I'm getting
reasonable results with ~100 warehouses, at ~1200 noTPM.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Schiltknecht | 2007-06-04 15:26:38 | Re: dbt2 NOTPM numbers |
| Previous Message | Markus Schiltknecht | 2007-06-04 15:00:07 | dbt2 NOTPM numbers |