|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Random string |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fill factor |
100 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pgbench |
Original code |
Wal Modified code |
Difference(%) |
LZ code |
Difference(%) |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
Run1 |
905 |
545253 |
1395 |
838421 |
54.14365 |
53.76733 |
1446 |
870938 |
59.77900552 |
59.73099 |
Run2 |
995 |
598687 |
1455 |
874202 |
46.23116 |
46.01987 |
1441 |
865342 |
44.8241206 |
44.53997 |
Run3 |
1003 |
602998 |
1386 |
834458 |
38.18544 |
38.38487 |
1485 |
892966 |
48.0558325 |
48.08772 |
Avg |
967.6667 |
582312.7 |
1412 |
849027 |
46.18675 |
46.05736 |
1457.333333 |
876415.3 |
50.88631954 |
50.78623 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
fill factor |
80 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
pgbench |
Original code |
Wal Modified code |
Difference(%) |
LZ code |
Difference(%) |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
TPS |
Total |
Run1 |
1302 |
781997 |
2234 |
1342166 |
71.58218 |
71.63314 |
2319 |
1392679 |
78.11059908 |
78.09263 |
Run2 |
1434 |
861746 |
2829 |
1699465 |
97.28033 |
97.21182 |
3134 |
1882053 |
118.5495119 |
118.4 |
Run3 |
1497 |
899952 |
2280 |
1373820 |
52.30461 |
52.65481 |
2003 |
1209520 |
33.8009352 |
34.39828 |
Avg |
1411 |
847898.3 |
2447.667 |
1471817 |
73.72238 |
73.83326 |
2485.333333 |
1494751 |
76.82034871 |
76.96363 |
|
|
|
|
|
|
|
|
|
|
|