Machine details
CPU 4 core
OS suse linux 10.3
RAM 24GB
Base records 1000000 record size 1800
update 3 shared buffers 4GB
auto vacuum off wal_buffers 16MB
ckpt seg 256 ckpt interval 15min
server_encoding SQL_ASCII client_encoding UTF8
lc_collate C lc_ctype C
sync commit off Fill factor 80
Update rec length 250    
CONFIGURATION
Clients 1 2 4 8
WAL Memcmp with org LZ for UPDATE + XLOG scale code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 812 2.32 1683 3.35 3213 6.01 5357 9.16
Run2 802 2.31 1684 3.35 3221 5.98 5286 9.08
Run3 873 2.43 1687 3.35 3237 6.00 5333 9.15
Avg 829 2.35 1684.666667 3.35 3223.667 6.00 5325.333 9.13
XLOG Scale code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 805 4.01 1492 7.46 2191 10.98 2718 13.69
Run2 794 3.95 1409 7.10 2167 10.88 2702 13.58
Run3 836 4.20 1465 7.35 2086 10.51 2692 13.54
Avg 811.6666667 4.05 1455.333333 7.30 2148 10.79 2704 13.60
DIFF
2.14% -41.94% 15.76% -54.13% 50.08% -44.42% 96.94% -32.88%
CONFIGURATION
Clients 1 2 4 8
WAL memcmp with mod LZ for UPDATE + XLOG scale code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 802 2.27 1652 3.24 3261 5.78 5449 8.81
Run2 802 2.27 1617 3.21 3268 5.80 5487 8.83
Run3 801 2.27 1704 3.29 3262 5.75 5529 8.93
Avg 801.6666667 2.27 1657.666667 3.25 3263.667 5.78 5488.333 8.86
XLOG Scale code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 805 4.01 1492 7.46 2191 10.98 2718 13.69
Run2 794 3.95 1409 7.1 2167 10.88 2702 13.58
Run3 836 4.2 1465 7.35 2086 10.51 2692 13.54
Avg 811.6666667 4.05 1455.333333 7.30 2148 10.79 2704 13.60
DIFF
-1.23% -44.00% 13.90% -55.55% 51.94% -46.46% 102.97% -34.89%