Machine details | Scale factor | 10 | fill factor | 100 | |||
CPU | 8 core | update | 3 | shared buffers | 2GB | ||
OS | suse linux 10.3 | record size | 1800 | update size | 250 | ||
RAM | 24GB | threads | 8 | clients | 16 | ||
sync commit | off | fsync | off | ||||
CONFIGURATION | |||||||
Transactions per client | 10000 | 20000 | |||||
WAL LZ compression for UPDATE | |||||||
Recovery(sec) | Recovery(sec) | ||||||
Run1 | 103 | 204 | |||||
Run2 | 100 | 200 | |||||
Run3 | 92 | 165 | |||||
Avg | 98.33333333 | 189.6666667 | |||||
Original code | |||||||
Recovery(sec) | Recovery(sec) | ||||||
Run1 | 100 | 261 | |||||
Run2 | 92 | 270 | |||||
Run3 | 104 | 150 | |||||
Avg | 98.66666667 | 227 | |||||
DIFF | |||||||
0.34% | 16.45% | ||||||