|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
50 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 |
1522 |
918988 |
2699 |
1623935 |
77.33246 |
76.70905 |
2552 |
1534038 |
67.67411301 |
66.92688 |
Run2 |
1496 |
902229 |
2501 |
1501300 |
67.17914 |
66.399 |
2553 |
1534329 |
70.65508021 |
70.05982 |
Run3 |
1530 |
920689 |
2916 |
1750731 |
90.58824 |
90.15444 |
2561 |
1537745 |
67.38562092 |
67.02111 |
Avg |
1516 |
913968.7 |
2705.333 |
1625322 |
78.36661 |
77.75416 |
2555.333333 |
1535371 |
68.57160471 |
68.0026 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fill factor |
80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pgbench |
old code |
Modified code |
Difference(%) |
LZ code |
Difference(%) |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
Run1 |
1405 |
843755 |
3009 |
1808003 |
114.1637 |
114.2806 |
2939 |
1764813 |
109.1814947 |
109.1618 |
Run2 |
1438 |
863822 |
3044 |
1832320 |
111.6829 |
112.1178 |
2704 |
1632143 |
88.03894298 |
88.94437 |
Run3 |
1336 |
804222 |
3078 |
1850127 |
130.3892 |
130.0518 |
2902 |
1747072 |
117.2155689 |
117.2375 |
Avg |
1393 |
837266.3 |
3043.667 |
1830150 |
118.7453 |
118.8167 |
2848.333333 |
1714676 |
104.8120022 |
105.1146 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
100 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 |
1507 |
911814 |
2463 |
1482359 |
63.43729 |
62.57252 |
2317 |
1394032 |
53.74917054 |
52.88557 |
Run2 |
1372 |
825130 |
2362 |
1418223 |
72.15743 |
71.87873 |
2757 |
1655922 |
100.9475219 |
100.6862 |
Run3 |
1491 |
895871 |
2793 |
1685273 |
87.32394 |
88.11559 |
2416 |
1450910 |
62.03890007 |
61.95524 |
Avg |
1456.666667 |
877605 |
2539.333 |
1528618 |
74.30622 |
74.18895 |
2496.666667 |
1500288 |
72.24519749 |
71.84233 |
|
|
|
|
|
|
|
|
|
|
|