|
|
|
|
|
|
|
|
|
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% |
|
|
|
|
|
|
|
|
|
|
|