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% |