Created
October 23, 2020 16:44
-
-
Save mdcallag/756eb6ae48a4b2b5b6503fe6aeea6c17 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --- Postgres 12.3, 20m rows loaded in l.i0 | |
| l.i0 | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 101523 0 0 0 43776 0.000 0.000 0.431 12578 46.7 0.124 18 1.9 5.2 0.0 0.009 101888 81114 pg123.cx4a | |
| 104167 0 0 0 44958 0.000 0.000 0.432 12559 42.8 0.121 16 1.9 5.2 0.0 0.002 104587 83469 pg123.cx4a | |
| l.x | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 157031 0 0 0 40427 0.000 0.000 0.257 1091 24.5 0.007 6 3.7 7.9 0.0 0.002 NA NA pg123.cx4a | |
| 168908 0 0 0 48456 0.000 0.000 0.287 960 24.6 0.006 6 3.7 7.9 0.0 0.002 NA NA pg123.cx4a | |
| l.i1 | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 27624 0 0 0 44185 0.000 0.000 1.599 6924 32.1 0.251 46 8.2 15.5 0.0 0.380 35461 1448 pg123.cx4a | |
| 28011 0 0 1 44538 0.000 0.000 1.590 7011 33.6 0.250 48 8.2 15.7 0.0 0.746 35961 1498 pg123.cx4a | |
| q100.2 | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 100 7758 0 0 3139 0.000 0.000 31.453 29879 27.0 3.851 139 8.2 12.5 0.0 0.013 7767 7671 pg123.cx4a | |
| 100 7642 0 0 3138 0.000 0.000 31.447 29417 29.2 3.850 153 8.2 12.6 0.0 0.004 7642 7512 pg123.cx4a | |
| q200.2 | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 200 7745 0 0 5545 0.000 0.000 27.782 29856 28.5 3.855 147 8.4 9.9 0.0 0.012 7751 7640 pg123.cx4a | |
| 200 7613 0 0 5556 0.000 0.000 27.835 29329 30.5 3.853 160 8.4 9.9 0.0 0.007 7624 7496 pg123.cx4a | |
| q400.2 | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 399 7723 0 0 9173 0.000 0.000 22.974 29842 30.8 3.864 160 8.8 10.4 0.0 0.019 7726 7608 pg123.cx4a | |
| 400 7610 0 0 9196 0.000 0.000 23.019 29373 32.1 3.860 169 8.8 10.4 0.0 0.007 7608 7480 pg123.cx4a | |
| q600.2 | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 599 7697 0 0 12239 0.000 0.000 20.432 29798 31.8 3.871 165 10.0 11.9 0.0 0.013 7704 7544 pg123.cx4a | |
| 599 7579 0 0 12242 0.000 0.000 20.438 29313 33.0 3.868 174 10.0 11.9 0.0 0.010 7592 7434 pg123.cx4a | |
| q800.2 | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 799 7705 7 59 14293 0.001 0.008 17.898 29878 32.0 3.878 166 11.3 13.4 0.0 0.013 7719 7560 pg123.cx4a | |
| 799 7601 8 66 14319 0.001 0.009 17.930 29456 33.0 3.875 174 11.3 13.4 0.0 0.005 7608 7435 pg123.cx4a | |
| q1000.2 | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 998 7715 0 1 15947 0.000 0.000 15.974 29947 32.8 3.882 170 12.0 14.3 0.0 0.013 7722 7544 pg123.cx4a | |
| 998 7607 0 1 15964 0.000 0.000 15.991 29510 33.8 3.879 178 12.0 14.3 0.0 0.008 7610 7416 pg123.cx4a | |
| --- MySQL 8.0.21, 20m rows loaded in l.i0 | |
| l.i0 | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 82645 0 0 0 24991 0.000 0.000 0.302 19385 42.6 0.235 21 1.3 10.9 2.5 0.109 83148 37350 my8021.cx1 | |
| 84034 0 0 0 25270 0.000 0.000 0.301 18792 40.6 0.224 19 1.3 10.9 2.5 0.117 84607 57122 my8021.cx1 | |
| l.x | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 145652 0 0 0 124663 0.000 0.000 0.856 8812 24.9 0.061 7 3.0 12.5 3.0 0.009 NA NA my8021.cx1 | |
| 157031 0 0 0 137841 0.000 0.000 0.878 9570 24.4 0.061 6 3.0 12.5 3.0 0.010 NA NA my8021.cx1 | |
| l.i1 | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 26738 0 99 1589 41510 0.004 0.059 1.552 16031 32.3 0.600 48 7.9 17.4 8.3 0.134 28319 549 my8021.cx1 | |
| 27100 0 105 1685 41251 0.004 0.062 1.522 16086 33.1 0.594 49 7.9 17.4 8.3 0.438 29076 400 my8021.cx1 | |
| q100.2 | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 100 6019 0 0 1227 0.000 0.000 12.299 23965 25.9 3.982 172 8.1 17.6 8.5 0.018 6026 5929 my8021.cx1 | |
| 100 6205 0 0 1240 0.000 0.000 12.420 24692 29.3 3.980 189 8.1 17.6 8.5 0.019 6217 6009 my8021.cx1 | |
| q200.2 | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 200 6087 0 0 1756 0.000 0.000 8.795 24316 26.0 3.995 171 8.4 17.9 8.8 0.012 6089 6009 my8021.cx1 | |
| 200 6321 0 0 1762 0.000 0.000 8.825 25213 29.3 3.989 185 8.4 17.9 8.8 0.020 6329 6140 my8021.cx1 | |
| q400.2 | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 399 6046 0 0 2047 0.000 0.000 5.128 24259 26.3 4.012 174 8.8 18.3 9.1 0.018 6057 5945 my8021.cx1 | |
| 399 6236 0 0 2044 0.000 0.000 5.119 24995 29.5 4.008 189 8.8 18.3 9.2 0.023 6249 6089 my8021.cx1 | |
| q600.2 | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 599 6033 0 0 2064 0.000 0.000 3.446 24304 26.6 4.028 176 9.0 18.6 9.4 0.007 6041 5961 my8021.cx1 | |
| 599 6257 0 0 2074 0.000 0.000 3.462 25151 29.5 4.019 189 9.0 18.6 9.4 0.017 6265 6105 my8021.cx1 | |
| q800.2 | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 799 5994 0 0 2935 0.000 0.000 3.675 24318 26.8 4.057 179 9.4 18.9 9.7 0.017 6009 5898 my8021.cx1 | |
| 799 6149 0 0 2927 0.000 0.000 3.663 24892 29.7 4.048 193 9.4 18.9 9.7 0.022 6153 5978 my8021.cx1 | |
| q1000.2 | |
| ips qps rps rkbps wkbps rpq rkbpq wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag | |
| 998 5957 0 0 3911 0.000 0.000 3.917 24349 26.9 4.088 181 10.0 19.6 10.3 0.021 5962 5836 my8021.cx1 | |
| 999 6161 0 0 3911 0.000 0.000 3.915 25096 30.0 4.073 195 10.0 19.6 10.3 0.021 6169 5993 my8021.cx1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
This test is an in-memory insert benchmark. Top number is from Ubuntu 18.04, bottom number is from Ubuntu 20.04. Tests used the same HW & same configs, but different compiler, toolchain & kernel. Versions for Ubuntu 18 & 20: