| Machine details | ||||||||
| CPU | 4 core | |||||||
| OS | suse linux 11.2 | |||||||
| RAM | 24GB | |||||||
| Scale factor | 75 | 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 | on | Fill factor | 80 | |||||
| Pgbench - org | ||||||||
| CONFIGURATION | ||||||||
| Clients | 1 | 2 | 4 | 8 | ||||
| WAL LZ code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 151 | 0.74 | 163 | 0.77 | 318 | 1.05 | 614 | 1.29 |
| Run2 | 147 | 0.73 | 162 | 0.77 | 318 | 1.05 | 613 | 1.29 |
| Run3 | 149 | 0.74 | 162 | 0.77 | 317 | 1.04 | 612 | 1.29 |
| Avg | 149 | 0.74 | 162.3333333 | 0.77 | 317.6667 | 1.05 | 613 | 1.29 |
| Head code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 148 | 0.74 | 163 | 0.77 | 318 | 1.06 | 614 | 1.32 |
| Run2 | 150 | 0.74 | 163 | 0.77 | 318 | 1.06 | 613 | 1.32 |
| Run3 | 149 | 0.74 | 162 | 0.77 | 317 | 1.06 | 611 | 1.32 |
| Avg | 149 | 0.74 | 162.6666667 | 0.77 | 317.6667 | 1.06 | 612.6667 | 1.32 |
| DIFF | ||||||||
| 0.00% | -0.45% | -0.20% | 0.00% | 0.00% | -1.26% | 0.05% | -2.27% | |
| Pgbench - 500 | ||||||||
| CONFIGURATION | ||||||||
| Clients | 1 | 2 | 4 | 8 | ||||
| WAL LZ code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 148 | 1.09 | 162 | 1.17 | 314 | 2.00 | 602 | 3.10 |
| Run2 | 145 | 1.06 | 162 | 1.17 | 315 | 2.01 | 602 | 3.10 |
| Run3 | 148 | 1.08 | 161 | 1.16 | 314 | 2.00 | 601 | 3.10 |
| Avg | 147 | 1.08 | 161.6666667 | 1.17 | 314.3333 | 2.00 | 601.6667 | 3.10 |
| Head code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 148 | 1.09 | 162 | 1.18 | 315 | 2.04 | 601 | 3.22 |
| Run2 | 148 | 1.09 | 162 | 1.18 | 314 | 2.04 | 601 | 3.23 |
| Run3 | 146 | 1.08 | 162 | 1.18 | 315 | 2.05 | 600 | 3.22 |
| Avg | 147.3333333 | 1.09 | 162 | 1.18 | 314.6667 | 2.04 | 600.6667 | 3.22 |
| DIFF | ||||||||
| -0.23% | -0.92% | -0.21% | -1.13% | -0.11% | -1.96% | 0.17% | -3.83% | |
| Machine details | ||||||||
| CPU | 4 core | |||||||
| OS | suse linux 11.2 | |||||||
| RAM | 24GB | |||||||
| Scale factor | 10 | 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 | on | Fill factor | 80 | |||||
| Pgbench - 1800 | ||||||||
| Update record - 250 | ||||||||
| columns update - 3 | ||||||||
| CONFIGURATION | ||||||||
| Clients | 1 | 2 | 4 | 8 | ||||
| WAL LZ code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 139 | 0.95 | 161 | 1.06 | 277 | 1.57 | 427 | 2.11 |
| Run2 | 140 | 0.96 | 160 | 1.06 | 277 | 1.57 | 427 | 2.11 |
| Run3 | 139 | 0.95 | 160 | 1.06 | 276 | 1.57 | 427 | 2.12 |
| Avg | 139.3333333 | 0.95 | 160.3333333 | 1.06 | 276.6667 | 1.57 | 427 | 2.11 |
| Head code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 139 | 1.50 | 160 | 1.69 | 269 | 2.65 | 411 | 3.78 |
| Run2 | 140 | 1.51 | 160 | 1.69 | 273 | 2.69 | 417 | 3.83 |
| Run3 | 141 | 1.52 | 160 | 1.69 | 273 | 2.69 | 417 | 3.83 |
| Avg | 140 | 1.51 | 160 | 1.69 | 271.6667 | 2.68 | 415 | 3.81 |
| DIFF | ||||||||
| -0.48% | -36.87% | 0.21% | -37.28% | 1.84% | -41.34% | 2.89% | -44.58% | |