| 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 |