| Machine details | ||||||
| CPU | 8 core | |||||
| OS | suse linux 10.3 | |||||
| RAM | 24GB | |||||
| Server Configuration | ||||||
| sync commit | off | |||||
| shared buffers | 1GB | |||||
| ckpt segments | 256 | |||||
| ckpt interval | 15Min | |||||
| Pgbench tcp_b benchmark suite | ||||||
| threads | 8 | |||||
| clients | 16 | |||||
| scale | 75 | |||||
| fill factor | 100 | |||||
| only update | No | |||||
| one record size | 120 bytes | |||||
| update column size | 4 bytes | |||||
| pgbench | old code | Modified code | Difference(%) | |||
| TPS | Total | TPS | Total | TPS | Total | |
| Run1 | 7290 | 4378475 | 8298 | 4984243 | 13.82716 | 13.83514 |
| Run2 | 7614 | 4571083 | 8815 | 5292404 | 15.77357 | 15.78009 |
| Run3 | 7797 | 4688831 | 8550 | 5156011 | 9.657561 | 9.963678 |
| Avg | 7567 | 4546130 | 8554.333 | 5144219 | 13.04788 | 13.15602 |