[HACKERS] pg_upgrade performance test

I run performance test on in-place patch prototype which I sent for review and I
got nice result:

Original:
---------
MQThL (Maximum Qualified Throughput LIGHT): 2202.12 tpm
MQThM (Maximum Qualified Throughput MEDIUM): 4706.60 tpm
MQThH (Maximum Qualified Throughput HEAVY): 3956.64 tpm

TRANSACTION MIX

Total number of transactions = 330457
TYPE TX. COUNT MIX
---- --------- ---
Light: 55053 16.66%
Medium: 117665 35.61%
DSS: 36825 11.14%
Heavy: 98916 29.93%
Connection: 21998 6.66%

RESPONSE TIMES AVG. MAX. 90TH

Light 0.093 1.080 0.400
Medium 0.096 1.663 0.400
DSS 0.092 0.990 0.020
Heavy 0.095 1.262 2.000
Connections 0.092 1.030 0.400
Number of users = 60
Sum of Avg. RT * TPS for all Tx. Types = 17.154543

pg_upgrade:
-----------
MQThL (Maximum Qualified Throughput LIGHT): 2185.16 tpm
MQThM (Maximum Qualified Throughput MEDIUM): 4674.04 tpm
MQThH (Maximum Qualified Throughput HEAVY): 3915.28 tpm

TRANSACTION MIX

Total number of transactions = 327811
TYPE TX. COUNT MIX
---- --------- ---
Light: 54629 16.66%
Medium: 116851 35.65%
DSS: 36367 11.09%
Heavy: 97882 29.86%
Connection: 22082 6.74%

RESPONSE TIMES AVG. MAX. 90TH

Light 0.095 1.073 0.400
Medium 0.098 1.167 0.400
DSS 0.093 1.049 0.010
Heavy 0.098 1.173 2.000
Connections 0.097 1.115 0.400
Number of users = 60
Sum of Avg. RT * TPS for all Tx. Types = 17.385362

--------------------------

It looks like it has only 1% performance gap. And good to mention that it is not
optimized version. It would be good if somebody will run different performance
test on it and verify my results.

I used iGen OLTP test with 60 concurrent users and run it for 30minutes.

Zdenek

--
Zdenek Kotala Sun Microsystems
Prague, Czech Republic http://sun.com/postgresql

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers