|
|
|
|
|
|
|
|
|
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 |
1603 |
1.41 |
3065 |
1.79 |
6123 |
2.58 |
10407 |
3.72 |
Run2 |
1604 |
1.41 |
3040 |
1.80 |
6155 |
2.59 |
11873 |
4.91 |
Run3 |
1603 |
1.41 |
3046 |
1.80 |
6019 |
2.58 |
10275 |
3.68 |
Avg |
1603.333333 |
1.41 |
3050.333333 |
1.80 |
6099 |
2.58 |
10851.67 |
4.10 |
|
|
|
|
|
|
|
|
|
Head code |
|
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
Run1 |
1603 |
1.47 |
3048 |
1.93 |
6123 |
2.86 |
10290 |
5.03 |
Run2 |
1602 |
1.47 |
3046 |
1.93 |
6066 |
2.86 |
10952 |
5.31 |
Run3 |
1600 |
1.47 |
3040 |
1.93 |
6175 |
2.87 |
10308 |
5.04 |
Avg |
1601.666667 |
1.47 |
3044.666667 |
1.93 |
6121.333 |
2.86 |
10516.67 |
5.13 |
|
|
|
|
|
|
|
|
|
DIFF |
|
0.10% |
-4.08% |
0.19% |
-6.91% |
-0.36% |
-9.78% |
3.19% |
-19.96% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
1584 |
2.41 |
3078 |
2.91 |
6059 |
3.72 |
8337 |
6.10 |
Run2 |
1589 |
2.41 |
3042 |
2.92 |
6088 |
3.72 |
8007 |
5.87 |
Run3 |
1588 |
2.41 |
3101 |
2.91 |
6145 |
3.72 |
8028 |
5.87 |
Avg |
1587 |
2.41 |
3073.666667 |
2.91 |
6097.333 |
3.72 |
8124 |
5.95 |
|
|
|
|
|
|
|
|
|
Head code |
|
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
Run1 |
1584 |
2.55 |
3176 |
3.28 |
5331 |
5.27 |
7772 |
7.10 |
Run2 |
1585 |
2.55 |
3111 |
3.24 |
5331 |
5.21 |
7363 |
6.92 |
Run3 |
1586 |
2.55 |
3080 |
3.25 |
5334 |
5.24 |
7448 |
6.96 |
Avg |
1585 |
2.55 |
3122.333333 |
3.26 |
5332 |
5.24 |
7527.667 |
6.99 |
|
|
|
|
|
|
|
|
|
DIFF |
|
0.13% |
-5.49% |
-1.56% |
-10.54% |
14.35% |
-29.01% |
7.92% |
-14.97% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
1475 |
3.21 |
2729 |
4.21 |
3415 |
5.82 |
3970 |
6.58 |
Run2 |
1483 |
3.22 |
2847 |
4.49 |
3317 |
5.61 |
4061 |
6.66 |
Run3 |
1478 |
3.22 |
2869 |
4.55 |
3280 |
5.54 |
4136 |
6.74 |
Avg |
1478.666667 |
3.22 |
2815 |
4.42 |
3337.333 |
5.66 |
4055.667 |
6.66 |
|
|
|
|
|
|
|
|
|
Head code |
|
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
Run1 |
1462 |
3.63 |
1998 |
4.98 |
2338 |
6.01 |
3608 |
8.41 |
Run2 |
1483 |
3.66 |
2009 |
5.02 |
2434 |
6.15 |
3579 |
8.51 |
Run3 |
1484 |
3.66 |
2071 |
5.21 |
2472 |
6.26 |
2874 |
7.05 |
Avg |
1476.333333 |
3.65 |
2026 |
5.07 |
2414.667 |
6.14 |
3353.667 |
7.99 |
|
|
|
|
|
|
|
|
|
DIFF |
|
0.16% |
-11.87% |
38.94% |
-12.89% |
38.21% |
-7.87% |
20.93% |
-16.65% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
1745 |
2.98 |
3341 |
4.47 |
3752 |
5.75 |
Run2 |
888 |
2.18 |
1745 |
2.97 |
3297 |
4.63 |
3808 |
5.81 |
Run3 |
889 |
2.18 |
1742 |
2.97 |
3294 |
4.42 |
3806 |
5.79 |
Avg |
888 |
2.18 |
1744 |
2.97 |
3310.667 |
4.51 |
3788.667 |
5.78 |
|
|
|
|
|
|
|
|
|
Head code |
|
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
TPS |
Xlog Diff (GB) |
Run1 |
917 |
4.28 |
1207 |
5.72 |
1899 |
8.9 |
2073 |
9.77 |
Run2 |
922 |
4.29 |
1183 |
5.62 |
1908 |
8.89 |
2060 |
9.62 |
Run3 |
914 |
4.28 |
1198 |
5.67 |
1870 |
8.69 |
2099 |
9.80 |
Avg |
917.6666667 |
4.28 |
1196 |
5.67 |
1892.333 |
8.83 |
2077.333 |
9.73 |
|
|
|
|
|
|
|
|
|
DIFF |
|
-3.23% |
-49.11% |
45.82% |
-47.56% |
74.95% |
-48.94% |
82.38% |
-40.56% |
|
|
|
|
|
|
|
|
|