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