|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Machine details |
|
|
|
|
|
|
Base records |
1000000 |
record size |
1800 |
|
|
CPU |
8 core |
|
|
|
|
|
update |
3 |
shared buffers |
2GB |
|
|
OS |
suse linux 10.3 |
|
|
|
|
|
auto vacuum |
off |
|
|
|
|
RAM |
24GB |
|
|
|
|
|
ckpt seg |
256 |
ckpt interval |
15min |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CONFIGURATION |
sync_commit |
off |
off |
off |
off |
off |
off |
on |
on |
on |
on |
on |
on |
thread |
8 |
8 |
1 |
1 |
2 |
2 |
8 |
8 |
1 |
1 |
2 |
2 |
fill
factor |
100 |
80 |
100 |
80 |
100 |
80 |
100 |
80 |
100 |
80 |
100 |
80 |
rec
length |
50 |
|
|
|
|
|
|
|
|
|
|
|
|
|
WAL LZ
compression for UPDATE + XLOG scale code |
|
|
|
|
|
|
|
|
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
Run1 |
2878 |
2827 |
1057 |
1140 |
1833 |
1818 |
420 |
430 |
137 |
141 |
152 |
167 |
Run2 |
2599 |
2798 |
1050 |
1026 |
1948 |
1738 |
411 |
434 |
135 |
137 |
154 |
156 |
Run3 |
2646 |
2759 |
1030 |
1016 |
1753 |
1718 |
413 |
435 |
138 |
137 |
154 |
158 |
Avg |
2707.666667 |
2794.667 |
1045.667 |
1060.667 |
1844.667 |
1758 |
414.6666667 |
433 |
136.6666667 |
138.3333 |
153.3333 |
160.3333 |
|
|
|
|
|
|
|
|
|
|
|
|
|
XLOG Scale code |
|
|
|
|
|
|
|
|
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
Run1 |
1079 |
1580 |
1042 |
1111 |
1515 |
1497 |
428 |
434 |
142 |
146 |
150 |
155 |
Run2 |
1340 |
1659 |
1045 |
1083 |
1384 |
1532 |
416 |
440 |
148 |
145 |
153 |
155 |
Run3 |
1492 |
1600 |
1028 |
1108 |
1458 |
1379 |
415 |
432 |
146 |
147 |
153 |
154 |
Avg |
1303.666667 |
1613 |
1038.333 |
1100.667 |
1452.333 |
1469.333 |
419.6666667 |
435.3333 |
145.3333333 |
146 |
152 |
154.6667 |
|
|
|
|
|
|
|
|
|
|
|
|
|
DIFF |
|
|
|
|
|
|
|
|
107.70% |
73.26% |
0.71% |
-3.63% |
27.01% |
19.65% |
-1.19% |
-0.54% |
-5.96% |
-5.25% |
0.88% |
3.66% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CONFIGURATION |
sync_commit |
off |
off |
off |
off |
off |
off |
on |
on |
on |
on |
on |
on |
thread |
8 |
8 |
1 |
1 |
2 |
2 |
8 |
8 |
1 |
1 |
2 |
2 |
fill
factor |
100 |
80 |
100 |
80 |
100 |
80 |
100 |
80 |
100 |
80 |
100 |
80 |
rec
length |
250 |
|
|
|
|
|
|
|
|
|
|
|
|
|
WAL LZ
compression for UPDATE + XLOG scale code |
|
|
|
|
|
|
|
|
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
Run1 |
2432 |
2455 |
651 |
634 |
1189 |
1257 |
414 |
443 |
127 |
129 |
151 |
155 |
Run2 |
2319 |
2541 |
648 |
648 |
1247 |
1246 |
412 |
431 |
129 |
131 |
153 |
155 |
Run3 |
2332 |
2498 |
683 |
708 |
1228 |
1193 |
412 |
438 |
128 |
129 |
182 |
156 |
Avg |
2361 |
2498 |
660.6667 |
663.3333 |
1221.333 |
1232 |
412.6666667 |
437.3333 |
128 |
129.6667 |
162 |
155.3333 |
|
|
|
|
|
|
|
|
|
|
|
|
|
XLOG Scale code |
|
|
|
|
|
|
|
|
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
Run1 |
1482 |
1471 |
729 |
754 |
1014 |
1098 |
422 |
431 |
133 |
136 |
151 |
154 |
Run2 |
1523 |
1532 |
747 |
775 |
1063 |
1113 |
419 |
443 |
134 |
137 |
152 |
171 |
Run3 |
1372 |
1609 |
729 |
753 |
1021 |
1086 |
410 |
441 |
134 |
134 |
161 |
154 |
Avg |
1459 |
1537.333 |
735 |
760.6667 |
1032.667 |
1099 |
417 |
438.3333 |
133.6666667 |
135.6667 |
154.6667 |
159.6667 |
|
|
|
|
|
|
|
|
|
|
|
|
|
DIFF |
|
|
|
|
|
|
|
|
61.82% |
62.49% |
-10.11% |
-12.80% |
18.27% |
12.10% |
-1.04% |
-0.23% |
-4.24% |
-4.42% |
4.74% |
-2.71% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CONFIGURATION |
sync_commit |
off |
off |
off |
off |
off |
off |
on |
on |
on |
on |
on |
on |
thread |
8 |
8 |
1 |
1 |
2 |
2 |
8 |
8 |
1 |
1 |
2 |
2 |
fill
factor |
100 |
80 |
100 |
80 |
100 |
80 |
100 |
80 |
100 |
80 |
100 |
80 |
rec
length |
500 |
|
|
|
|
|
|
|
|
|
|
|
|
|
WAL LZ
compression for UPDATE + XLOG scale code |
|
|
|
|
|
|
|
|
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
Run1 |
2362 |
2457 |
670 |
646 |
1174 |
1299 |
413 |
428 |
130 |
130 |
153 |
151 |
Run2 |
2387 |
2614 |
658 |
651 |
1224 |
1254 |
415 |
426 |
128 |
131 |
154 |
155 |
Run3 |
2276 |
2510 |
727 |
649 |
1268 |
1208 |
410 |
433 |
129 |
128 |
153 |
170 |
Avg |
2341.666667 |
2527 |
685 |
648.6667 |
1222 |
1253.667 |
412.6666667 |
429 |
129 |
129.6667 |
153.3333 |
158.6667 |
|
|
|
|
|
|
|
|
|
|
|
|
|
XLOG Scale code |
|
|
|
|
|
|
|
|
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
TPS |
Run1 |
1512 |
1499 |
728 |
789 |
1040 |
1138 |
424 |
431 |
130 |
135 |
151 |
154 |
Run2 |
1534 |
1498 |
746 |
773 |
1074 |
1098 |
419 |
430 |
132 |
134 |
152 |
180 |
Run3 |
1526 |
1530 |
739 |
821 |
1037 |
1116 |
411 |
427 |
136 |
134 |
153 |
154 |
Avg |
1524 |
1509 |
737.6667 |
794.3333 |
1050.333 |
1117.333 |
418 |
429.3333 |
132.6666667 |
134.3333 |
152 |
162.6667 |
|
|
|
|
|
|
|
|
|
|
|
|
|
DIFF |
|
|
|
|
|
|
|
|
53.65% |
67.46% |
-7.14% |
-18.34% |
16.34% |
12.20% |
-1.28% |
-0.08% |
-2.76% |
-3.47% |
0.88% |
-2.46% |
|
|
|
|
|
|
|
|
|
|
|
|
|