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