| 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 | |||||||||
| Fixed string | ||||||||||
| fill factor | 100 | |||||||||
| pgbench | old code | Modified code | Difference(%) | LZ code | Difference(%) | |||||
| TPS | Total | TPS | Total | TPS | Total | TPS | Total | TPS | Total | |
| Run1 | 912 | 549078 | 1493 | 896713 | 63.70614 | 63.3125 | 1457 | 875289 | 59.75877193 | 59.41068 |
| Run2 | 947 | 569253 | 1536 | 925954 | 62.19641 | 62.66124 | 1362 | 819956 | 43.82259768 | 44.0407 |
| Run3 | 1023 | 615215 | 1533 | 922978 | 49.85337 | 50.02528 | 1326 | 796615 | 29.61876833 | 29.48563 |
| Avg | 960.6667 | 577848.7 | 1520.667 | 915215 | 58.58531 | 58.66634 | 1381.666667 | 830620 | 44.40004598 | 44.31234 |
| fill factor | 80 | |||||||||
| pgbench | old code | Modified code | Difference(%) | LZ code | Difference(%) | |||||
| TPS | Total | TPS | Total | TPS | Total | TPS | Total | TPS | Total | |
| Run1 | 1247 | 750005 | 2730 | 1646096 | 118.9254 | 119.478 | 3373 | 2028472 | 170.489174 | 170.4611 |
| Run2 | 1373 | 825262 | 2860 | 1720464 | 108.303 | 108.4749 | 2677 | 1612746 | 94.97450838 | 95.4223 |
| Run3 | 1564 | 939670 | 2993 | 1799345 | 91.36829 | 91.4869 | 3155 | 1893968 | 101.7263427 | 101.5567 |
| Avg | 1394.667 | 838312.3 | 2861 | 1721968 | 106.1989 | 106.4799 | 3068.333333 | 1845062 | 122.396675 | 122.48 |