|
|
|
|
|
|
|
|
|
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 |
off |
Fill factor |
80 |
|
|
|
|
|
Run time |
300 sec |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pgbench - org |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CONFIGURATION |
|
|
|
|
|
|
|
|
Clients |
1 |
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
FPW
COMPRESS |
|
|
|
|
|
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
|
|
|
|
Run1 |
783 |
0.18 |
1831 |
0.39 |
|
|
|
|
Run2 |
825 |
0.20 |
1835 |
0.40 |
|
|
|
|
Run3 |
838 |
0.21 |
1865 |
0.40 |
|
|
|
|
Avg |
815.3333333 |
0.20 |
1843.666667 |
0.40 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Head code |
|
|
|
|
|
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
|
|
|
|
Run1 |
1000 |
0.95 |
2093 |
1.24 |
|
|
|
|
Run2 |
1008 |
0.96 |
2096 |
1.24 |
|
|
|
|
Run3 |
1026 |
0.97 |
2060 |
1.24 |
|
|
|
|
Avg |
1011.333333 |
0.96 |
2083 |
1.24 |
|
|
|
|
|
|
|
|
|
|
|
|
|
DIFF |
|
|
|
|
|
-19.38% |
-79.51% |
-11.49% |
-68.01% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
off |
Fill factor |
80 |
|
|
|
|
|
Run time |
300 sec |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pgbench - 1000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CONFIGURATION |
|
|
|
|
|
|
|
|
Clients |
1 |
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
FPW
COMPRESS |
|
|
|
|
|
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
|
|
|
|
Run1 |
741 |
0.17 |
1643 |
0.68 |
|
|
|
|
Run2 |
775 |
0.25 |
1681 |
0.75 |
|
|
|
|
Run3 |
820 |
0.31 |
1653 |
0.76 |
|
|
|
|
Avg |
778.6666667 |
0.24 |
1659 |
0.73 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Head code |
|
|
|
|
|
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
|
|
|
|
Run1 |
903 |
1.57 |
1915 |
2.78 |
|
|
|
|
Run2 |
983 |
1.70 |
1921 |
2.78 |
|
|
|
|
Run3 |
990 |
1.71 |
1975 |
2.84 |
|
|
|
|
Avg |
958.6666667 |
1.66 |
1937 |
2.80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
DIFF |
|
|
|
|
|
-18.78% |
-85.34% |
-14.35% |
-73.93% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
off |
Fill factor |
80 |
|
|
|
|
|
Run time |
900 sec |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pgbench - org |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CONFIGURATION |
|
|
|
|
|
|
|
|
Clients |
1 |
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
FPW
COMPRESS |
|
|
|
|
|
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
|
|
|
|
Run1 |
935 |
0.52 |
2038 |
1.08 |
|
|
|
|
Run2 |
1009 |
0.58 |
2027 |
1.09 |
|
|
|
|
Run3 |
1005 |
0.59 |
2011 |
1.09 |
|
|
|
|
Avg |
983 |
0.56 |
2025.333333 |
1.09 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Head code |
|
|
|
|
|
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
|
|
|
|
Run1 |
1029 |
1.41 |
2100 |
1.93 |
|
|
|
|
Run2 |
1084 |
1.44 |
2091 |
1.93 |
|
|
|
|
Run3 |
1082 |
1.44 |
2091 |
1.93 |
|
|
|
|
Avg |
1065 |
1.43 |
2094 |
1.93 |
|
|
|
|
|
|
|
|
|
|
|
|
|
DIFF |
|
|
|
|
|
-7.70% |
-60.61% |
-3.28% |
-43.70% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
off |
Fill factor |
80 |
|
|
|
|
|
Run time |
900 sec |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Pgbench - 1000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CONFIGURATION |
|
|
|
|
|
|
|
|
Clients |
1 |
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
FPW
COMPRESS |
|
|
|
|
|
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
|
|
|
|
Run1 |
858 |
0.77 |
1917 |
2.50 |
|
|
|
|
Run2 |
916 |
1.15 |
1883 |
2.47 |
|
|
|
|
Run3 |
920 |
1.23 |
1926 |
2.51 |
|
|
|
|
Avg |
898 |
1.05 |
1908.666667 |
2.49 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Head code |
|
|
|
|
|
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
|
|
|
|
Run1 |
989 |
3.62 |
1352 |
5.13 |
|
|
|
|
Run2 |
1028 |
3.72 |
1377 |
5.34 |
|
|
|
|
Run3 |
1045 |
3.76 |
1420 |
5.47 |
|
|
|
|
Avg |
1020.666667 |
3.70 |
1383 |
5.31 |
|
|
|
|
|
|
|
|
|
|
|
|
|
DIFF |
|
|
|
|
|
-12.02% |
-71.62% |
38.01% |
-53.07% |
|
|
|
|
|
|
|
|
|
|
|
|
|