Delivery-Date: Fri, 24 Sep 93 17:42:41 PDT
Resent-From: postman (POSTGRES mailing list)
Resent-Message-Id: <9309250038.AA29594@postgres.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
Date: Fri, 24 Sep 93 17:39:47 -0700
From: verghese@pepper.stanford.edu (Ben Verghese)
Message-Id: <9309250039.AA12447@pepper.Stanford.EDU>
To: postgres@postgres.berkeley.edu
Subject: benchmark (AGAIN)
Resent-To: postgres-dist
Resent-Date: Fri, 24 Sep 93 17:38:23 PDT


Whoops! I forgot the numbers last time

I am trying to port POSTGRES 4.1 to an SGI system. I ran the Wisconsin
benchmark test and got a bunch of numbers. I have got a handbook that explains
what the tests are. I do not care much about the actual numbers. However, to
view them in some kind of perspective, it would be useful to have another set
of numbers to compare with. 

Does someone have or know where to obtain the similar numbers for some other
DB system, preferably a commercial one ?

Also, are programs or scripts for the TPC benchmarks available to try on
POSTGRES ?

I have appended the numbers from my run.

thanks,

	ben


********************************************************************************
Ben Verghese				Ph: 	(415) 723-4388 (office)
Computer Systems Lab				(415) 725-3732 (lab)
Electrical Engineering Dept.		Email:	verghese@pepper.stanford.edu
Stanford University
****************************************************************************************************************************************************************


query  0:   0.020 real   0.000 user   0.020 sys
query  1:   3.060 real   1.560 user   1.370 sys
query  2:  10.880 real   5.350 user   4.060 sys
query  3:   2.440 real   1.330 user   0.980 sys
query  4:  10.700 real   5.120 user   4.280 sys
query  5:   3.750 real   1.480 user   1.440 sys
query  6:   6.870 real   4.370 user   2.190 sys
query  7:   0.230 real   0.140 user   0.080 sys
query  8:   1.790 real   1.340 user   0.200 sys
query  9:  18.510 real  13.200 user   4.220 sys
query 10:  53.771 real  35.400 user  14.050 sys
query 11:  39.331 real  25.500 user  11.290 sys
query 12:  16.010 real  10.940 user   4.220 sys
query 13:  51.921 real  35.990 user  14.000 sys
query 14:  35.001 real  22.800 user  11.240 sys
query 15:  26.450 real  14.641 user   9.645 sys
query 16:  50.761 real  35.760 user  13.690 sys
query 17:  45.721 real  22.062 user  16.516 sys
query 18:  33.761 real  20.660 user  12.290 sys
query 19:   6.220 real   3.560 user   2.510 sys
query 20:  25.290 real  13.480 user  11.120 sys
query 21:   0.000 real   0.000 user   0.000 sys
query 22:   0.000 real   0.000 user   0.000 sys
query 23:  25.430 real  13.620 user  11.010 sys
query 24:   0.010 real   0.000 user   0.010 sys
query 25:   0.010 real   0.000 user   0.010 sys
query 26:   0.430 real   0.190 user   0.110 sys
query 27:   0.120 real   0.100 user   0.010 sys
query 28:   0.460 real   0.190 user   0.040 sys
query 29:   0.140 real   0.120 user   0.020 sys
query 30:   0.130 real   0.100 user   0.020 sys
query 31:   0.320 real   0.200 user   0.060 sys
query 32:   0.380 real   0.190 user   0.070 sys