|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Fixed string |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fill factor |
100 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pgbench |
old code |
Modified code |
Difference(%) |
LZ code |
Difference(%) |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
Run1 |
912 |
549078 |
1493 |
896713 |
63.70614 |
63.3125 |
1457 |
875289 |
59.75877193 |
59.41068 |
Run2 |
947 |
569253 |
1536 |
925954 |
62.19641 |
62.66124 |
1362 |
819956 |
43.82259768 |
44.0407 |
Run3 |
1023 |
615215 |
1533 |
922978 |
49.85337 |
50.02528 |
1326 |
796615 |
29.61876833 |
29.48563 |
Avg |
960.6667 |
577848.7 |
1520.667 |
915215 |
58.58531 |
58.66634 |
1381.666667 |
830620 |
44.40004598 |
44.31234 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fill factor |
80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pgbench |
old code |
Modified code |
Difference(%) |
LZ code |
Difference(%) |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
Run1 |
1247 |
750005 |
2730 |
1646096 |
118.9254 |
119.478 |
3373 |
2028472 |
170.489174 |
170.4611 |
Run2 |
1373 |
825262 |
2860 |
1720464 |
108.303 |
108.4749 |
2677 |
1612746 |
94.97450838 |
95.4223 |
Run3 |
1564 |
939670 |
2993 |
1799345 |
91.36829 |
91.4869 |
3155 |
1893968 |
101.7263427 |
101.5567 |
Avg |
1394.667 |
838312.3 |
2861 |
1721968 |
106.1989 |
106.4799 |
3068.333333 |
1845062 |
122.396675 |
122.48 |
|
|
|
|
|
|
|
|
|
|
|