| Machine details | Base records | 1000000 | 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 | |||||
| auto vacuum | off | wal page size | 1K | |||||||
| ckpt seg | 256 | ckpt interval | 15min | |||||||
| sync commit | off | |||||||||
| Random string | ||||||||||
| fill factor | 100 | |||||||||
| pgbench | Original code | Wal Modified code | Difference(%) | LZ code | Difference(%) | |||||
| TPS | Total | TPS | Total | TPS | Total | TPS | Total | TPS | Total | |
| Run1 | 905 | 545253 | 1395 | 838421 | 54.14365 | 53.76733 | 1446 | 870938 | 59.77900552 | 59.73099 |
| Run2 | 995 | 598687 | 1455 | 874202 | 46.23116 | 46.01987 | 1441 | 865342 | 44.8241206 | 44.53997 |
| Run3 | 1003 | 602998 | 1386 | 834458 | 38.18544 | 38.38487 | 1485 | 892966 | 48.0558325 | 48.08772 |
| Avg | 967.6667 | 582312.7 | 1412 | 849027 | 46.18675 | 46.05736 | 1457.333333 | 876415.3 | 50.88631954 | 50.78623 |
| fill factor | 80 | |||||||||
| pgbench | Original code | Wal Modified code | Difference(%) | LZ code | Difference(%) | |||||
| TPS | Total | TPS | Total | TPS | Total | TPS | Total | TPS | Total | |
| Run1 | 1302 | 781997 | 2234 | 1342166 | 71.58218 | 71.63314 | 2319 | 1392679 | 78.11059908 | 78.09263 |
| Run2 | 1434 | 861746 | 2829 | 1699465 | 97.28033 | 97.21182 | 3134 | 1882053 | 118.5495119 | 118.4 |
| Run3 | 1497 | 899952 | 2280 | 1373820 | 52.30461 | 52.65481 | 2003 | 1209520 | 33.8009352 | 34.39828 |
| Avg | 1411 | 847898.3 | 2447.667 | 1471817 | 73.72238 | 73.83326 | 2485.333333 | 1494751 | 76.82034871 | 76.96363 |