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 8
WAL Memcmp for UPDATE + XLOG scale code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 856 2.37 1721 3.31 5509 8.83
Run2 865 2.37 1729 3.31 5514 8.83
Run3 898 2.37 1663 3.25 5506 8.69
Avg 873 2.37 1704.333333 3.29 5509.667 8.78
XLOG Scale code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 830 4.16 1433 7.21 2729 13.75
Run2 829 4.16 1436 7.23 2676 13.45
Run3 845 4.31 1486 7.44 2700 13.62
Avg 834.6666667 4.21 1451.666667 7.29 2701.667 13.61
DIFF
4.59% -43.85% 17.41% -54.88% 103.94% -35.47%
CONFIGURATION
Clients 1 2 8
WAL LZ for UPDATE + XLOG scale code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 640 1.96 1284 2.84 4639 7.36
Run2 698 2.07 1281 2.84 4629 7.32
Run3 641 1.97 1263 2.82 4684 7.39
Avg 659.6666667 2.00 1276 2.83 4650.667 7.36
XLOG Scale code
  TPS Xlog Diff (GB) TPS Xlog Diff (GB) TPS Xlog Diff (GB)
Run1 830 4.16 1433 7.21 2729 13.75
Run2 829 4.16 1436 7.23 2676 13.45
Run3 845 4.31 1486 7.44 2700 13.62
Avg 834.6666667 4.21 1451.666667 7.29 2701.667 13.61
DIFF
-20.97% -52.53% -12.10% -61.14% 72.14% -45.94%