| Machine details | ||||||
| CPU | 8 core | |||||
| OS | suse linux 10.3 | |||||
| RAM | 24GB | |||||
| Server Configuration | ||||||
| sync commit | off | |||||
| shared buffers | 2GB | |||||
| ckpt segments | 256 | |||||
| ckpt interval | 15Min | |||||
| Pgbench tcp_b benchmark suite | ||||||
| threads | 8 | |||||
| clients | 16 | |||||
| scale | 10 | |||||
| fill factor | 100 | |||||
| only update | yes | |||||
| one record size | 1800 bytes | |||||
| update column size | 300 bytes | |||||
| pgbench | old code | Modified code | Difference(%) | |||
| TPS | Total | TPS | Total | TPS | Total | |
| Run1 | 1751 | 1053397 | 3134 | 1884769 | 78.98344 | 78.92295 |
| Run2 | 1699 | 1020779 | 3191 | 1916461 | 87.81636 | 87.74495 |
| Run3 | 1786 | 1074239 | 3266 | 1963313 | 82.86674 | 82.76315 |
| Avg | 1745.333333 | 1049472 | 3197 | 1921514 | 83.17418 | 83.09349 |