| 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 LZ code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |||
| Run1 | 1596 | 1.43 | 3027 | 1.82 | 6144 | 2.65 | ||
| Run2 | 1597 | 1.43 | 3057 | 1.83 | 6025 | 2.64 | ||
| Run3 | 1599 | 1.43 | 3054 | 1.83 | 6132 | 2.65 | ||
| Avg | 1597.333333 | 1.43 | 3046 | 1.83 | 6100.333 | 2.65 | ||
| Head code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |||
| Run1 | 1606 | 1.48 | 3099 | 1.93 | 6066 | 2.85 | ||
| Run2 | 1606 | 1.48 | 3052 | 1.93 | 6110 | 2.85 | ||
| Run3 | 1604 | 1.47 | 3074 | 1.93 | 6002 | 2.85 | ||
| Avg | 1605.333333 | 1.48 | 3075 | 1.93 | 6059.333 | 2.85 | ||
| DIFF | ||||||||
| -0.50% | -3.16% | -0.94% | -5.35% | 0.68% | -7.13% | |||
| Pgbench - 250 | ||||||||
| CONFIGURATION | ||||||||
| Clients | 1 | 2 | 4 | |||||
| WAL LZ code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |||
| Run1 | 1592 | 2.43 | 3059 | 2.95 | 6097 | 3.78 | ||
| Run2 | 1591 | 2.43 | 3053 | 2.95 | 6101 | 3.78 | ||
| Run3 | 1588 | 2.43 | 3081 | 2.95 | 6003 | 3.77 | ||
| Avg | 1590.333333 | 2.43 | 3064.333333 | 2.95 | 6067 | 3.78 | ||
| Head code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |||
| Run1 | 1592 | 2.56 | 3039 | 3.24 | 5745 | 5.84 | ||
| Run2 | 1595 | 2.56 | 3061 | 3.24 | 5700 | 5.81 | ||
| Run3 | 1591 | 2.56 | 3074 | 3.24 | 5752 | 5.84 | ||
| Avg | 1592.666667 | 2.56 | 3058 | 3.24 | 5732.333 | 5.83 | ||
| DIFF | ||||||||
| -0.15% | -5.08% | 0.21% | -8.95% | 5.84% | -35.22% | |||
| Pgbench - 500 | ||||||||
| CONFIGURATION | ||||||||
| Clients | 1 | 2 | 4 | |||||
| WAL LZ code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |||
| Run1 | 1566 | 3.60 | 2255 | 4.96 | 2527 | 5.66 | ||
| Run2 | 1561 | 3.59 | 2245 | 4.95 | 2554 | 5.79 | ||
| Run3 | 1564 | 3.60 | 2227 | 4.93 | 2540 | 5.73 | ||
| Avg | 1563.666667 | 3.60 | 2242.333333 | 4.95 | 2540.333 | 5.73 | ||
| Head code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |||
| Run1 | 1569 | 3.80 | 2050 | 5.23 | 2540 | 6.46 | ||
| Run2 | 1567 | 3.80 | 1976 | 4.94 | 2408 | 6.12 | ||
| Run3 | 1568 | 3.80 | 2011 | 5.11 | 2489 | 6.34 | ||
| Avg | 1568 | 3.80 | 2012.333333 | 5.09 | 2479 | 6.31 | ||
| DIFF | ||||||||
| -0.28% | -5.35% | 11.43% | -2.88% | 2.47% | -9.20% | |||
| 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 LZ code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |||
| Run1 | 1483 | 3.23 | 2776 | 4.52 | 4952 | 7.34 | ||
| Run2 | 1478 | 3.23 | 2722 | 4.27 | 5299 | 7.50 | ||
| Run3 | 1483 | 3.23 | 2840 | 4.53 | 5073 | 7.40 | ||
| Avg | 1481.333333 | 3.23 | 2779.333333 | 4.44 | 5108 | 7.41 | ||
| Head code | ||||||||
| TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | TPS | Xlog Diff (GB) | |||
| Run1 | 1486 | 3.66 | 2415 | 6.14 | 4023 | 9.75 | ||
| Run2 | 1484 | 3.66 | 2359 | 6.02 | 4055 | 9.82 | ||
| Run3 | 1480 | 3.65 | 2346 | 6.02 | 3999 | 9.74 | ||
| Avg | 1483.333333 | 3.66 | 2373.333333 | 6.06 | 4025.667 | 9.77 | ||
| DIFF | ||||||||
| -0.13% | -11.67% | 17.11% | -26.73% | 26.89% | -24.12% | |||