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