FSM patch - performance test

Hi Heikki,

I finally performed iGen test. I used two v490 servers with 4 dual core SPARC
CPUs and 32GB RAM. I have only one disk and I did not performed any disk I/O
optimization. I tested 105 parallel connection and think time was 200ms.
See the result:

Original:
---------
Actual run/snap-shot time: 3004 sec

MQThL (Maximum Qualified Throughput LIGHT): 1458.76 tpm
MQThM (Maximum Qualified Throughput MEDIUM): 3122.44 tpm
MQThH (Maximum Qualified Throughput HEAVY): 2626.70 tpm

TRANSACTION MIX

Total number of transactions = 438133
TYPE TX. COUNT MIX
---- --------- ---
Light: 72938 16.65%
Medium: 156122 35.63%
DSS: 48516 11.07%
Heavy: 131335 29.98%
Connection: 29222 6.67%

RESPONSE TIMES AVG. MAX. 90TH

Light 0.541 3.692 0.800
Medium 0.542 3.702 0.800
DSS 0.539 3.510 0.040
Heavy 0.539 3.742 4.000
Connections 0.545 3.663 0.800
Number of users = 105
Sum of Avg. RT * TPS for all Tx. Types = 64.851454

New FSM implementation:
-----------------------
Actual run/snap-shot time: 3004 sec

MQThL (Maximum Qualified Throughput LIGHT): 1351.20 tpm
MQThM (Maximum Qualified Throughput MEDIUM): 2888.74 tpm
MQThH (Maximum Qualified Throughput HEAVY): 2428.90 tpm

TRANSACTION MIX

Total number of transactions = 405502
TYPE TX. COUNT MIX
---- --------- ---
Light: 67560 16.66%
Medium: 144437 35.62%
DSS: 45028 11.10%
Heavy: 121445 29.95%
Connection: 27032 6.67%

RESPONSE TIMES AVG. MAX. 90TH

Light 0.596 3.735 0.800
Medium 0.601 3.748 0.800
DSS 0.601 3.695 0.040
Heavy 0.597 3.725 4.000
Connections 0.599 3.445 0.800
Number of users = 105
Sum of Avg. RT * TPS for all Tx. Types = 66.419466

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

My conclusion is that new implementation is about 8% slower in OLTP workload.

Zdenek

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