Subject: benchmark (AGAIN)

From: [email-masked] (Ben Verghese)
Date: Fri, 24 Sep 93 17:39:47 -0700

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:	[email-masked]
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

---

From: [email-masked] (Tom R.Hageman)
Date: Mon, 8 Nov 93 19:06:08 +0100

X-Organization: R&A

In message <[email-masked]>, [email-masked]  
(Ben Verghese) wrote:

> DB system, preferably a commercial one ?

Well, this is not quite what you requested, but for what it's worth, here are the  
benchmark totals for our NeXTSTEP port of postgres:

> SGI:           469.917 real 289.393 user 150.771 sys
NS/Black(33MHz): 237.749 real 138.837 user  34.95  sys
NS/FIP(66Mhz):   147.066 real 105.138 user  19.582 sys

> Also, are programs or scripts for the TPC benchmarks available to try on
Here is a nice little awk script to total the numbers:

  awk '{ r=r+$3; u=u+$5; s=s+$7; } 

       END { printf("%.3g real %.3g user %.3g sys\n", r, u, s); }'

> I have appended the numbers from my run.
So have I.

--
__/__/__/__/  Tom Hageman  ([email-masked])  [NeXTMail accepted]
  __/ __/_/
 __/__/__/
__/  _/_/           <space for quote intentionally left blank>

> query 32:   0.380 real   0.190 user   0.070 sys

NS/Black:
query  0:   0.114 real   0.000 user   0.016 sys
query  1:   4.235 real   0.859 user   0.203 sys
query  2:  11.473 real   2.938 user   3.423 sys
query  3:   1.216 real   0.782 user   0.078 sys
query  4:  10.268 real   2.781 user   3.468 sys
query  5:   2.612 real   0.844 user   0.547 sys
query  6:   3.334 real   2.562 user   0.375 sys
query  7:   0.160 real   0.125 user   0.016 sys
query  8:   1.303 real   1.062 user   0.172 sys
query  9:   9.169 real   7.186 user   0.563 sys
query 10:  14.483 real   9.781 user   0.688 sys
query 11:  17.059 real  13.936 user   0.859 sys
query 12:   9.321 real   7.312 user   0.703 sys
query 13:  11.903 real   9.796 user   0.579 sys
query 14:  16.971 real  13.827 user   0.891 sys
query 15:  29.397 real   8.282 user   7.924 sys
query 16:  12.511 real   9.562 user   0.876 sys
query 17:  41.092 real  15.016 user   9.645 sys
query 18:  16.091 real  12.249 user   1.782 sys
query 19:   2.943 real   2.203 user   0.469 sys
query 20:  10.155 real   8.374 user   0.782 sys
query 21:   0.006 real   0.000 user   0.000 sys
query 22:   0.006 real   0.000 user   0.000 sys
query 23:  10.323 real   8.516 user   0.719 sys
query 24:   0.006 real   0.000 user   0.016 sys
query 25:   0.006 real   0.016 user   0.000 sys
query 26:   0.331 real   0.125 user   0.000 sys
query 27:   0.144 real   0.031 user   0.016 sys
query 28:   0.336 real   0.187 user   0.047 sys
query 29:   0.104 real   0.047 user   0.031 sys
query 30:   0.081 real   0.094 user   0.000 sys
query 31:   0.293 real   0.188 user   0.031 sys
query 32:   0.303 real   0.156 user   0.031 sys

NS/FIP:
query  0:   0.069 real   0.000 user   0.000 sys
query  1:   0.806 real   0.651 user   0.060 sys
query  2:   5.194 real   2.306 user   1.786 sys
query  3:   0.632 real   0.429 user   0.092 sys
query  4:   4.842 real   2.110 user   1.850 sys
query  5:   1.968 real   0.549 user   0.352 sys
query  6:   2.189 real   1.821 user   0.179 sys
query  7:   0.102 real   0.080 user   0.010 sys
query  8:   1.017 real   0.881 user   0.040 sys
query  9:   7.608 real   6.540 user   0.381 sys
query 10:   7.455 real   6.439 user   0.371 sys
query 11:  12.534 real  11.070 user   0.389 sys
query 12:   7.962 real   6.480 user   0.363 sys
query 13:   7.219 real   6.443 user   0.358 sys
query 14:  12.596 real  10.920 user   0.491 sys
query 15:  15.804 real   7.390 user   4.524 sys
query 16:   8.416 real   6.343 user   0.422 sys
query 17:  21.754 real  11.928 user   5.640 sys
query 18:  11.313 real   8.836 user   1.136 sys
query 19:   2.007 real   1.522 user   0.159 sys
query 20:   7.361 real   5.891 user   0.469 sys
query 21:   0.005 real   0.010 user   0.010 sys
query 22:   0.004 real   0.000 user   0.000 sys
query 23:   7.290 real   5.909 user   0.410 sys
query 24:   0.004 real   0.000 user   0.000 sys
query 25:   0.005 real   0.010 user   0.010 sys
query 26:   0.150 real   0.080 user   0.020 sys
query 27:   0.056 real   0.050 user   0.000 sys
query 28:   0.217 real   0.120 user   0.020 sys
query 29:   0.057 real   0.060 user   0.000 sys
query 30:   0.054 real   0.050 user   0.010 sys
query 31:   0.184 real   0.110 user   0.020 sys
query 32:   0.192 real   0.110 user   0.010 sys