|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Machine details |
|
|
|
|
|
Base records |
1000000 |
fill factor |
100 |
CPU |
8 core |
|
|
|
|
|
update |
3 |
shared buffers |
2GB |
OS |
suse linux 10.3 |
|
|
|
|
|
record size |
1800 |
update size |
250 |
RAM |
24GB |
|
|
|
|
|
threads |
8 |
clients |
16 |
|
|
|
|
|
|
|
auto vacuum |
off |
wal page size |
1K |
|
|
|
|
|
|
|
ckpt seg |
256 |
ckpt interval |
15min |
|
|
|
|
|
|
|
sync commit |
off |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
25 rec modified |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fill factor |
100 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pgbench |
old code |
Modified code |
Difference(%) |
LZ code |
Difference(%) |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
Run1 |
1052 |
632978 |
3129 |
1881618 |
197.4335 |
197.2644 |
2886 |
1732532 |
174.3346008 |
173.7113 |
Run2 |
1323 |
796077 |
3105 |
1865352 |
134.6939 |
134.318 |
2797 |
1679520 |
111.4134543 |
110.9746 |
Run3 |
1441 |
865620 |
2420 |
1455525 |
67.93893 |
68.14826 |
2915 |
1751611 |
102.2900763 |
102.3533 |
Avg |
1272 |
764891.7 |
2884.667 |
1734165 |
133.3554 |
133.2436 |
2866 |
1721221 |
129.3460438 |
129.0131 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
250 rec
modified |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fill factor |
100 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pgbench |
old code |
Modified code |
Difference(%) |
LZ code |
Difference(%) |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
Run1 |
955 |
575062 |
1960 |
1178170 |
105.2356 |
104.877 |
1820 |
1096420 |
90.57591623 |
90.66118 |
Run2 |
1244 |
748524 |
1789 |
1074469 |
43.81029 |
43.54503 |
2258 |
1355959 |
81.51125402 |
81.15104 |
Run3 |
1277 |
767560 |
2023 |
1216220 |
58.41817 |
58.45276 |
1731 |
1041800 |
35.55207518 |
35.7288 |
Avg |
1158.666667 |
697048.7 |
1924 |
1156286 |
69.15469 |
68.95828 |
1936.333333 |
1164726 |
69.21308181 |
69.18034 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fill factor |
80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pgbench |
old code |
Modified code |
Difference(%) |
LZ code |
Difference(%) |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
Run1 |
1397 |
838992 |
1826 |
1097152 |
30.70866 |
30.77026 |
2551 |
1532109 |
82.60558339 |
82.61306 |
Run2 |
1427 |
857736 |
2014 |
1209527 |
41.13525 |
41.0139 |
1841 |
1106736 |
29.0119131 |
29.02991 |
Run3 |
1455 |
875725 |
1752 |
1052514 |
20.41237 |
20.18773 |
1233 |
740915 |
-15.25773196 |
-15.3941 |
Avg |
1426.333333 |
857484.3 |
1864 |
1119731 |
30.75209 |
30.6573 |
1875 |
1126587 |
32.11992151 |
32.08296 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
500 rec
modified |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fill factor |
100 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pgbench |
old code |
Modified code |
Difference(%) |
LZ code |
Difference(%) |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
Run1 |
1332 |
805913 |
1548 |
932215 |
16.21622 |
15.67191 |
1531 |
920055 |
14.93993994 |
14.16307 |
Run2 |
1272 |
765067 |
1575 |
946006 |
23.82075 |
23.65009 |
2072 |
1244361 |
62.89308176 |
62.64732 |
Run3 |
1342 |
808297 |
1553 |
938699 |
15.7228 |
16.13293 |
1905 |
1146369 |
41.95230999 |
41.82522 |
Avg |
1315.333333 |
793092.3 |
1558.667 |
938973.3 |
18.58659 |
18.48498 |
1836 |
1103595 |
39.9284439 |
39.5452 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fill factor |
80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pgbench |
old code |
Modified code |
Difference(%) |
LZ code |
Difference(%) |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
Run1 |
1419 |
852014 |
1644 |
987417 |
15.85624 |
15.89211 |
1923 |
1158671 |
35.5179704 |
35.99201 |
Run2 |
1421 |
853443 |
1877 |
1128004 |
32.09008 |
32.17098 |
1965 |
1180287 |
38.28289937 |
38.29711 |
Run3 |
1244 |
747727 |
1795 |
1078304 |
44.2926 |
44.21092 |
1906 |
1151761 |
53.21543408 |
54.03496 |
Avg |
1361.333333 |
817728 |
1772 |
1064575 |
30.74631 |
30.758 |
1931.333333 |
1163573 |
42.33876795 |
42.7747 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1000 rec
modified |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fill factor |
100 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pgbench |
old code |
Modified code |
Difference(%) |
LZ code |
Difference(%) |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
Run1 |
1260 |
759221 |
1312 |
788026 |
4.126984 |
3.79402 |
1914 |
1152221 |
51.9047619 |
51.76358 |
Run2 |
1343 |
806782 |
1606 |
964715 |
19.58302 |
19.57567 |
2298 |
1380996 |
71.10945644 |
71.17338 |
Run3 |
1355 |
814641 |
1260 |
757542 |
-7.01107 |
-7.0091 |
2032 |
1219817 |
49.96309963 |
49.73676 |
Avg |
1319.333333 |
793548 |
1392.667 |
836761 |
5.566312 |
5.453531 |
2081.333333 |
1251011 |
57.65910599 |
57.55791 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fill factor |
80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pgbench |
old code |
Modified code |
Difference(%) |
LZ code |
Difference(%) |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
Run1 |
1494 |
901009 |
1291 |
776713 |
-13.5877 |
-13.7952 |
2265 |
1360739 |
51.6064257 |
51.02391 |
Run2 |
1298 |
779296 |
1436 |
864861 |
10.63174 |
10.97978 |
2648 |
1599097 |
104.0061633 |
105.1976 |
Run3 |
1276 |
769220 |
1388 |
836033 |
8.777429 |
8.685812 |
2639 |
1585012 |
106.8181818 |
106.0544 |
Avg |
1356 |
816508.3 |
1371.667 |
825869 |
1.940496 |
1.956798 |
2517.333333 |
1514949 |
87.47692362 |
87.42533 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1500 rec
modified |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fill factor |
100 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pgbench |
old code |
Modified code |
Difference(%) |
LZ code |
Difference(%) |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
Run1 |
1469 |
884250 |
1397 |
840249 |
-4.90129 |
-4.97608 |
2154 |
1295250 |
46.63036079 |
46.48007 |
Run2 |
1341 |
807125 |
1319 |
794074 |
-1.64057 |
-1.61697 |
2220 |
1332677 |
65.54809843 |
65.11408 |
Run3 |
1315 |
790567 |
1333 |
803342 |
1.368821 |
1.615929 |
1899 |
1142471 |
44.41064639 |
44.51286 |
Avg |
1375 |
827314 |
1349.667 |
812555 |
-1.72435 |
-1.65904 |
2091 |
1256799 |
52.19636854 |
52.03567 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fill factor |
80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pgbench |
old code |
Modified code |
Difference(%) |
LZ code |
Difference(%) |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
Run1 |
1262 |
759457 |
1405 |
845455 |
11.33122 |
11.32362 |
1935 |
1162712 |
53.32805071 |
53.09781 |
Run2 |
1401 |
841472 |
1443 |
866675 |
2.997859 |
2.995109 |
2177 |
1307238 |
55.38900785 |
55.35134 |
Run3 |
1460 |
877221 |
1374 |
827665 |
-5.89041 |
-5.6492 |
2010 |
1206939 |
37.67123288 |
37.58665 |
Avg |
1374.333333 |
826050 |
1407.333 |
846598.3 |
2.812889 |
2.889841 |
2040.666667 |
1225630 |
48.79609715 |
48.6786 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1800 rec
modified |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fill factor |
100 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pgbench |
old code |
Modified code |
Difference(%) |
LZ code |
Difference(%) |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
Run1 |
1074 |
647369 |
1151 |
691508 |
7.16946 |
6.818213 |
1393 |
836877 |
29.70204842 |
29.27357 |
Run2 |
1102 |
661962 |
1249 |
750318 |
13.33938 |
13.34759 |
1794 |
1078631 |
62.79491833 |
62.94455 |
Run3 |
1142 |
687185 |
1133 |
682783 |
-0.78809 |
-0.64058 |
1683 |
1012813 |
47.37302977 |
47.38578 |
Avg |
1106 |
665505.3 |
1177.667 |
708203 |
6.573584 |
6.508408 |
1623.333333 |
976107 |
46.62333217 |
46.53463 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fill factor |
80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pgbench |
old code |
Modified code |
Difference(%) |
LZ code |
Difference(%) |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
Run1 |
1284 |
774227 |
1343 |
806481 |
4.595016 |
4.165962 |
2035 |
1224481 |
58.48909657 |
58.1553 |
Run2 |
1431 |
861492 |
1557 |
935420 |
8.805031 |
8.581391 |
2506 |
1504579 |
75.1222921 |
74.64805 |
Run3 |
1455 |
873779 |
1322 |
794127 |
-9.14089 |
-9.11581 |
2372 |
1429792 |
63.02405498 |
63.63314 |
Avg |
1390 |
836499.3 |
1407.333 |
845342.7 |
1.419718 |
1.210516 |
2304.333333 |
1386284 |
65.54514789 |
65.47883 |
|
|
|
|
|
|
|
|
|
|
|