| 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 | off | Fill factor | 80 | |||
| Pgbench - org | ||||||
| CONFIGURATION | ||||||
| Clients | 1 | 2 | 4 | |||
| WAL PG LZ Mod code | ||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 151 | 0.46 | 162 | 0.48 | 316 | 0.75 |
| Run2 | 149 | 0.46 | 162 | 0.48 | 316 | 0.76 |
| Run3 | 144 | 0.44 | 162 | 0.49 | 315 | 0.75 |
| Avg | 148 | 0.45 | 162 | 0.48 | 315.6667 | 0.75 |
| Head code | ||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 143 | 0.45 | 162 | 0.49 | 316 | 0.76 |
| Run2 | 152 | 0.46 | 162 | 0.49 | 316 | 0.76 |
| Run3 | 141 | 0.44 | 162 | 0.49 | 316 | 0.76 |
| Avg | 145.3333333 | 0.45 | 162 | 0.49 | 316 | 0.76 |
| DIFF | ||||||
| 1.83% | 0.74% | 0.00% | -1.36% | -0.11% | -0.88% | |
| Pgbench - org | ||||||
| CONFIGURATION | ||||||
| Clients | 1 | 2 | 4 | |||
| WAL PG LZ Roll 10 code | ||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 148 | 0.45 | 162 | 0.48 | 316 | 0.76 |
| Run2 | 141 | 0.44 | 162 | 0.49 | 316 | 0.76 |
| Run3 | 150 | 0.46 | 162 | 0.48 | 315 | 0.75 |
| Avg | 146.3333333 | 0.45 | 162 | 0.48 | 315.6667 | 0.76 |
| Head code | ||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 143 | 0.45 | 162 | 0.49 | 316 | 0.76 |
| Run2 | 152 | 0.46 | 162 | 0.49 | 316 | 0.76 |
| Run3 | 141 | 0.44 | 162 | 0.49 | 316 | 0.76 |
| Avg | 145.3333333 | 0.45 | 162 | 0.49 | 316 | 0.76 |
| DIFF | ||||||
| 0.69% | 0.00% | 0.00% | -1.36% | -0.11% | -0.44% | |
| Pgbench - 250 | ||||||
| CONFIGURATION | ||||||
| Clients | 1 | 2 | 4 | |||
| WAL PG LZ Mod code | ||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 151 | 0.52 | 162 | 0.56 | 314 | 0.97 |
| Run2 | 147 | 0.51 | 162 | 0.56 | 315 | 0.97 |
| Run3 | 149 | 0.52 | 161 | 0.55 | 314 | 0.97 |
| Avg | 149 | 0.52 | 161.6666667 | 0.56 | 314.3333 | 0.97 |
| Head code | ||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 146 | 0.51 | 162 | 0.56 | 314 | 0.98 |
| Run2 | 144 | 0.50 | 162 | 0.56 | 315 | 0.98 |
| Run3 | 152 | 0.53 | 162 | 0.56 | 315 | 0.98 |
| Avg | 147.3333333 | 0.51 | 162 | 0.56 | 314.6667 | 0.98 |
| DIFF | ||||||
| 1.13% | 0.65% | -0.21% | -0.60% | -0.11% | -1.02% | |
| Pgbench - 250 | ||||||
| CONFIGURATION | ||||||
| Clients | 1 | 2 | 4 | |||
| WAL PG LZ Roll 10 code | ||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 147 | 0.51 | 162 | 0.56 | 315 | 0.97 |
| Run2 | 149 | 0.52 | 161 | 0.55 | 314 | 0.97 |
| Run3 | 146 | 0.51 | 162 | 0.56 | 315 | 0.97 |
| Avg | 147.3333333 | 0.51 | 161.6666667 | 0.56 | 314.6667 | 0.97 |
| Head code | ||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 146 | 0.51 | 162 | 0.56 | 314 | 0.98 |
| Run2 | 144 | 0.50 | 162 | 0.56 | 315 | 0.98 |
| Run3 | 152 | 0.53 | 162 | 0.56 | 315 | 0.98 |
| Avg | 147.3333333 | 0.51 | 162 | 0.56 | 314.6667 | 0.98 |
| DIFF | ||||||
| 0.00% | 0.00% | -0.21% | -0.60% | 0.00% | -1.02% | |
| Machine details | ||||||
| CPU | 4 core | |||||
| OS | suse linux 11.2 | |||||
| RAM | 24GB | |||||
| Scale factor | 30 | 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 | off | Fill factor | 80 | |||
| Pgbench - 1000 | ||||||
| CONFIGURATION | ||||||
| Clients | 1 | 2 | 4 | |||
| WAL PG LZ Mod code | ||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 147 | 0.58 | 161 | 0.63 | 304 | 1.11 |
| Run2 | 143 | 0.57 | 161 | 0.63 | 306 | 1.11 |
| Run3 | 145 | 0.57 | 161 | 0.63 | 305 | 1.11 |
| Avg | 145 | 0.57 | 161 | 0.63 | 305 | 1.11 |
| Head code | ||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 142 | 0.57 | 161 | 0.64 | 300 | 1.12 |
| Run2 | 143 | 0.57 | 161 | 0.64 | 305 | 1.14 |
| Run3 | 148 | 0.59 | 161 | 0.64 | 304 | 1.14 |
| Avg | 144.3333333 | 0.58 | 161 | 0.64 | 303 | 1.13 |
| DIFF | ||||||
| 0.46% | -0.58% | 0.00% | -1.56% | 0.66% | -2.06% | |
| Pgbench - 1000 | ||||||
| CONFIGURATION | ||||||
| Clients | 1 | 2 | 4 | |||
| WAL PG LZ Roll 10 code | ||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 144 | 0.57 | 161 | 0.63 | 300 | 1.10 |
| Run2 | 146 | 0.58 | 161 | 0.63 | 305 | 1.11 |
| Run3 | 144 | 0.57 | 161 | 0.64 | 303 | 1.11 |
| Avg | 144.6666667 | 0.57 | 161 | 0.63 | 302.6667 | 1.11 |
| Head code | ||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 142 | 0.57 | 161 | 0.64 | 300 | 1.12 |
| Run2 | 143 | 0.57 | 161 | 0.64 | 305 | 1.14 |
| Run3 | 148 | 0.59 | 161 | 0.64 | 304 | 1.14 |
| Avg | 144.3333333 | 0.58 | 161 | 0.64 | 303 | 1.13 |
| DIFF | ||||||
| 0.23% | -0.58% | 0.00% | -1.04% | -0.11% | -2.35% | |