| Machine details | ||||
| CPU | 4 core | |||
| OS | suse linux 11.2 | |||
| RAM | 24GB | |||
| Scale factor | 75 | shared buffers | 4GB | |
| auto vacuum | on | wal_buffers | 16MB | |
| ckpt seg | 256 | ckpt interval | 25min | |
| server_encoding | SQL_ASCII | client_encoding | UTF8 | |
| lc_collate | C | lc_ctype | C | |
| sync commit | on | Fill factor | 80 | |
| Run time | 300 sec | |||
| Pgbench - org | ||||
| CONFIGURATION | ||||
| Clients | 1 | 2 | ||
| FPW COMPRESS | ||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 130 | 0.04 | 163 | 0.05 |
| Run2 | 131 | 0.04 | 163 | 0.05 |
| Run3 | 134 | 0.04 | 163 | 0.05 |
| Avg | 131.6666667 | 0.04 | 163 | 0.05 |
| Head code | ||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 134 | 0.23 | 161 | 0.28 |
| Run2 | 149 | 0.26 | 160 | 0.27 |
| Run3 | 132 | 0.23 | 161 | 0.28 |
| Avg | 138.3333333 | 0.24 | 160.6666667 | 0.28 |
| DIFF | ||||
| -4.82% | -83.33% | 1.45% | -81.93% | |
| Scale factor | 30 | shared buffers | 4GB | |
| auto vacuum | on | wal_buffers | 16MB | |
| ckpt seg | 256 | ckpt interval | 25min | |
| server_encoding | SQL_ASCII | client_encoding | UTF8 | |
| lc_collate | C | lc_ctype | C | |
| sync commit | on | Fill factor | 80 | |
| Run time | 300 sec | |||
| Pgbench - 1000 | ||||
| CONFIGURATION | ||||
| Clients | 1 | 2 | ||
| FPW COMPRESS | ||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 128 | 0.02 | 163 | 0.04 |
| Run2 | 132 | 0.03 | 162 | 0.04 |
| Run3 | 126 | 0.03 | 163 | 0.05 |
| Avg | 128.6666667 | 0.03 | 162.6666667 | 0.04 |
| Head code | ||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 143 | 0.29 | 161 | 0.33 |
| Run2 | 131 | 0.27 | 160 | 0.33 |
| Run3 | 147 | 0.30 | 159 | 0.33 |
| Avg | 140.3333333 | 0.29 | 160 | 0.33 |
| DIFF | ||||
| -8.31% | -90.70% | 1.67% | -86.87% | |
| Scale factor | 75 | shared buffers | 4GB | |
| auto vacuum | on | wal_buffers | 16MB | |
| ckpt seg | 256 | ckpt interval | 25min | |
| server_encoding | SQL_ASCII | client_encoding | UTF8 | |
| lc_collate | C | lc_ctype | C | |
| sync commit | on | Fill factor | 80 | |
| Run time | 900 sec | |||
| Pgbench - org | ||||
| CONFIGURATION | ||||
| Clients | 1 | 2 | ||
| FPW COMPRESS | ||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 138 | 0.11 | 162 | 0.14 |
| Run2 | 135 | 0.12 | 163 | 0.14 |
| Run3 | 136 | 0.12 | 162 | 0.14 |
| Avg | 136.3333333 | 0.12 | 162.3333333 | 0.14 |
| Head code | ||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 144 | 0.60 | 160 | 0.65 |
| Run2 | 141 | 0.59 | 161 | 0.65 |
| Run3 | 139 | 0.59 | 161 | 0.65 |
| Avg | 141.3333333 | 0.59 | 160.6666667 | 0.65 |
| DIFF | ||||
| -3.54% | -80.34% | 1.04% | -78.46% | |
| Scale factor | 30 | shared buffers | 4GB | |
| auto vacuum | on | wal_buffers | 16MB | |
| ckpt seg | 256 | ckpt interval | 25min | |
| server_encoding | SQL_ASCII | client_encoding | UTF8 | |
| lc_collate | C | lc_ctype | C | |
| sync commit | on | Fill factor | 80 | |
| Run time | 900 sec | |||
| Pgbench - 1000 | ||||
| CONFIGURATION | ||||
| Clients | 1 | 2 | ||
| FPW COMPRESS | ||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 137 | 0.09 | 162 | 0.17 |
| Run2 | 133 | 0.11 | 162 | 0.18 |
| Run3 | 134 | 0.13 | 162 | 0.19 |
| Avg | 134.6666667 | 0.11 | 162 | 0.18 |
| Head code | ||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 137 | 0.80 | 160 | 0.92 |
| Run2 | 137 | 0.80 | 160 | 0.92 |
| Run3 | 142 | 0.83 | 159 | 0.91 |
| Avg | 138.6666667 | 0.81 | 159.6666667 | 0.92 |
| DIFF | ||||
| -2.88% | -86.42% | 1.46% | -80.36% | |