| 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 | 8 | ||||
| WAL PG LZ COMPRESS USING NEW DATA | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 1605 | 1.41 | 3080 | 1.79 | 6099 | 2.57 | 10143 | 3.65 |
| Run2 | 1603 | 1.41 | 3095 | 1.79 | 6154 | 2.58 | 10335 | 3.70 |
| Run3 | 1606 | 1.41 | 3095 | 1.79 | 6042 | 2.57 | 10362 | 3.70 |
| Avg | 1604.666667 | 1.41 | 3090 | 1.79 | 6098.333 | 2.57 | 10280 | 3.68 |
| Head code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 1605 | 1.48 | 3075 | 1.93 | 6111 | 2.86 | 10234 | 4.97 |
| Run2 | 1607 | 1.48 | 3121 | 1.93 | 6125 | 2.87 | 10383 | 5.09 |
| Run3 | 1604 | 1.48 | 3095 | 1.93 | 6118 | 2.86 | 10414 | 5.09 |
| Avg | 1605.333333 | 1.48 | 3097 | 1.93 | 6118 | 2.86 | 10343.67 | 5.05 |
| DIFF | ||||||||
| -0.04% | -4.73% | -0.23% | -7.25% | -0.32% | -10.13% | -0.62% | -27.06% | |
| Pgbench - 250 | ||||||||
| CONFIGURATION | ||||||||
| Clients | 1 | 2 | 4 | 8 | ||||
| WAL PG LZ COMPRESS USING NEW DATA | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 1596 | 2.42 | 3103 | 2.92 | 6093 | 3.70 | 9371 | 6.56 |
| Run2 | 1590 | 2.41 | 3066 | 2.92 | 6128 | 3.71 | 9319 | 6.53 |
| Run3 | 1595 | 2.42 | 3077 | 2.91 | 6104 | 3.71 | 9140 | 6.49 |
| Avg | 1593.666667 | 2.42 | 3082 | 2.92 | 6108.333 | 3.71 | 9276.667 | 6.53 |
| Head code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 1601 | 2.56 | 3110 | 3.25 | 5723 | 5.86 | 9271 | 7.70 |
| Run2 | 1595 | 2.56 | 3108 | 3.25 | 5811 | 5.89 | 9576 | 7.83 |
| Run3 | 1593 | 2.56 | 3084 | 3.25 | 5744 | 5.83 | 9377 | 7.75 |
| Avg | 1596.333333 | 2.56 | 3100.666667 | 3.25 | 5759.333 | 5.86 | 9408 | 7.76 |
| DIFF | ||||||||
| -0.17% | -5.60% | -0.60% | -10.26% | 6.06% | -36.75% | -1.40% | -15.89% | |
| 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 | 8 | ||||
| WAL PG LZ COMPRESS USING NEW DATA | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 1477 | 3.22 | 2896 | 4.72 | 4930 | 7.29 | 6730 | 8.52 |
| Run2 | 1478 | 3.22 | 2829 | 4.52 | 5120 | 7.38 | 6739 | 8.50 |
| Run3 | 1479 | 3.22 | 2820 | 4.53 | 4892 | 7.28 | 6879 | 8.80 |
| Avg | 1478 | 3.22 | 2848.333333 | 4.59 | 4980.667 | 7.32 | 6782.667 | 8.61 |
| Head code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 1493 | 3.67 | 2463 | 6.24 | 3771 | 9.05 | 4126 | 10.15 |
| Run2 | 1497 | 3.68 | 2316 | 5.93 | 3805 | 9.11 | 4150 | 10.06 |
| Run3 | 1492 | 3.67 | 2312 | 5.93 | 4090 | 9.92 | 5132 | 11.30 |
| Avg | 1494 | 3.67 | 2363.666667 | 6.03 | 3888.667 | 9.36 | 4469.333 | 10.50 |
| DIFF | ||||||||
| -1.07% | -12.34% | 20.50% | -23.92% | 28.08% | -21.83% | 51.76% | -18.06% | |
| 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 | off | Fill factor | 80 | |||||
| Pgbench - 1800 | ||||||||
| CONFIGURATION | ||||||||
| Clients | 1 | 2 | 4 | 8 | ||||
| WAL PG LZ COMPRESS USING NEW DATA | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 887 | 2.18 | 1734 | 2.97 | 3265 | 4.41 | 5602 | 7.32 |
| Run2 | 888 | 2.18 | 1737 | 2.97 | 3331 | 4.39 | 5769 | 7.42 |
| Run3 | 887 | 2.18 | 1745 | 2.98 | 3341 | 4.42 | 5590 | 7.37 |
| Avg | 887.3333333 | 2.18 | 1738.666667 | 2.97 | 3312.333 | 4.41 | 5653.667 | 7.37 |
| Head code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |
| Run1 | 922 | 4.31 | 1560 | 7.23 | 2244 | 10.43 | 3006 | 13.98 |
| Run2 | 918 | 4.28 | 1578 | 7.30 | 2218 | 10.32 | 2965 | 13.79 |
| Run3 | 917 | 4.27 | 1557 | 7.21 | 2245 | 10.44 | 2948 | 13.70 |
| Avg | 919 | 4.29 | 1565 | 7.25 | 2235.667 | 10.40 | 2973 | 13.82 |
| DIFF | ||||||||
| -3.45% | -49.14% | 11.10% | -58.97% | 48.16% | -57.61% | 90.17% | -46.68% | |