Introduction
This is a report for the insert benchmark with 2000M docs and 8 client(s). It is generated by scripts (bash, awk, sed) and Tufte might not be impressed. An overview of the insert benchmark is here and a short update is here. Below, by DBMS, I mean DBMS+version.config. An example is my8020.c10b40 where my means MySQL, 8020 is version 8.0.20 and c10b40 is the name for the configuration file.
The test server has 24 cores, 2 sockets, 64G RAM and 1 NVMe devices. The benchmark was run with 8 clients and there were 1 or 3 connections per client (1 for queries or inserts without rate limits, 1+1 for rate limited inserts+deletes). It uses 8 tables with a table per client. It loads 250M rows per table without secondary indexes, creates 3 secondary indexes per table, then inserts 4m+1m rows per table with a delete per insert to avoid growing the table. It then does 6 read+write tests for 1800s each that do queries as fast as possible with 100,100,500,500,1000,1000 inserts/s and the same for deletes/s per client concurrent with the queries. The database is larger than RAM and most tests are IO-bound except for the range query (qr*) tests that frequently have a cached working set. Clients and the DBMS share one server.
The tested DBMS are:
- pg1222_o2nofp.cx10a_c24r64 - Postgres 12.22 with the cx10a_c24r64 config
- pg1322_o2nofp.cx10a_c24r64 - Postgres 13.22 with the cx10a_c24r64 config
- pg1419_o2nofp.cx10a_c24r64 - Postgres 14.19 with the cx10a_c24r64 config
- pg1515_o2nofp.cx10a_c24r64 - Postgres 15.15 with the cx10a_c24r64 config
- pg1611_o2nofp.cx10a_c24r64 - Postgres 16.11 with the cx10a_c24r64 config
- pg177_o2nofp.cx10a_c24r64 - Postgres 17.7 with the cx10a_c24r64 config
- pg181_o2nofp.cx10b_c24r64 - Postgres 18.1 with the cx10b_c24r64 config that uses io_method=sync
- pg181_o2nofp.cx10b_walsize_c24r64 - Postgres 18.1 with the cx10b_c24r64 config that uses io_method=sync and has min_wal_size == max_wal_size
Contents
- Summary
- l.i0: load without secondary indexes
- l.x: create secondary indexes
- l.i1: continue load after secondary indexes created with 50 inserts per transaction
- l.i2: continue load after secondary indexes created with 5 inserts per transaction
- qr100.L1: range queries with 100 insert/s per client
- qp100.L2: point queries with 100 insert/s per client
- qr500.L3: range queries with 500 insert/s per client
- qp500.L4: point queries with 500 insert/s per client
- qr1000.L5: range queries with 1000 insert/s per client
- qp1000.L6: point queries with 1000 insert/s per client
Summary
The numbers are inserts/s for l.i0, l.i1 and l.i2, indexed docs (or rows) /s for l.x and queries/s for qr100, qp100 thru qr1000, qp1000" The values are the average rate over the entire test for inserts (IPS) and queries (QPS). The range of values for IPS and QPS is split into 3 parts: bottom 25%, middle 50%, top 25%. Values in the bottom 25% have a red background, values in the top 25% have a green background and values in the middle have no color. A gray background is used for values that can be ignored because the DBMS did not sustain the target insert rate. Red backgrounds are not used when the minimum value is within 80% of the max value.
| dbms | l.i0 | l.x | l.i1 | l.i2 | qr100 | qp100 | qr500 | qp500 | qr1000 | qp1000 |
|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 732869 | 1116695 | 21108 | 1055 | 98999 | 4746 | 88678 | 4346 | 69060 | 3684 |
| pg1322_o2nofp.cx10a_c24r64 | 760746 | 1266624 | 18497 | 1572 | 98413 | 4853 | 88758 | 4088 | 68762 | 3561 |
| pg1419_o2nofp.cx10a_c24r64 | 715308 | 1273074 | 16913 | 911 | 99930 | 4907 | 90005 | 4262 | 69886 | 3462 |
| pg1515_o2nofp.cx10a_c24r64 | 766577 | 1201923 | 19150 | 1356 | 99308 | 4938 | 88998 | 4324 | 68585 | 3590 |
| pg1611_o2nofp.cx10a_c24r64 | 763359 | 1280410 | 14072 | 778 | 99811 | 4931 | 89279 | 4325 | 68220 | 3692 |
| pg177_o2nofp.cx10a_c24r64 | 732601 | 1398601 | 17335 | 1374 | 99508 | 4868 | 88716 | 4055 | 67324 | 3654 |
| pg181_o2nofp.cx10b_c24r64 | 752729 | 1356852 | 13457 | 1338 | 98949 | 4679 | 87743 | 4232 | 66129 | 3599 |
| pg181_o2nofp.cx10b_walsize_c24r64 | 735564 | 1379310 | 16763 | 1366 | 98374 | 4600 | 87870 | 4234 | 66887 | 3612 |
This table has relative throughput, throughput for the DBMS relative to the DBMS in the first line, using the absolute throughput from the previous table. Values less than 0.95 have a yellow background. Values greater than 1.05 have a blue background.
| dbms | l.i0 | l.x | l.i1 | l.i2 | qr100 | qp100 | qr500 | qp500 | qr1000 | qp1000 |
|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
| pg1322_o2nofp.cx10a_c24r64 | 1.04 | 1.13 | 0.88 | 1.49 | 0.99 | 1.02 | 1.00 | 0.94 | 1.00 | 0.97 |
| pg1419_o2nofp.cx10a_c24r64 | 0.98 | 1.14 | 0.80 | 0.86 | 1.01 | 1.03 | 1.01 | 0.98 | 1.01 | 0.94 |
| pg1515_o2nofp.cx10a_c24r64 | 1.05 | 1.08 | 0.91 | 1.29 | 1.00 | 1.04 | 1.00 | 0.99 | 0.99 | 0.97 |
| pg1611_o2nofp.cx10a_c24r64 | 1.04 | 1.15 | 0.67 | 0.74 | 1.01 | 1.04 | 1.01 | 1.00 | 0.99 | 1.00 |
| pg177_o2nofp.cx10a_c24r64 | 1.00 | 1.25 | 0.82 | 1.30 | 1.01 | 1.03 | 1.00 | 0.93 | 0.97 | 0.99 |
| pg181_o2nofp.cx10b_c24r64 | 1.03 | 1.22 | 0.64 | 1.27 | 1.00 | 0.99 | 0.99 | 0.97 | 0.96 | 0.98 |
| pg181_o2nofp.cx10b_walsize_c24r64 | 1.00 | 1.24 | 0.79 | 1.29 | 0.99 | 0.97 | 0.99 | 0.97 | 0.97 | 0.98 |
This lists the average rate of inserts/s for the tests that do inserts concurrent with queries. For such tests the query rate is listed in the table above. The read+write tests are setup so that the insert rate should match the target rate every second. Cells that are not at least 95% of the target have a red background to indicate a failure to satisfy the target.
| dbms | qr100.L1 | qp100.L2 | qr500.L3 | qp500.L4 | qr1000.L5 | qp1000.L6 |
|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 797 | 796 | 3982 | 3982 | 7969 | 7965 |
| pg1322_o2nofp.cx10a_c24r64 | 797 | 796 | 3982 | 3982 | 7965 | 7965 |
| pg1419_o2nofp.cx10a_c24r64 | 797 | 796 | 3982 | 3984 | 7969 | 7925 |
| pg1515_o2nofp.cx10a_c24r64 | 797 | 796 | 3982 | 3982 | 7965 | 7947 |
| pg1611_o2nofp.cx10a_c24r64 | 797 | 796 | 3982 | 3982 | 7965 | 7965 |
| pg177_o2nofp.cx10a_c24r64 | 796 | 796 | 3984 | 3984 | 7965 | 7965 |
| pg181_o2nofp.cx10b_c24r64 | 796 | 796 | 3984 | 3984 | 7969 | 7965 |
| pg181_o2nofp.cx10b_walsize_c24r64 | 797 | 796 | 3982 | 3982 | 7965 | 7960 |
| target | 800 | 800 | 4000 | 4000 | 8000 | 8000 |
l.i0
l.i0: load without secondary indexes. Graphs for performance per 1-second interval are here.
Average throughput:
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 1.996 | 97.979 | 0.018 | 0.006 | 0.001 | nonzero | 0.853 | ||||
| pg1322_o2nofp.cx10a_c24r64 | 50.802 | 49.146 | 0.038 | 0.013 | 0.001 | nonzero | 0.480 | ||||
| pg1419_o2nofp.cx10a_c24r64 | 1.207 | 98.690 | 0.085 | 0.017 | 0.001 | nonzero | 0.513 | ||||
| pg1515_o2nofp.cx10a_c24r64 | 50.270 | 49.701 | 0.017 | 0.009 | 0.002 | nonzero | 0.510 | ||||
| pg1611_o2nofp.cx10a_c24r64 | 40.486 | 59.483 | 0.023 | 0.007 | nonzero | nonzero | 0.438 | ||||
| pg177_o2nofp.cx10a_c24r64 | 22.625 | 77.254 | 0.082 | 0.037 | 0.002 | nonzero | 0.450 | ||||
| pg181_o2nofp.cx10b_c24r64 | 25.879 | 74.086 | 0.026 | 0.008 | nonzero | nonzero | 0.444 | ||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 29.595 | 70.296 | 0.068 | 0.039 | 0.001 | nonzero | 0.456 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 732869 0 552 4.6 3306.5 294.0 0.001 0.006 0.005 0.411 83811 52.3 0.114 17 191.4 255.4 48.7 0.853 92689 83089 pg1222_o2nofp.cx10a_c24r64 760746 0 535 4.6 2746.5 304.5 0.001 0.006 0.004 0.410 86721 53.3 0.114 17 191.4 255.4 3.1 0.480 96987 74892 pg1322_o2nofp.cx10a_c24r64 715308 0 505 3.9 2587.8 285.3 0.001 0.006 0.004 0.408 82621 51.4 0.116 17 191.4 255.4 7.7 0.513 92388 54692 pg1419_o2nofp.cx10a_c24r64 766577 0 548 4.3 2769.1 307.0 0.001 0.006 0.004 0.410 85692 52.9 0.112 17 191.4 255.4 2.1 0.510 96887 76287 pg1515_o2nofp.cx10a_c24r64 763359 0 539 4.2 2712.2 304.4 0.001 0.006 0.004 0.408 85359 52.8 0.112 17 191.4 255.4 4.0 0.438 96487 85490 pg1611_o2nofp.cx10a_c24r64 732601 0 525 4.2 2642.7 293.8 0.001 0.006 0.004 0.411 73216 51.1 0.100 17 191.4 255.4 48.6 0.450 94689 35694 pg177_o2nofp.cx10a_c24r64 752729 0 543 4.5 2699.7 301.9 0.001 0.006 0.004 0.411 74366 52.2 0.099 17 191.4 255.4 47.5 0.444 95788 83485 pg181_o2nofp.cx10b_c24r64 735564 0 527 4.2 2621.1 293.3 0.001 0.006 0.004 0.408 73505 51.3 0.100 17 191.4 255.4 48.5 0.456 94089 52690 pg181_o2nofp.cx10b_walsize_c24r64
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 552.2 4749.6 0.037 0.429 0.969 4.987 3306.5 301047 155.0 3.491 3.059 100.1 2.771 214.7 0.000 0.000 0.283 23.86 0.000 0.000 10.13 19.43 pg1222_o2nofp.cx10a_c24r64 535.3 4680.5 0.067 0.502 0.813 4.986 2746.5 311761 161.1 3.848 2.962 117.1 3.022 209.0 0.000 0.000 0.288 21.91 0.000 0.000 8.808 19.51 pg1322_o2nofp.cx10a_c24r64 504.6 4009.6 0.016 0.262 0.678 8.309 2587.8 292177 104.7 3.017 2.687 117.3 3.036 204.0 0.000 0.000 0.279 20.28 0.000 0.000 8.010 15.89 pg1419_o2nofp.cx10a_c24r64 548.3 4368.3 0.030 0.283 1.014 3.585 2769.1 314383 104.4 2.791 3.430 117.9 0.475 259.3 0.000 0.000 0.118 30.62 0.000 0.000 10.88 17.01 pg1515_o2nofp.cx10a_c24r64 539.1 4300.9 0.000 0.007 0.787 5.461 2712.2 311678 108.7 3.078 2.871 118.4 0.465 245.1 0.000 0.000 0.108 29.64 0.000 0.000 8.880 17.02 pg1611_o2nofp.cx10a_c24r64 525.2 4305.1 0.167 1.587 0.759 4.345 2642.7 300848 108.8 3.177 2.643 116.9 0.278 229.6 0.000 0.000 0.077 76.93 0.000 0.000 8.141 16.52 pg177_o2nofp.cx10a_c24r64 542.7 4650.1 0.044 0.272 0.807 4.648 2699.7 309127 115.3 3.341 2.814 117.6 0.297 198.8 0.000 0.000 0.082 78.35 0.000 0.000 8.605 16.96 pg181_o2nofp.cx10b_c24r64 527.3 4328.1 0.117 1.267 0.754 4.353 2621.1 300383 112.5 3.311 2.831 117.7 0.335 223.6 0.000 0.000 0.117 63.80 0.000 0.000 8.736 16.53 pg181_o2nofp.cx10b_walsize_c24r64
l.x
l.x: create secondary indexes.
Average throughput:
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 1116695 0 16532 383.9 5072.9 465.8 0.015 0.352 0.005 0.427 42875 24.5 0.038 5 384.4 448.4 18.6 0.003 NA NA pg1222_o2nofp.cx10a_c24r64 1266624 0 18842 418.3 3090.0 375.8 0.015 0.338 0.002 0.304 24624 26.2 0.019 5 384.2 448.3 39.0 0.003 NA NA pg1322_o2nofp.cx10a_c24r64 1273074 0 8691 379.0 3086.6 378.2 0.007 0.305 0.002 0.304 25395 26.4 0.020 5 384.2 448.3 11.0 0.004 NA NA pg1419_o2nofp.cx10a_c24r64 1201923 0 10124 493.4 3659.9 450.2 0.008 0.420 0.003 0.384 36605 25.5 0.030 5 384.2 448.3 38.7 0.003 NA NA pg1515_o2nofp.cx10a_c24r64 1280410 0 3475 381.2 3349.4 410.7 0.003 0.305 0.003 0.328 25129 25.8 0.020 5 384.2 448.3 38.3 0.003 NA NA pg1611_o2nofp.cx10a_c24r64 1398601 0 3297 366.8 3256.9 398.9 0.002 0.269 0.002 0.292 18321 26.4 0.013 5 384.2 448.3 34.5 0.003 NA NA pg177_o2nofp.cx10a_c24r64 1356852 0 7388 380.1 3150.0 385.3 0.005 0.287 0.002 0.291 20692 25.7 0.015 5 384.2 448.3 24.4 0.003 NA NA pg181_o2nofp.cx10b_c24r64 1379310 0 16362 435.9 3239.0 394.5 0.012 0.324 0.002 0.293 19756 26.1 0.014 5 384.2 448.3 37.8 0.003 NA NA pg181_o2nofp.cx10b_walsize_c24r64
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 16531.6 393134 0.052 0.002 0.209 60.47 5072.9 477029 103.1 1.946 14.67 112.6 4.600 100754 0.000 0.000 0.321 4210.3 0.000 0.000 55.83 66.87 pg1222_o2nofp.cx10a_c24r64 18842.3 428370 0.070 0.122 0.273 54.54 3090.0 384837 89.47 1.838 15.87 125.0 4.881 82838.8 0.000 0.000 0.385 1610.3 0.000 0.000 51.46 60.59 pg1322_o2nofp.cx10a_c24r64 8691.0 388087 0.000 0.000 0.328 65.29 3086.6 387320 59.31 1.211 16.24 125.8 5.256 99952.0 0.000 0.000 0.336 1550.9 0.000 0.000 51.39 57.38 pg1419_o2nofp.cx10a_c24r64 10123.9 505243 0.000 0.000 0.354 78.29 3659.9 460980 52.46 0.990 19.37 126.2 2.942 91718.4 0.000 0.000 0.313 2211.8 0.000 0.000 80.82 61.97 pg1515_o2nofp.cx10a_c24r64 3474.6 390308 0.003 0.000 0.425 105.3 3349.4 420564 58.49 1.361 18.87 125.8 2.885 92896.9 0.000 0.000 0.209 1485.7 0.000 0.000 73.73 53.46 pg1611_o2nofp.cx10a_c24r64 3296.7 375652 0.000 0.000 0.361 105.1 3256.9 408523 60.23 1.128 15.63 125.9 3.952 125949 0.000 0.000 0.254 1915.3 0.000 0.000 50.31 53.86 pg177_o2nofp.cx10a_c24r64 7387.9 389271 0.052 0.001 0.279 74.71 3150.0 394535 58.06 2.360 14.70 123.9 3.482 98580.5 0.000 0.000 0.280 1597.2 0.000 0.000 48.64 55.66 pg181_o2nofp.cx10b_c24r64 16361.5 446394 0.040 0.000 0.279 61.09 3239.0 403922 59.37 1.189 15.98 125.2 3.546 124266 0.000 0.000 0.237 1566.7 0.000 0.000 53.18 60.69 pg181_o2nofp.cx10b_walsize_c24r64
l.i1
l.i1: continue load after secondary indexes created with 50 inserts per transaction. Graphs for performance per 1-second interval are here.
Average throughput:
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 77.891 | 22.108 | 0.001 | 0.437 | |||||||
| pg1322_o2nofp.cx10a_c24r64 | 74.461 | 25.524 | 0.016 | 0.190 | |||||||
| pg1419_o2nofp.cx10a_c24r64 | 77.030 | 22.955 | 0.015 | 0.131 | |||||||
| pg1515_o2nofp.cx10a_c24r64 | 78.254 | 21.737 | 0.009 | nonzero | 0.262 | ||||||
| pg1611_o2nofp.cx10a_c24r64 | 83.109 | 16.878 | 0.012 | nonzero | 0.451 | ||||||
| pg177_o2nofp.cx10a_c24r64 | 82.874 | 17.118 | 0.008 | 0.093 | |||||||
| pg181_o2nofp.cx10b_c24r64 | 78.647 | 21.016 | 0.290 | 0.048 | nonzero | 2.409 | |||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 81.819 | 18.172 | 0.009 | 0.102 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 1.156 | 7.457 | 31.308 | 60.078 | 0.001 | 0.431 | |||||
| pg1322_o2nofp.cx10a_c24r64 | 1.190 | 8.650 | 28.205 | 61.948 | 0.006 | 0.111 | |||||
| pg1419_o2nofp.cx10a_c24r64 | 1.280 | 7.319 | 33.414 | 57.984 | 0.004 | 0.078 | |||||
| pg1515_o2nofp.cx10a_c24r64 | 1.144 | 6.970 | 26.148 | 65.733 | 0.004 | 0.244 | |||||
| pg1611_o2nofp.cx10a_c24r64 | 1.048 | 6.440 | 21.953 | 70.556 | 0.003 | 0.090 | |||||
| pg177_o2nofp.cx10a_c24r64 | 0.989 | 6.390 | 20.822 | 71.795 | 0.004 | 0.085 | |||||
| pg181_o2nofp.cx10b_c24r64 | 0.779 | 6.533 | 19.977 | 72.702 | 0.009 | 0.251 | |||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 0.846 | 6.246 | 20.996 | 71.907 | 0.006 | 0.093 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 21108 0 27194 213.7 31005.4 525.6 1.288 10.368 1.469 25.497 66369 40.7 3.144 463 389.6 453.7 48.7 0.437 2550 1700 pg1222_o2nofp.cx10a_c24r64 18497 0 24075 209.4 28262.6 474.4 1.302 11.592 1.528 26.262 59504 37.2 3.217 483 389.4 453.5 2.9 0.190 2500 1700 pg1322_o2nofp.cx10a_c24r64 16913 0 21542 171.7 25266.8 424.7 1.274 10.397 1.494 25.714 52698 33.9 3.116 481 389.5 453.5 1.6 0.131 2549 1700 pg1419_o2nofp.cx10a_c24r64 19150 0 24369 194.1 29067.4 482.7 1.272 10.381 1.518 25.809 59893 38.9 3.128 488 389.4 453.5 1.5 0.262 2450 1600 pg1515_o2nofp.cx10a_c24r64 14072 0 17921 142.8 21234.8 351.2 1.274 10.391 1.509 25.560 43360 32.8 3.081 559 389.4 453.5 48.6 0.451 2200 1550 pg1611_o2nofp.cx10a_c24r64 17335 0 22134 175.8 26716.9 437.1 1.277 10.384 1.541 25.818 53162 38.1 3.067 527 389.4 453.5 48.6 0.093 2150 1450 pg177_o2nofp.cx10a_c24r64 13457 0 17245 138.6 20272.2 340.2 1.282 10.548 1.506 25.891 42912 31.6 3.189 564 389.4 453.5 48.5 2.409 2050 700 pg181_o2nofp.cx10b_c24r64 16763 0 21580 171.6 25713.3 422.9 1.287 10.482 1.534 25.834 51339 37.7 3.063 540 389.4 453.5 48.6 0.102 2200 1550 pg181_o2nofp.cx10b_walsize_c24r64
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 27193.5 218855 0.000 0.000 0.149 8.047 31005.4 538203 197.4 1.042 0.857 21.06 2.060 1384.5 0.000 0.000 0.262 266.0 0.000 0.000 33.94 97.76 pg1222_o2nofp.cx10a_c24r64 24075.1 214426 0.025 0.000 0.156 8.971 28262.6 485770 197.4 0.880 0.849 20.46 2.063 324.7 0.000 0.000 0.264 97.12 0.000 0.000 32.12 92.75 pg1322_o2nofp.cx10a_c24r64 21542.0 175847 0.003 0.000 0.142 8.161 25266.8 434912 100.5 0.517 0.751 20.09 2.065 185.8 0.000 0.000 0.261 62.37 0.000 0.000 27.77 85.81 pg1419_o2nofp.cx10a_c24r64 24368.6 198789 0.001 0.000 0.148 8.165 29067.4 494245 116.1 0.481 0.812 19.92 0.056 258.8 0.000 0.000 0.029 256.5 0.000 0.000 29.93 95.87 pg1515_o2nofp.cx10a_c24r64 17921.3 146225 0.002 0.000 0.126 8.175 21234.8 359680 80.53 0.499 0.560 19.82 0.037 95.18 0.000 0.000 0.022 120.8 0.000 0.000 18.37 80.80 pg1611_o2nofp.cx10a_c24r64 22133.6 180005 0.002 0.000 0.136 8.146 26716.9 447549 98.81 0.449 0.688 19.74 0.028 143.2 0.000 0.000 0.014 198.2 0.000 0.000 24.12 92.97 pg177_o2nofp.cx10a_c24r64 17245.1 141946 0.208 0.001 0.125 8.258 20272.2 348399 92.38 0.535 0.539 19.82 0.352 4975.5 0.000 0.000 0.021 156.7 0.000 0.000 16.30 77.30 pg181_o2nofp.cx10b_c24r64 21579.5 175708 0.001 0.000 0.136 8.175 25713.3 433050 97.01 0.459 0.649 20.19 0.028 130.3 0.000 0.000 0.016 166.9 0.000 0.000 22.04 91.55 pg181_o2nofp.cx10b_walsize_c24r64
l.i2
l.i2: continue load after secondary indexes created with 5 inserts per transaction. Graphs for performance per 1-second interval are here.
Average throughput:
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 16.043 | 83.956 | 0.001 | 0.008 | |||||||
| pg1322_o2nofp.cx10a_c24r64 | 20.713 | 79.278 | 0.009 | 0.014 | |||||||
| pg1419_o2nofp.cx10a_c24r64 | 17.116 | 82.883 | nonzero | 0.004 | |||||||
| pg1515_o2nofp.cx10a_c24r64 | 12.683 | 87.316 | 0.001 | 0.005 | |||||||
| pg1611_o2nofp.cx10a_c24r64 | 18.499 | 81.501 | nonzero | 0.007 | |||||||
| pg177_o2nofp.cx10a_c24r64 | 14.263 | 85.538 | 0.113 | 0.070 | 0.016 | 0.146 | |||||
| pg181_o2nofp.cx10b_c24r64 | 13.469 | 86.530 | 0.001 | 0.006 | |||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 12.749 | 87.248 | 0.003 | nonzero | 0.022 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 99.999 | 0.001 | 0.150 | ||||||||
| pg1322_o2nofp.cx10a_c24r64 | 0.002 | 0.881 | 1.059 | 11.445 | 86.613 | nonzero | 0.152 | ||||
| pg1419_o2nofp.cx10a_c24r64 | 99.999 | 0.001 | 0.191 | ||||||||
| pg1515_o2nofp.cx10a_c24r64 | 99.847 | 0.153 | 0.156 | ||||||||
| pg1611_o2nofp.cx10a_c24r64 | 99.998 | 0.002 | 0.176 | ||||||||
| pg177_o2nofp.cx10a_c24r64 | 99.998 | 0.002 | 0.161 | ||||||||
| pg181_o2nofp.cx10b_c24r64 | 99.999 | 0.001 | 0.160 | ||||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 99.999 | 0.001 | 0.160 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 1055 0 1330 10.5 1977.8 29.4 1.261 10.188 1.875 28.549 9137 24.4 8.660 5550 391.0 455.0 48.7 0.008 200 180 pg1222_o2nofp.cx10a_c24r64 1572 0 1985 21.2 2779.9 45.5 1.263 13.829 1.769 29.644 13176 30.1 8.383 4596 390.7 454.7 10.8 0.014 200 170 pg1322_o2nofp.cx10a_c24r64 911 0 1130 8.9 1658.6 25.4 1.240 10.029 1.820 28.515 7619 24.1 8.361 6348 390.8 454.4 48.6 0.004 205 185 pg1419_o2nofp.cx10a_c24r64 1356 0 1705 13.6 2376.7 36.5 1.257 10.300 1.752 27.578 10993 30.7 8.105 5432 390.8 454.8 48.6 0.005 180 165 pg1515_o2nofp.cx10a_c24r64 778 0 956 7.6 1466.3 22.5 1.230 9.960 1.885 29.664 6562 22.3 8.436 6880 390.8 454.1 48.6 0.007 175 160 pg1611_o2nofp.cx10a_c24r64 1374 0 1719 13.8 2353.0 36.7 1.252 10.281 1.713 27.333 10530 33.3 7.666 5818 390.8 454.8 43.9 0.146 170 155 pg177_o2nofp.cx10a_c24r64 1338 0 1684 13.5 2314.9 36.0 1.259 10.312 1.730 27.533 9906 32.4 7.405 5813 390.8 454.8 48.5 0.006 170 150 pg181_o2nofp.cx10b_c24r64 1366 0 1732 13.8 2349.3 36.6 1.268 10.349 1.719 27.442 10143 33.1 7.423 5814 390.8 454.8 48.6 0.022 175 150 pg181_o2nofp.cx10b_walsize_c24r64
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 1330.5 10749.6 0.005 0.001 0.087 8.108 1977.8 30121.6 16.63 1.058 0.047 15.97 2.031 12.13 0.000 0.000 0.255 5.609 0.000 0.000 0.210 12.78 pg1222_o2nofp.cx10a_c24r64 1984.6 21735.2 0.000 0.000 0.092 9.900 2779.9 46591.6 18.38 0.644 0.102 16.72 2.032 12.51 0.000 0.000 0.252 5.281 0.000 0.000 0.793 19.21 pg1322_o2nofp.cx10a_c24r64 1129.6 9138.8 0.000 0.000 0.085 8.098 1658.6 25982.5 13.98 1.274 0.054 18.89 2.036 68.24 0.000 0.000 0.253 10.19 0.000 0.000 0.175 11.03 pg1419_o2nofp.cx10a_c24r64 1704.6 13969.9 0.000 0.000 0.089 8.176 2376.7 37404.2 13.46 0.490 0.058 15.67 0.036 2.014 0.000 0.000 0.027 1.464 0.000 0.000 0.317 16.39 pg1515_o2nofp.cx10a_c24r64 956.5 7747.5 0.000 0.000 0.084 8.126 1466.3 23075.4 10.66 1.011 0.047 17.56 0.033 76.15 0.000 0.000 0.009 5.012 0.000 0.000 0.149 9.491 pg1611_o2nofp.cx10a_c24r64 1719.3 14121.8 0.002 0.000 0.085 8.174 2353.0 37544.0 12.27 0.439 0.057 16.13 0.018 0.277 0.000 0.000 0.022 0.611 0.000 0.000 0.312 16.41 pg177_o2nofp.cx10a_c24r64 1684.1 13794.8 0.001 0.000 0.087 8.181 2314.9 36831.5 12.59 0.470 0.051 16.12 0.015 0.267 0.000 0.000 0.015 0.501 0.000 0.000 0.263 16.08 pg181_o2nofp.cx10b_c24r64 1732.0 14140.2 0.000 0.000 0.089 8.128 2349.3 37493.4 13.46 0.495 0.065 16.20 0.010 0.252 0.000 0.000 0.007 0.452 0.000 0.000 0.310 16.52 pg181_o2nofp.cx10b_walsize_c24r64
qr100.L1
qr100.L1: range queries with 100 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 99.994 | 0.006 | nonzero | 0.003 | |||||||
| pg1322_o2nofp.cx10a_c24r64 | 99.993 | 0.007 | nonzero | 0.004 | |||||||
| pg1419_o2nofp.cx10a_c24r64 | 99.994 | 0.006 | nonzero | 0.002 | |||||||
| pg1515_o2nofp.cx10a_c24r64 | 99.995 | 0.005 | nonzero | 0.003 | |||||||
| pg1611_o2nofp.cx10a_c24r64 | 99.994 | 0.006 | nonzero | nonzero | 0.006 | ||||||
| pg177_o2nofp.cx10a_c24r64 | 99.995 | 0.005 | nonzero | 0.004 | |||||||
| pg181_o2nofp.cx10b_c24r64 | 99.994 | 0.006 | nonzero | 0.003 | |||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 99.990 | 0.010 | nonzero | 0.004 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 99.934 | 0.066 | 0.019 | ||||||||
| pg1322_o2nofp.cx10a_c24r64 | 98.681 | 1.319 | 0.023 | ||||||||
| pg1419_o2nofp.cx10a_c24r64 | 99.819 | 0.181 | 0.021 | ||||||||
| pg1515_o2nofp.cx10a_c24r64 | 99.868 | 0.132 | 0.021 | ||||||||
| pg1611_o2nofp.cx10a_c24r64 | 99.885 | 0.115 | 0.020 | ||||||||
| pg177_o2nofp.cx10a_c24r64 | 99.924 | 0.076 | 0.020 | ||||||||
| pg181_o2nofp.cx10b_c24r64 | 99.819 | 0.181 | 0.021 | ||||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 99.812 | 0.188 | 0.056 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 26.049 | 73.951 | 0.003 | ||||||||
| pg1322_o2nofp.cx10a_c24r64 | 25.247 | 74.740 | 0.014 | 0.005 | |||||||
| pg1419_o2nofp.cx10a_c24r64 | 24.899 | 75.101 | 0.004 | ||||||||
| pg1515_o2nofp.cx10a_c24r64 | 27.809 | 72.191 | 0.004 | ||||||||
| pg1611_o2nofp.cx10a_c24r64 | 22.420 | 77.576 | 0.003 | 0.004 | |||||||
| pg177_o2nofp.cx10a_c24r64 | 24.552 | 75.448 | 0.004 | ||||||||
| pg181_o2nofp.cx10b_c24r64 | 19.719 | 80.260 | 0.021 | 0.005 | |||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 19.604 | 80.396 | 0.004 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 797 98999 1057 9.1 389.6 13.8 0.011 0.094 0.489 17.762 380682 33.4 3.845 81 391.1 455.1 48.7 0.003 12478 11870 pg1222_o2nofp.cx10a_c24r64 797 98413 1058 8.8 544.4 15.2 0.011 0.092 0.683 19.537 378467 33.6 3.846 82 390.8 454.8 48.7 0.004 12414 11854 pg1322_o2nofp.cx10a_c24r64 797 99930 1055 8.5 540.7 15.2 0.011 0.087 0.678 19.497 384072 33.3 3.843 80 390.9 454.9 48.6 0.002 12606 11918 pg1419_o2nofp.cx10a_c24r64 797 99308 1051 8.5 540.6 15.2 0.011 0.088 0.678 19.470 381749 33.6 3.844 81 390.8 454.9 48.6 0.003 12414 12126 pg1515_o2nofp.cx10a_c24r64 797 99811 1079 8.7 532.4 15.1 0.011 0.089 0.668 19.384 383654 33.6 3.844 81 390.8 454.9 48.6 0.006 12574 11983 pg1611_o2nofp.cx10a_c24r64 796 99508 1083 8.9 538.4 15.1 0.011 0.092 0.676 19.447 382740 33.4 3.846 81 390.8 454.9 48.6 0.004 12446 11886 pg177_o2nofp.cx10a_c24r64 796 98949 1070 8.8 538.6 15.1 0.011 0.091 0.676 19.449 380488 33.5 3.845 81 390.8 454.9 48.6 0.003 12414 11838 pg181_o2nofp.cx10b_c24r64 797 98374 1068 8.6 528.7 15.1 0.011 0.090 0.663 19.350 378299 33.5 3.846 82 390.8 454.9 45.7 0.004 12318 11822 pg181_o2nofp.cx10b_walsize_c24r64
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 1057.4 9338.6 0.000 0.000 0.091 8.811 389.6 14154.4 10.69 4.980 0.136 62.24 1.998 10.39 0.000 0.000 0.254 5.197 0.000 0.000 0.128 4.473 pg1222_o2nofp.cx10a_c24r64 1058.0 9014.0 0.000 0.000 0.109 8.418 544.4 15569.3 8.785 3.375 0.220 53.85 2.000 10.81 0.000 0.000 0.254 5.403 0.000 0.000 0.187 4.235 pg1322_o2nofp.cx10a_c24r64 1054.8 8696.9 0.000 0.000 0.107 8.169 540.7 15537.4 9.757 3.773 0.248 54.20 2.001 10.79 0.000 0.000 0.253 5.396 0.000 0.000 0.183 4.247 pg1419_o2nofp.cx10a_c24r64 1051.3 8697.7 0.000 0.000 0.095 8.238 540.6 15515.6 5.929 2.313 0.107 54.61 0.001 0.002 0.000 0.000 0.003 0.011 0.000 0.000 0.131 4.490 pg1515_o2nofp.cx10a_c24r64 1079.0 8925.8 0.000 0.000 0.099 8.196 532.4 15446.9 6.299 2.519 0.120 55.48 0.001 0.002 0.000 0.000 0.000 0.011 0.000 0.000 0.140 3.968 pg1611_o2nofp.cx10a_c24r64 1082.6 9161.9 0.000 0.000 0.090 8.421 538.4 15487.6 4.353 1.761 0.116 54.80 0.001 0.002 0.000 0.000 0.000 0.011 0.000 0.000 0.132 4.692 pg177_o2nofp.cx10a_c24r64 1069.5 9033.6 0.000 0.000 0.099 8.440 538.6 15489.6 4.613 1.882 0.140 54.77 0.001 0.002 0.000 0.000 0.000 0.011 0.000 0.000 0.146 4.289 pg181_o2nofp.cx10b_c24r64 1068.1 8811.0 0.024 0.001 0.090 8.237 528.7 15419.9 5.780 2.350 0.135 56.23 0.001 0.002 0.000 0.000 0.000 0.011 0.000 0.000 0.132 4.240 pg181_o2nofp.cx10b_walsize_c24r64
qp100.L2
qp100.L2: point queries with 100 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 1.540 | 98.031 | 0.394 | 0.025 | 0.011 | 0.228 | |||||
| pg1322_o2nofp.cx10a_c24r64 | 1.485 | 98.475 | 0.040 | 0.010 | |||||||
| pg1419_o2nofp.cx10a_c24r64 | 1.655 | 98.324 | 0.021 | 0.011 | |||||||
| pg1515_o2nofp.cx10a_c24r64 | 1.714 | 98.266 | 0.020 | 0.010 | |||||||
| pg1611_o2nofp.cx10a_c24r64 | 1.645 | 98.338 | 0.016 | 0.010 | |||||||
| pg177_o2nofp.cx10a_c24r64 | 1.458 | 98.520 | 0.021 | 0.010 | |||||||
| pg181_o2nofp.cx10b_c24r64 | 1.205 | 98.488 | 0.275 | 0.024 | 0.008 | nonzero | 0.668 | ||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 1.160 | 98.424 | 0.358 | 0.046 | 0.010 | 0.213 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 51.028 | 48.111 | 0.799 | 0.062 | 0.354 | ||||||
| pg1322_o2nofp.cx10a_c24r64 | 27.201 | 72.799 | 0.033 | ||||||||
| pg1419_o2nofp.cx10a_c24r64 | 58.153 | 41.847 | 0.032 | ||||||||
| pg1515_o2nofp.cx10a_c24r64 | 40.337 | 59.663 | 0.028 | ||||||||
| pg1611_o2nofp.cx10a_c24r64 | 50.931 | 49.069 | 0.025 | ||||||||
| pg177_o2nofp.cx10a_c24r64 | 48.674 | 51.326 | 0.027 | ||||||||
| pg181_o2nofp.cx10b_c24r64 | 58.885 | 40.517 | 0.500 | 0.097 | 0.341 | ||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 45.514 | 53.434 | 1.010 | 0.042 | 0.395 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 79.191 | 20.729 | 0.080 | 0.051 | |||||||
| pg1322_o2nofp.cx10a_c24r64 | 72.868 | 27.128 | 0.003 | 0.016 | |||||||
| pg1419_o2nofp.cx10a_c24r64 | 81.698 | 18.299 | 0.003 | 0.016 | |||||||
| pg1515_o2nofp.cx10a_c24r64 | 78.715 | 21.278 | 0.007 | 0.017 | |||||||
| pg1611_o2nofp.cx10a_c24r64 | 68.295 | 31.705 | 0.015 | ||||||||
| pg177_o2nofp.cx10a_c24r64 | 66.233 | 33.764 | 0.003 | 0.016 | |||||||
| pg181_o2nofp.cx10b_c24r64 | 65.656 | 34.253 | 0.083 | 0.007 | 0.075 | ||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 63.701 | 36.222 | 0.076 | 0.063 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 796 4746 65631 514.0 2823.4 32.4 13.828 110.903 3.545 41.709 146721 12.2 30.913 617 391.2 455.3 48.7 0.228 624 224 pg1222_o2nofp.cx10a_c24r64 796 4853 67058 524.5 2681.5 31.3 13.817 110.666 3.367 40.247 148318 11.9 30.560 588 390.9 454.9 48.7 0.010 624 416 pg1322_o2nofp.cx10a_c24r64 796 4907 67707 529.2 2685.7 31.3 13.798 110.442 3.372 40.272 149591 11.6 30.486 567 390.9 452.3 48.6 0.011 624 432 pg1419_o2nofp.cx10a_c24r64 796 4938 68121 532.0 2680.8 31.3 13.796 110.338 3.366 40.207 150049 11.7 30.389 569 390.9 454.7 48.6 0.010 624 448 pg1515_o2nofp.cx10a_c24r64 796 4931 68037 531.3 2686.2 31.3 13.797 110.322 3.373 40.258 149782 11.6 30.374 565 390.9 452.7 48.6 0.010 624 448 pg1611_o2nofp.cx10a_c24r64 796 4868 67194 525.5 2680.2 31.3 13.803 110.532 3.365 40.196 147939 12.0 30.389 592 390.9 454.7 48.6 0.010 608 432 pg177_o2nofp.cx10a_c24r64 796 4679 64656 505.5 2677.2 31.2 13.819 110.621 3.362 40.149 144145 12.2 30.807 626 390.9 454.7 48.6 0.668 608 288 pg181_o2nofp.cx10b_c24r64 796 4600 63630 497.8 2677.9 31.3 13.831 110.814 3.363 40.192 142125 12.2 30.894 636 390.9 454.9 46.3 0.213 608 208 pg181_o2nofp.cx10b_walsize_c24r64
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 65631.0 526368 0.013 0.000 0.081 8.022 2823.4 33217.0 15.77 0.806 0.062 13.69 2.003 10.58 0.000 0.000 0.243 5.257 0.000 0.000 5.644 98.72 pg1222_o2nofp.cx10a_c24r64 67058.4 537094 0.000 0.000 0.081 8.010 2681.5 32052.9 13.63 0.704 0.068 13.61 1.999 10.93 0.000 0.000 0.242 5.017 0.000 0.000 5.939 99.95 pg1322_o2nofp.cx10a_c24r64 67707.3 541927 0.000 0.000 0.081 8.003 2685.7 32073.0 13.63 0.682 0.058 13.60 2.110 1572.2 0.000 0.000 0.243 47.01 0.000 0.000 5.928 99.96 pg1419_o2nofp.cx10a_c24r64 68121.4 544803 0.000 0.000 0.081 7.999 2680.8 32021.2 9.546 0.482 0.030 13.62 0.012 154.8 0.000 0.000 0.003 38.62 0.000 0.000 5.766 99.96 pg1515_o2nofp.cx10a_c24r64 68037.0 544020 0.000 0.000 0.080 7.996 2686.2 32061.1 10.94 0.552 0.030 13.62 0.089 1270.9 0.000 0.000 0.003 39.98 0.000 0.000 5.765 99.96 pg1611_o2nofp.cx10a_c24r64 67193.9 538094 0.000 0.000 0.080 8.010 2680.2 32012.0 8.029 0.406 0.031 13.63 0.011 127.2 0.000 0.000 0.001 35.35 0.000 0.000 5.722 99.95 pg177_o2nofp.cx10a_c24r64 64655.8 517584 0.002 0.000 0.080 8.006 2677.2 31974.3 8.634 0.445 0.031 13.77 0.011 136.3 0.000 0.000 0.001 35.88 0.000 0.000 5.428 98.94 pg181_o2nofp.cx10b_c24r64 63629.6 509791 0.444 0.001 0.080 8.012 2677.9 32008.7 9.679 0.499 0.031 13.75 0.002 0.144 0.000 0.000 0.001 0.247 0.000 0.000 5.398 98.53 pg181_o2nofp.cx10b_walsize_c24r64
qr500.L3
qr500.L3: range queries with 500 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 99.913 | 0.086 | 0.001 | nonzero | nonzero | 0.048 | |||||
| pg1322_o2nofp.cx10a_c24r64 | 99.923 | 0.076 | 0.001 | nonzero | nonzero | 0.056 | |||||
| pg1419_o2nofp.cx10a_c24r64 | 99.928 | 0.071 | 0.001 | nonzero | nonzero | 0.051 | |||||
| pg1515_o2nofp.cx10a_c24r64 | 99.904 | 0.095 | 0.001 | nonzero | nonzero | 0.039 | |||||
| pg1611_o2nofp.cx10a_c24r64 | 99.906 | 0.093 | 0.001 | nonzero | nonzero | 0.053 | |||||
| pg177_o2nofp.cx10a_c24r64 | 99.906 | 0.094 | 0.001 | nonzero | nonzero | 0.052 | |||||
| pg181_o2nofp.cx10b_c24r64 | 99.895 | 0.104 | 0.001 | nonzero | nonzero | 0.048 | |||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 99.933 | 0.067 | 0.001 | nonzero | nonzero | nonzero | 0.084 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 67.018 | 32.978 | 0.004 | 0.069 | |||||||
| pg1322_o2nofp.cx10a_c24r64 | 58.610 | 41.348 | 0.033 | 0.008 | 0.281 | ||||||
| pg1419_o2nofp.cx10a_c24r64 | 63.742 | 36.258 | 0.042 | ||||||||
| pg1515_o2nofp.cx10a_c24r64 | 85.190 | 14.810 | 0.036 | ||||||||
| pg1611_o2nofp.cx10a_c24r64 | 86.536 | 13.460 | 0.003 | 0.071 | |||||||
| pg177_o2nofp.cx10a_c24r64 | 84.474 | 15.519 | 0.001 | 0.006 | 0.317 | ||||||
| pg181_o2nofp.cx10b_c24r64 | 80.472 | 19.528 | 0.063 | ||||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 77.373 | 22.203 | 0.359 | 0.065 | 0.485 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 3.980 | 78.303 | 17.717 | 0.042 | |||||||
| pg1322_o2nofp.cx10a_c24r64 | 3.385 | 88.246 | 8.369 | 0.026 | |||||||
| pg1419_o2nofp.cx10a_c24r64 | 3.444 | 90.542 | 6.015 | 0.026 | |||||||
| pg1515_o2nofp.cx10a_c24r64 | 2.849 | 74.910 | 22.241 | 0.034 | |||||||
| pg1611_o2nofp.cx10a_c24r64 | 1.106 | 70.837 | 28.055 | 0.002 | 0.070 | ||||||
| pg177_o2nofp.cx10a_c24r64 | 1.105 | 69.254 | 29.637 | 0.004 | 0.066 | ||||||
| pg181_o2nofp.cx10b_c24r64 | 0.513 | 70.298 | 29.189 | 0.061 | |||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 1.789 | 74.375 | 23.835 | 0.001 | 0.087 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 3982 88678 5707 45.7 5279.3 92.0 0.064 0.528 1.326 23.646 346856 39.4 3.911 107 391.9 455.9 43.3 0.048 11149 10398 pg1222_o2nofp.cx10a_c24r64 3982 88758 5857 47.6 5284.9 91.7 0.066 0.549 1.327 23.590 349271 39.1 3.935 106 391.4 455.4 48.0 0.056 11102 10398 pg1322_o2nofp.cx10a_c24r64 3982 90005 5813 46.8 5296.0 93.2 0.065 0.533 1.330 23.961 353645 38.8 3.929 103 391.3 455.4 48.6 0.051 11294 10494 pg1419_o2nofp.cx10a_c24r64 3982 88998 5726 46.0 5277.6 91.8 0.064 0.529 1.325 23.601 348880 39.4 3.920 106 391.2 455.2 48.6 0.039 11119 10479 pg1515_o2nofp.cx10a_c24r64 3982 89279 5713 46.0 5288.6 92.9 0.064 0.528 1.328 23.885 349373 39.6 3.913 106 391.1 455.1 48.6 0.053 11214 10511 pg1611_o2nofp.cx10a_c24r64 3984 88716 5736 46.9 5283.3 91.8 0.065 0.542 1.326 23.596 345729 39.7 3.897 107 391.1 455.1 48.6 0.052 11150 10430 pg177_o2nofp.cx10a_c24r64 3984 87743 5751 46.5 5281.4 91.8 0.066 0.543 1.325 23.597 342485 39.9 3.903 109 391.1 455.2 47.8 0.048 10926 10142 pg181_o2nofp.cx10b_c24r64 3982 87870 5816 50.3 5271.8 90.4 0.066 0.587 1.324 23.245 346588 39.6 3.944 108 391.1 455.1 46.0 0.084 11022 10334 pg181_o2nofp.cx10b_walsize_c24r64
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 5706.9 46847.8 0.000 0.000 0.131 8.192 5279.3 94163.7 29.47 0.820 0.446 30.50 2.054 682.4 0.000 0.000 0.253 38.72 0.000 0.000 3.276 19.48 pg1222_o2nofp.cx10a_c24r64 5857.2 48744.3 0.000 0.000 0.141 8.288 5284.9 93943.6 30.36 0.828 0.532 30.06 2.092 1306.6 0.000 0.000 0.253 45.81 0.000 0.000 3.827 20.17 pg1322_o2nofp.cx10a_c24r64 5812.7 47946.7 0.001 0.000 0.141 8.220 5296.0 95419.9 32.27 0.835 0.591 30.35 2.096 1272.9 0.000 0.000 0.259 41.90 0.000 0.000 4.294 20.17 pg1419_o2nofp.cx10a_c24r64 5726.3 47107.6 0.001 0.000 0.115 8.209 5277.6 93987.3 23.25 0.590 0.381 30.47 0.099 1398.2 0.000 0.000 0.004 41.28 0.000 0.000 3.078 18.41 pg1515_o2nofp.cx10a_c24r64 5713.4 47110.3 0.000 0.000 0.114 8.228 5288.6 95117.4 27.84 0.657 0.323 30.50 0.098 1298.4 0.000 0.000 0.007 45.13 0.000 0.000 2.722 18.29 pg1611_o2nofp.cx10a_c24r64 5735.6 48076.3 0.000 0.000 0.114 8.379 5283.3 94018.0 22.03 0.554 0.268 30.13 0.098 1404.4 0.000 0.000 0.003 40.91 0.000 0.000 2.319 18.28 pg177_o2nofp.cx10a_c24r64 5750.7 47617.0 0.000 0.000 0.116 8.268 5281.4 94022.9 21.99 0.555 0.308 30.27 0.095 1407.2 0.000 0.000 0.002 57.15 0.000 0.000 2.528 18.95 pg181_o2nofp.cx10b_c24r64 5815.6 51554.4 0.038 0.000 0.108 8.748 5271.8 92566.9 21.33 0.616 0.197 29.99 0.004 0.230 0.000 0.000 0.002 0.473 0.000 0.000 1.717 22.69 pg181_o2nofp.cx10b_walsize_c24r64
qp500.L4
qp500.L4: point queries with 500 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 0.702 | 98.992 | 0.307 | 0.011 | |||||||
| pg1322_o2nofp.cx10a_c24r64 | 0.443 | 98.711 | 0.814 | 0.026 | 0.007 | nonzero | 0.659 | ||||
| pg1419_o2nofp.cx10a_c24r64 | 0.558 | 99.082 | 0.361 | 0.011 | |||||||
| pg1515_o2nofp.cx10a_c24r64 | 0.641 | 99.086 | 0.273 | 0.012 | |||||||
| pg1611_o2nofp.cx10a_c24r64 | 0.619 | 99.132 | 0.249 | nonzero | 0.053 | ||||||
| pg177_o2nofp.cx10a_c24r64 | 0.462 | 98.352 | 1.122 | 0.053 | 0.011 | nonzero | 0.308 | ||||
| pg181_o2nofp.cx10b_c24r64 | 0.491 | 99.181 | 0.328 | 0.016 | |||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 0.483 | 99.231 | 0.286 | nonzero | 0.017 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 18.604 | 81.394 | 0.001 | 0.076 | |||||||
| pg1322_o2nofp.cx10a_c24r64 | 18.116 | 81.621 | 0.263 | 0.238 | |||||||
| pg1419_o2nofp.cx10a_c24r64 | 18.628 | 81.369 | 0.002 | 0.083 | |||||||
| pg1515_o2nofp.cx10a_c24r64 | 24.955 | 75.045 | 0.058 | ||||||||
| pg1611_o2nofp.cx10a_c24r64 | 29.492 | 70.503 | 0.005 | 0.072 | |||||||
| pg177_o2nofp.cx10a_c24r64 | 22.312 | 77.038 | 0.583 | 0.067 | 0.584 | ||||||
| pg181_o2nofp.cx10b_c24r64 | 21.614 | 78.384 | 0.002 | 0.089 | |||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 34.326 | 65.673 | 0.001 | 0.079 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 2.003 | 97.991 | 0.006 | 0.079 | |||||||
| pg1322_o2nofp.cx10a_c24r64 | 1.186 | 98.804 | 0.010 | 0.083 | |||||||
| pg1419_o2nofp.cx10a_c24r64 | 5.828 | 94.165 | 0.007 | 0.081 | |||||||
| pg1515_o2nofp.cx10a_c24r64 | 0.574 | 99.421 | 0.006 | 0.086 | |||||||
| pg1611_o2nofp.cx10a_c24r64 | 0.090 | 99.903 | 0.007 | 0.081 | |||||||
| pg177_o2nofp.cx10a_c24r64 | 0.353 | 99.606 | 0.041 | 0.174 | |||||||
| pg181_o2nofp.cx10b_c24r64 | 0.060 | 99.934 | 0.006 | 0.084 | |||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 0.496 | 99.499 | 0.006 | 0.081 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 3982 4346 68483 535.0 9743.9 125.4 15.759 126.067 2.447 32.245 152180 20.9 35.019 1154 392.5 456.5 48.5 0.011 560 368 pg1222_o2nofp.cx10a_c24r64 3982 4088 65088 510.9 9722.4 125.5 15.921 127.979 2.441 32.274 146033 21.1 35.721 1239 391.9 455.9 47.6 0.659 528 176 pg1322_o2nofp.cx10a_c24r64 3984 4262 67392 527.0 9751.0 125.6 15.811 126.595 2.447 32.274 149211 20.7 35.006 1166 391.7 455.8 48.6 0.011 544 352 pg1419_o2nofp.cx10a_c24r64 3982 4324 68204 533.3 9757.0 125.6 15.773 126.303 2.450 32.292 150752 21.1 34.863 1171 391.4 455.5 48.6 0.012 560 368 pg1515_o2nofp.cx10a_c24r64 3982 4325 68202 533.2 9753.0 125.5 15.770 126.250 2.449 32.268 150138 21.4 34.716 1188 391.3 455.4 48.6 0.053 544 368 pg1611_o2nofp.cx10a_c24r64 3984 4055 64653 507.9 9640.2 124.6 15.944 128.268 2.419 32.017 143807 21.9 35.464 1296 391.3 455.4 48.6 0.308 528 144 pg177_o2nofp.cx10a_c24r64 3984 4232 66934 524.6 9733.7 125.4 15.817 126.947 2.443 32.223 146952 22.6 34.726 1282 391.4 455.4 48.0 0.016 528 368 pg181_o2nofp.cx10b_c24r64 3982 4234 66980 524.4 9738.8 125.4 15.821 126.831 2.446 32.235 147167 22.2 34.761 1258 391.4 455.4 46.1 0.017 544 352 pg181_o2nofp.cx10b_walsize_c24r64
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 68483.0 547839 0.000 0.000 0.092 8.000 9743.9 128411 43.86 0.387 0.100 13.66 2.013 20.02 0.000 0.000 0.245 7.613 0.000 0.000 7.955 99.96 pg1222_o2nofp.cx10a_c24r64 65087.7 523205 0.002 0.000 0.098 8.040 9722.4 128525 47.53 0.380 0.118 13.81 2.014 47.54 0.000 0.000 0.251 15.05 0.000 0.000 8.093 99.25 pg1322_o2nofp.cx10a_c24r64 67391.7 539599 0.000 0.000 0.096 8.007 9751.0 128595 35.06 0.308 0.105 13.65 2.011 29.38 0.000 0.000 0.245 11.06 0.000 0.000 8.076 99.96 pg1419_o2nofp.cx10a_c24r64 68204.5 546146 0.000 0.000 0.094 8.008 9757.0 128598 31.73 0.264 0.103 13.65 0.013 0.450 0.000 0.000 0.007 0.427 0.000 0.000 7.989 99.96 pg1515_o2nofp.cx10a_c24r64 68202.3 546007 0.000 0.000 0.094 8.006 9753.0 128502 31.98 0.273 0.090 13.66 0.011 0.454 0.000 0.000 0.009 0.534 0.000 0.000 7.866 99.96 pg1611_o2nofp.cx10a_c24r64 64652.7 520126 0.064 0.000 0.096 8.045 9640.2 127571 27.72 0.245 0.124 14.03 0.006 18.43 0.000 0.000 0.005 23.22 0.000 0.000 7.927 98.59 pg177_o2nofp.cx10a_c24r64 66933.7 537214 0.167 0.000 0.094 8.027 9733.7 128392 30.52 0.256 0.102 13.66 0.007 36.58 0.000 0.000 0.007 45.86 0.000 0.000 7.935 99.94 pg181_o2nofp.cx10b_c24r64 66980.1 536964 0.000 0.000 0.093 8.017 9738.8 128370 29.16 0.250 0.100 13.67 0.006 9.358 0.000 0.000 0.005 15.73 0.000 0.000 7.869 99.95 pg181_o2nofp.cx10b_walsize_c24r64
qr1000.L5
qr1000.L5: range queries with 1000 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 99.228 | 0.766 | 0.005 | 0.001 | nonzero | nonzero | nonzero | 0.270 | |||
| pg1322_o2nofp.cx10a_c24r64 | 99.338 | 0.657 | 0.005 | 0.001 | nonzero | nonzero | nonzero | 0.258 | |||
| pg1419_o2nofp.cx10a_c24r64 | 99.334 | 0.661 | 0.005 | 0.001 | nonzero | nonzero | nonzero | 0.293 | |||
| pg1515_o2nofp.cx10a_c24r64 | 98.794 | 1.200 | 0.005 | 0.001 | nonzero | nonzero | nonzero | 0.257 | |||
| pg1611_o2nofp.cx10a_c24r64 | 98.997 | 0.997 | 0.004 | 0.001 | nonzero | nonzero | nonzero | 0.263 | |||
| pg177_o2nofp.cx10a_c24r64 | 98.755 | 1.240 | 0.005 | 0.001 | nonzero | nonzero | 0.242 | ||||
| pg181_o2nofp.cx10b_c24r64 | 98.662 | 1.333 | 0.004 | 0.001 | nonzero | nonzero | nonzero | 0.280 | |||
| pg181_o2nofp.cx10b_walsize_c24r64 | 98.941 | 1.053 | 0.005 | 0.001 | nonzero | nonzero | nonzero | 0.265 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 58.753 | 41.247 | 0.036 | ||||||||
| pg1322_o2nofp.cx10a_c24r64 | 56.142 | 43.858 | 0.044 | ||||||||
| pg1419_o2nofp.cx10a_c24r64 | 58.432 | 41.568 | 0.037 | ||||||||
| pg1515_o2nofp.cx10a_c24r64 | 64.554 | 35.446 | 0.034 | ||||||||
| pg1611_o2nofp.cx10a_c24r64 | 70.139 | 29.861 | 0.048 | ||||||||
| pg177_o2nofp.cx10a_c24r64 | 68.598 | 31.399 | 0.003 | 0.146 | |||||||
| pg181_o2nofp.cx10b_c24r64 | 70.907 | 29.091 | 0.002 | 0.072 | |||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 65.612 | 34.387 | 0.061 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 0.649 | 99.348 | 0.003 | 0.124 | |||||||
| pg1322_o2nofp.cx10a_c24r64 | 0.702 | 99.295 | 0.003 | 0.121 | |||||||
| pg1419_o2nofp.cx10a_c24r64 | 0.936 | 99.061 | 0.003 | 0.119 | |||||||
| pg1515_o2nofp.cx10a_c24r64 | 1.289 | 98.708 | 0.003 | 0.131 | |||||||
| pg1611_o2nofp.cx10a_c24r64 | 0.040 | 99.957 | 0.003 | 0.126 | |||||||
| pg177_o2nofp.cx10a_c24r64 | 0.165 | 99.830 | 0.005 | 0.132 | |||||||
| pg181_o2nofp.cx10b_c24r64 | 0.037 | 99.960 | 0.003 | 0.124 | |||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 0.014 | 99.983 | 0.003 | 0.130 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 7969 69060 10802 86.7 12460.3 198.5 0.156 1.286 1.564 25.504 274241 54.3 3.971 189 393.8 457.8 48.7 0.270 8750 7967 pg1222_o2nofp.cx10a_c24r64 7965 68762 10771 86.6 12449.4 198.0 0.157 1.289 1.563 25.453 270889 54.0 3.940 188 393.1 457.1 48.5 0.258 8750 7903 pg1322_o2nofp.cx10a_c24r64 7969 69886 10879 87.1 12449.2 197.9 0.156 1.277 1.562 25.431 277458 54.1 3.970 186 392.9 456.9 48.6 0.293 8863 8095 pg1419_o2nofp.cx10a_c24r64 7965 68585 10852 87.2 12439.2 197.8 0.158 1.302 1.562 25.429 272593 54.8 3.975 192 392.6 456.6 48.6 0.257 8719 7871 pg1515_o2nofp.cx10a_c24r64 7965 68220 10798 86.9 12440.3 197.9 0.158 1.304 1.562 25.443 269959 56.4 3.957 198 392.5 456.5 48.6 0.263 8654 7855 pg1611_o2nofp.cx10a_c24r64 7965 67324 10757 86.6 12502.8 198.3 0.160 1.317 1.570 25.500 263897 55.8 3.920 199 392.5 456.5 48.5 0.242 8558 7567 pg177_o2nofp.cx10a_c24r64 7969 66129 10909 89.5 12447.3 197.9 0.165 1.386 1.562 25.427 261421 56.9 3.953 207 392.5 456.6 48.6 0.280 8367 7519 pg181_o2nofp.cx10b_c24r64 7965 66887 10958 89.4 12444.6 197.9 0.164 1.368 1.562 25.440 263053 56.2 3.933 202 392.5 456.6 48.5 0.265 8471 7663 pg181_o2nofp.cx10b_walsize_c24r64
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 10801.7 88778.2 0.000 0.000 0.136 8.175 12460.3 203238 66.48 0.629 0.495 18.31 2.039 65.91 0.000 0.000 0.259 21.15 0.000 0.000 8.167 37.83 pg1222_o2nofp.cx10a_c24r64 10771.0 88663.5 0.000 0.000 0.144 8.187 12449.4 202721 69.58 0.575 0.505 17.94 2.031 38.97 0.000 0.000 0.268 13.73 0.000 0.000 8.324 38.33 pg1322_o2nofp.cx10a_c24r64 10879.3 89241.0 0.000 0.000 0.138 8.157 12449.2 202656 53.47 0.464 0.514 17.98 2.027 38.94 0.000 0.000 0.266 14.35 0.000 0.000 8.447 37.63 pg1419_o2nofp.cx10a_c24r64 10851.7 89303.8 0.001 0.000 0.126 8.184 12439.2 202535 45.84 0.409 0.458 18.00 0.018 19.00 0.000 0.000 0.010 19.25 0.000 0.000 7.582 37.51 pg1515_o2nofp.cx10a_c24r64 10798.4 88954.7 0.000 0.000 0.125 8.192 12440.3 202640 51.85 0.452 0.462 18.08 0.019 37.01 0.000 0.000 0.009 31.88 0.000 0.000 7.619 38.45 pg1611_o2nofp.cx10a_c24r64 10757.4 88641.9 0.012 0.000 0.123 8.195 12502.8 203100 47.74 0.414 0.399 17.83 0.014 36.69 0.000 0.000 0.021 41.77 0.000 0.000 6.706 38.09 pg177_o2nofp.cx10a_c24r64 10908.6 91655.0 0.001 0.000 0.122 8.368 12447.3 202624 47.57 0.409 0.378 18.00 0.013 27.78 0.000 0.000 0.009 38.85 0.000 0.000 6.371 41.32 pg181_o2nofp.cx10b_c24r64 10958.5 91519.4 0.013 0.000 0.126 8.309 12444.6 202619 47.86 0.419 0.426 18.08 0.009 0.425 0.000 0.000 0.008 1.186 0.000 0.000 7.150 38.09 pg181_o2nofp.cx10b_walsize_c24r64
qp1000.L6
qp1000.L6: point queries with 1000 insert/s per client. Graphs for performance per 1-second interval are here.
Average throughput:
Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 0.164 | 98.294 | 1.541 | nonzero | 0.021 | ||||||
| pg1322_o2nofp.cx10a_c24r64 | 0.125 | 97.509 | 2.367 | 0.015 | |||||||
| pg1419_o2nofp.cx10a_c24r64 | 0.102 | 97.297 | 2.525 | 0.064 | 0.012 | nonzero | 0.337 | ||||
| pg1515_o2nofp.cx10a_c24r64 | 0.094 | 98.611 | 1.270 | 0.018 | 0.007 | nonzero | 0.324 | ||||
| pg1611_o2nofp.cx10a_c24r64 | 0.139 | 98.535 | 1.326 | nonzero | 0.018 | ||||||
| pg177_o2nofp.cx10a_c24r64 | 0.123 | 98.517 | 1.360 | nonzero | 0.022 | ||||||
| pg181_o2nofp.cx10b_c24r64 | 0.097 | 98.439 | 1.464 | 0.014 | |||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 0.102 | 98.477 | 1.421 | nonzero | 0.039 |
Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 19.860 | 80.140 | 0.053 | ||||||||
| pg1322_o2nofp.cx10a_c24r64 | 14.507 | 85.493 | 0.054 | ||||||||
| pg1419_o2nofp.cx10a_c24r64 | 24.945 | 74.441 | 0.568 | 0.046 | 0.516 | ||||||
| pg1515_o2nofp.cx10a_c24r64 | 52.728 | 47.121 | 0.125 | 0.026 | 0.568 | ||||||
| pg1611_o2nofp.cx10a_c24r64 | 29.976 | 70.024 | 0.044 | ||||||||
| pg177_o2nofp.cx10a_c24r64 | 30.391 | 69.609 | 0.039 | ||||||||
| pg181_o2nofp.cx10b_c24r64 | 26.950 | 73.050 | 0.051 | ||||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 24.902 | 75.098 | 0.060 |
Delete response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.
| dbms | 256us | 1ms | 4ms | 16ms | 64ms | 256ms | 1s | 4s | 16s | gt | max |
|---|---|---|---|---|---|---|---|---|---|---|---|
| pg1222_o2nofp.cx10a_c24r64 | 99.997 | 0.003 | 0.170 | ||||||||
| pg1322_o2nofp.cx10a_c24r64 | 99.997 | 0.003 | 0.165 | ||||||||
| pg1419_o2nofp.cx10a_c24r64 | 99.963 | 0.037 | 0.168 | ||||||||
| pg1515_o2nofp.cx10a_c24r64 | 99.980 | 0.020 | 0.179 | ||||||||
| pg1611_o2nofp.cx10a_c24r64 | 99.996 | 0.004 | 0.175 | ||||||||
| pg177_o2nofp.cx10a_c24r64 | 99.997 | 0.003 | 0.161 | ||||||||
| pg181_o2nofp.cx10b_c24r64 | 99.997 | 0.003 | 0.170 | ||||||||
| pg181_o2nofp.cx10b_walsize_c24r64 | 99.997 | 0.003 | 0.177 |
Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 7965 3684 68835 538.8 17205.5 236.4 18.685 149.761 2.160 30.393 155515 36.5 42.215 2378 395.5 459.5 48.7 0.021 464 320 pg1222_o2nofp.cx10a_c24r64 7965 3561 67051 525.2 17156.0 236.4 18.828 151.032 2.154 30.399 152134 36.7 42.720 2473 394.8 458.9 48.5 0.015 464 288 pg1322_o2nofp.cx10a_c24r64 7925 3462 65688 514.6 17028.7 234.5 18.977 152.241 2.149 30.306 149845 36.3 43.289 2517 394.6 458.7 48.6 0.337 448 80 pg1419_o2nofp.cx10a_c24r64 7947 3590 67346 528.2 17148.0 235.8 18.758 150.643 2.158 30.380 151662 37.3 42.243 2493 394.3 458.4 48.6 0.324 464 176 pg1515_o2nofp.cx10a_c24r64 7965 3692 68924 539.3 17212.3 236.6 18.671 149.606 2.161 30.425 153042 39.5 41.458 2568 394.2 458.2 48.6 0.018 464 336 pg1611_o2nofp.cx10a_c24r64 7965 3654 68303 535.3 17200.4 236.5 18.690 149.990 2.160 30.401 151466 39.9 41.447 2620 394.2 458.3 48.5 0.022 464 304 pg177_o2nofp.cx10a_c24r64 7965 3599 67735 533.0 17164.0 236.2 18.819 151.638 2.155 30.372 149852 40.8 41.635 2721 394.3 458.3 48.6 0.014 448 320 pg181_o2nofp.cx10b_c24r64 7960 3612 67804 531.4 17180.9 236.3 18.773 150.668 2.158 30.398 150125 40.2 41.566 2671 394.3 458.3 48.5 0.039 464 304 pg181_o2nofp.cx10b_walsize_c24r64
Average values from iostat.
r/s rkB/s rrqm/s %rrqm r_await rareq-s w/s wkB/s wrqm/s %wrqm w_await wareq-s d/s dkB/s drqm/s %drqm d_await dareq-s f/s f_await aqu-sz %util 68834.7 551704 0.000 0.000 0.113 8.015 17205.5 242070 112.0 0.529 0.274 14.24 2.024 102.1 0.000 0.000 0.256 29.83 0.000 0.000 13.00 99.97 pg1222_o2nofp.cx10a_c24r64 67050.6 537854 0.000 0.000 0.117 8.022 17156.0 242118 107.7 0.521 0.335 14.29 2.037 93.46 0.000 0.000 0.253 28.95 0.000 0.000 14.40 99.97 pg1322_o2nofp.cx10a_c24r64 65687.7 526982 0.005 0.000 0.114 8.023 17028.7 240175 65.69 0.322 0.302 14.50 2.027 111.0 0.000 0.000 0.251 33.47 0.000 0.000 13.55 98.93 pg1419_o2nofp.cx10a_c24r64 67345.6 540837 0.070 0.000 0.109 8.032 17148.0 241430 56.74 0.292 0.203 14.33 0.024 28.18 0.000 0.000 0.015 23.52 0.000 0.000 11.47 99.36 pg1515_o2nofp.cx10a_c24r64 68923.8 552270 0.000 0.000 0.112 8.013 17212.3 242323 62.88 0.311 0.271 14.26 0.032 82.71 0.000 0.000 0.016 58.88 0.000 0.000 13.12 99.97 pg1611_o2nofp.cx10a_c24r64 68303.1 548140 0.000 0.000 0.112 8.025 17200.4 242134 57.09 0.275 0.290 14.27 0.018 18.81 0.000 0.000 0.017 24.23 0.000 0.000 13.42 99.97 pg177_o2nofp.cx10a_c24r64 67734.9 545775 0.000 0.000 0.112 8.057 17164.0 241898 59.99 0.299 0.280 14.28 0.024 64.29 0.000 0.000 0.017 65.63 0.000 0.000 13.13 99.96 pg181_o2nofp.cx10b_c24r64 67803.9 544167 0.000 0.000 0.112 8.026 17180.9 241969 61.84 0.298 0.270 14.27 0.023 55.03 0.000 0.000 0.018 80.60 0.000 0.000 13.07 99.96 pg181_o2nofp.cx10b_walsize_c24r64
l.i0
l.i0: load without secondary indexes
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 732869 0 552 4.6 3306.5 294.0 0.001 0.006 0.005 0.411 83811 52.3 0.114 17 191.4 255.4 48.7 0.853 92689 83089 pg1222_o2nofp.cx10a_c24r64 760746 0 535 4.6 2746.5 304.5 0.001 0.006 0.004 0.410 86721 53.3 0.114 17 191.4 255.4 3.1 0.480 96987 74892 pg1322_o2nofp.cx10a_c24r64 715308 0 505 3.9 2587.8 285.3 0.001 0.006 0.004 0.408 82621 51.4 0.116 17 191.4 255.4 7.7 0.513 92388 54692 pg1419_o2nofp.cx10a_c24r64 766577 0 548 4.3 2769.1 307.0 0.001 0.006 0.004 0.410 85692 52.9 0.112 17 191.4 255.4 2.1 0.510 96887 76287 pg1515_o2nofp.cx10a_c24r64 763359 0 539 4.2 2712.2 304.4 0.001 0.006 0.004 0.408 85359 52.8 0.112 17 191.4 255.4 4.0 0.438 96487 85490 pg1611_o2nofp.cx10a_c24r64 732601 0 525 4.2 2642.7 293.8 0.001 0.006 0.004 0.411 73216 51.1 0.100 17 191.4 255.4 48.6 0.450 94689 35694 pg177_o2nofp.cx10a_c24r64 752729 0 543 4.5 2699.7 301.9 0.001 0.006 0.004 0.411 74366 52.2 0.099 17 191.4 255.4 47.5 0.444 95788 83485 pg181_o2nofp.cx10b_c24r64 735564 0 527 4.2 2621.1 293.3 0.001 0.006 0.004 0.408 73505 51.3 0.100 17 191.4 255.4 48.5 0.456 94089 52690 pg181_o2nofp.cx10b_walsize_c24r64
l.x
l.x: create secondary indexes
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 1116695 0 16532 383.9 5072.9 465.8 0.015 0.352 0.005 0.427 42875 24.5 0.038 5 384.4 448.4 18.6 0.003 NA NA pg1222_o2nofp.cx10a_c24r64 1266624 0 18842 418.3 3090.0 375.8 0.015 0.338 0.002 0.304 24624 26.2 0.019 5 384.2 448.3 39.0 0.003 NA NA pg1322_o2nofp.cx10a_c24r64 1273074 0 8691 379.0 3086.6 378.2 0.007 0.305 0.002 0.304 25395 26.4 0.020 5 384.2 448.3 11.0 0.004 NA NA pg1419_o2nofp.cx10a_c24r64 1201923 0 10124 493.4 3659.9 450.2 0.008 0.420 0.003 0.384 36605 25.5 0.030 5 384.2 448.3 38.7 0.003 NA NA pg1515_o2nofp.cx10a_c24r64 1280410 0 3475 381.2 3349.4 410.7 0.003 0.305 0.003 0.328 25129 25.8 0.020 5 384.2 448.3 38.3 0.003 NA NA pg1611_o2nofp.cx10a_c24r64 1398601 0 3297 366.8 3256.9 398.9 0.002 0.269 0.002 0.292 18321 26.4 0.013 5 384.2 448.3 34.5 0.003 NA NA pg177_o2nofp.cx10a_c24r64 1356852 0 7388 380.1 3150.0 385.3 0.005 0.287 0.002 0.291 20692 25.7 0.015 5 384.2 448.3 24.4 0.003 NA NA pg181_o2nofp.cx10b_c24r64 1379310 0 16362 435.9 3239.0 394.5 0.012 0.324 0.002 0.293 19756 26.1 0.014 5 384.2 448.3 37.8 0.003 NA NA pg181_o2nofp.cx10b_walsize_c24r64
l.i1
l.i1: continue load after secondary indexes created with 50 inserts per transaction
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 21108 0 27194 213.7 31005.4 525.6 1.288 10.368 1.469 25.497 66369 40.7 3.144 463 389.6 453.7 48.7 0.437 2550 1700 pg1222_o2nofp.cx10a_c24r64 18497 0 24075 209.4 28262.6 474.4 1.302 11.592 1.528 26.262 59504 37.2 3.217 483 389.4 453.5 2.9 0.190 2500 1700 pg1322_o2nofp.cx10a_c24r64 16913 0 21542 171.7 25266.8 424.7 1.274 10.397 1.494 25.714 52698 33.9 3.116 481 389.5 453.5 1.6 0.131 2549 1700 pg1419_o2nofp.cx10a_c24r64 19150 0 24369 194.1 29067.4 482.7 1.272 10.381 1.518 25.809 59893 38.9 3.128 488 389.4 453.5 1.5 0.262 2450 1600 pg1515_o2nofp.cx10a_c24r64 14072 0 17921 142.8 21234.8 351.2 1.274 10.391 1.509 25.560 43360 32.8 3.081 559 389.4 453.5 48.6 0.451 2200 1550 pg1611_o2nofp.cx10a_c24r64 17335 0 22134 175.8 26716.9 437.1 1.277 10.384 1.541 25.818 53162 38.1 3.067 527 389.4 453.5 48.6 0.093 2150 1450 pg177_o2nofp.cx10a_c24r64 13457 0 17245 138.6 20272.2 340.2 1.282 10.548 1.506 25.891 42912 31.6 3.189 564 389.4 453.5 48.5 2.409 2050 700 pg181_o2nofp.cx10b_c24r64 16763 0 21580 171.6 25713.3 422.9 1.287 10.482 1.534 25.834 51339 37.7 3.063 540 389.4 453.5 48.6 0.102 2200 1550 pg181_o2nofp.cx10b_walsize_c24r64
l.i2
l.i2: continue load after secondary indexes created with 5 inserts per transaction
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 1055 0 1330 10.5 1977.8 29.4 1.261 10.188 1.875 28.549 9137 24.4 8.660 5550 391.0 455.0 48.7 0.008 200 180 pg1222_o2nofp.cx10a_c24r64 1572 0 1985 21.2 2779.9 45.5 1.263 13.829 1.769 29.644 13176 30.1 8.383 4596 390.7 454.7 10.8 0.014 200 170 pg1322_o2nofp.cx10a_c24r64 911 0 1130 8.9 1658.6 25.4 1.240 10.029 1.820 28.515 7619 24.1 8.361 6348 390.8 454.4 48.6 0.004 205 185 pg1419_o2nofp.cx10a_c24r64 1356 0 1705 13.6 2376.7 36.5 1.257 10.300 1.752 27.578 10993 30.7 8.105 5432 390.8 454.8 48.6 0.005 180 165 pg1515_o2nofp.cx10a_c24r64 778 0 956 7.6 1466.3 22.5 1.230 9.960 1.885 29.664 6562 22.3 8.436 6880 390.8 454.1 48.6 0.007 175 160 pg1611_o2nofp.cx10a_c24r64 1374 0 1719 13.8 2353.0 36.7 1.252 10.281 1.713 27.333 10530 33.3 7.666 5818 390.8 454.8 43.9 0.146 170 155 pg177_o2nofp.cx10a_c24r64 1338 0 1684 13.5 2314.9 36.0 1.259 10.312 1.730 27.533 9906 32.4 7.405 5813 390.8 454.8 48.5 0.006 170 150 pg181_o2nofp.cx10b_c24r64 1366 0 1732 13.8 2349.3 36.6 1.268 10.349 1.719 27.442 10143 33.1 7.423 5814 390.8 454.8 48.6 0.022 175 150 pg181_o2nofp.cx10b_walsize_c24r64
qr100.L1
qr100.L1: range queries with 100 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 797 98999 1057 9.1 389.6 13.8 0.011 0.094 0.489 17.762 380682 33.4 3.845 81 391.1 455.1 48.7 0.003 12478 11870 pg1222_o2nofp.cx10a_c24r64 797 98413 1058 8.8 544.4 15.2 0.011 0.092 0.683 19.537 378467 33.6 3.846 82 390.8 454.8 48.7 0.004 12414 11854 pg1322_o2nofp.cx10a_c24r64 797 99930 1055 8.5 540.7 15.2 0.011 0.087 0.678 19.497 384072 33.3 3.843 80 390.9 454.9 48.6 0.002 12606 11918 pg1419_o2nofp.cx10a_c24r64 797 99308 1051 8.5 540.6 15.2 0.011 0.088 0.678 19.470 381749 33.6 3.844 81 390.8 454.9 48.6 0.003 12414 12126 pg1515_o2nofp.cx10a_c24r64 797 99811 1079 8.7 532.4 15.1 0.011 0.089 0.668 19.384 383654 33.6 3.844 81 390.8 454.9 48.6 0.006 12574 11983 pg1611_o2nofp.cx10a_c24r64 796 99508 1083 8.9 538.4 15.1 0.011 0.092 0.676 19.447 382740 33.4 3.846 81 390.8 454.9 48.6 0.004 12446 11886 pg177_o2nofp.cx10a_c24r64 796 98949 1070 8.8 538.6 15.1 0.011 0.091 0.676 19.449 380488 33.5 3.845 81 390.8 454.9 48.6 0.003 12414 11838 pg181_o2nofp.cx10b_c24r64 797 98374 1068 8.6 528.7 15.1 0.011 0.090 0.663 19.350 378299 33.5 3.846 82 390.8 454.9 45.7 0.004 12318 11822 pg181_o2nofp.cx10b_walsize_c24r64
qp100.L2
qp100.L2: point queries with 100 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 796 4746 65631 514.0 2823.4 32.4 13.828 110.903 3.545 41.709 146721 12.2 30.913 617 391.2 455.3 48.7 0.228 624 224 pg1222_o2nofp.cx10a_c24r64 796 4853 67058 524.5 2681.5 31.3 13.817 110.666 3.367 40.247 148318 11.9 30.560 588 390.9 454.9 48.7 0.010 624 416 pg1322_o2nofp.cx10a_c24r64 796 4907 67707 529.2 2685.7 31.3 13.798 110.442 3.372 40.272 149591 11.6 30.486 567 390.9 452.3 48.6 0.011 624 432 pg1419_o2nofp.cx10a_c24r64 796 4938 68121 532.0 2680.8 31.3 13.796 110.338 3.366 40.207 150049 11.7 30.389 569 390.9 454.7 48.6 0.010 624 448 pg1515_o2nofp.cx10a_c24r64 796 4931 68037 531.3 2686.2 31.3 13.797 110.322 3.373 40.258 149782 11.6 30.374 565 390.9 452.7 48.6 0.010 624 448 pg1611_o2nofp.cx10a_c24r64 796 4868 67194 525.5 2680.2 31.3 13.803 110.532 3.365 40.196 147939 12.0 30.389 592 390.9 454.7 48.6 0.010 608 432 pg177_o2nofp.cx10a_c24r64 796 4679 64656 505.5 2677.2 31.2 13.819 110.621 3.362 40.149 144145 12.2 30.807 626 390.9 454.7 48.6 0.668 608 288 pg181_o2nofp.cx10b_c24r64 796 4600 63630 497.8 2677.9 31.3 13.831 110.814 3.363 40.192 142125 12.2 30.894 636 390.9 454.9 46.3 0.213 608 208 pg181_o2nofp.cx10b_walsize_c24r64
qr500.L3
qr500.L3: range queries with 500 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 3982 88678 5707 45.7 5279.3 92.0 0.064 0.528 1.326 23.646 346856 39.4 3.911 107 391.9 455.9 43.3 0.048 11149 10398 pg1222_o2nofp.cx10a_c24r64 3982 88758 5857 47.6 5284.9 91.7 0.066 0.549 1.327 23.590 349271 39.1 3.935 106 391.4 455.4 48.0 0.056 11102 10398 pg1322_o2nofp.cx10a_c24r64 3982 90005 5813 46.8 5296.0 93.2 0.065 0.533 1.330 23.961 353645 38.8 3.929 103 391.3 455.4 48.6 0.051 11294 10494 pg1419_o2nofp.cx10a_c24r64 3982 88998 5726 46.0 5277.6 91.8 0.064 0.529 1.325 23.601 348880 39.4 3.920 106 391.2 455.2 48.6 0.039 11119 10479 pg1515_o2nofp.cx10a_c24r64 3982 89279 5713 46.0 5288.6 92.9 0.064 0.528 1.328 23.885 349373 39.6 3.913 106 391.1 455.1 48.6 0.053 11214 10511 pg1611_o2nofp.cx10a_c24r64 3984 88716 5736 46.9 5283.3 91.8 0.065 0.542 1.326 23.596 345729 39.7 3.897 107 391.1 455.1 48.6 0.052 11150 10430 pg177_o2nofp.cx10a_c24r64 3984 87743 5751 46.5 5281.4 91.8 0.066 0.543 1.325 23.597 342485 39.9 3.903 109 391.1 455.2 47.8 0.048 10926 10142 pg181_o2nofp.cx10b_c24r64 3982 87870 5816 50.3 5271.8 90.4 0.066 0.587 1.324 23.245 346588 39.6 3.944 108 391.1 455.1 46.0 0.084 11022 10334 pg181_o2nofp.cx10b_walsize_c24r64
qp500.L4
qp500.L4: point queries with 500 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 3982 4346 68483 535.0 9743.9 125.4 15.759 126.067 2.447 32.245 152180 20.9 35.019 1154 392.5 456.5 48.5 0.011 560 368 pg1222_o2nofp.cx10a_c24r64 3982 4088 65088 510.9 9722.4 125.5 15.921 127.979 2.441 32.274 146033 21.1 35.721 1239 391.9 455.9 47.6 0.659 528 176 pg1322_o2nofp.cx10a_c24r64 3984 4262 67392 527.0 9751.0 125.6 15.811 126.595 2.447 32.274 149211 20.7 35.006 1166 391.7 455.8 48.6 0.011 544 352 pg1419_o2nofp.cx10a_c24r64 3982 4324 68204 533.3 9757.0 125.6 15.773 126.303 2.450 32.292 150752 21.1 34.863 1171 391.4 455.5 48.6 0.012 560 368 pg1515_o2nofp.cx10a_c24r64 3982 4325 68202 533.2 9753.0 125.5 15.770 126.250 2.449 32.268 150138 21.4 34.716 1188 391.3 455.4 48.6 0.053 544 368 pg1611_o2nofp.cx10a_c24r64 3984 4055 64653 507.9 9640.2 124.6 15.944 128.268 2.419 32.017 143807 21.9 35.464 1296 391.3 455.4 48.6 0.308 528 144 pg177_o2nofp.cx10a_c24r64 3984 4232 66934 524.6 9733.7 125.4 15.817 126.947 2.443 32.223 146952 22.6 34.726 1282 391.4 455.4 48.0 0.016 528 368 pg181_o2nofp.cx10b_c24r64 3982 4234 66980 524.4 9738.8 125.4 15.821 126.831 2.446 32.235 147167 22.2 34.761 1258 391.4 455.4 46.1 0.017 544 352 pg181_o2nofp.cx10b_walsize_c24r64
qr1000.L5
qr1000.L5: range queries with 1000 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 7969 69060 10802 86.7 12460.3 198.5 0.156 1.286 1.564 25.504 274241 54.3 3.971 189 393.8 457.8 48.7 0.270 8750 7967 pg1222_o2nofp.cx10a_c24r64 7965 68762 10771 86.6 12449.4 198.0 0.157 1.289 1.563 25.453 270889 54.0 3.940 188 393.1 457.1 48.5 0.258 8750 7903 pg1322_o2nofp.cx10a_c24r64 7969 69886 10879 87.1 12449.2 197.9 0.156 1.277 1.562 25.431 277458 54.1 3.970 186 392.9 456.9 48.6 0.293 8863 8095 pg1419_o2nofp.cx10a_c24r64 7965 68585 10852 87.2 12439.2 197.8 0.158 1.302 1.562 25.429 272593 54.8 3.975 192 392.6 456.6 48.6 0.257 8719 7871 pg1515_o2nofp.cx10a_c24r64 7965 68220 10798 86.9 12440.3 197.9 0.158 1.304 1.562 25.443 269959 56.4 3.957 198 392.5 456.5 48.6 0.263 8654 7855 pg1611_o2nofp.cx10a_c24r64 7965 67324 10757 86.6 12502.8 198.3 0.160 1.317 1.570 25.500 263897 55.8 3.920 199 392.5 456.5 48.5 0.242 8558 7567 pg177_o2nofp.cx10a_c24r64 7969 66129 10909 89.5 12447.3 197.9 0.165 1.386 1.562 25.427 261421 56.9 3.953 207 392.5 456.6 48.6 0.280 8367 7519 pg181_o2nofp.cx10b_c24r64 7965 66887 10958 89.4 12444.6 197.9 0.164 1.368 1.562 25.440 263053 56.2 3.933 202 392.5 456.6 48.5 0.265 8471 7663 pg181_o2nofp.cx10b_walsize_c24r64
qp1000.L6
qp1000.L6: point queries with 1000 insert/s per client
Performance metrics for all DBMS, not just the ones listed above. Some are normalized by throughput, others are not. Legend for results is here.
ips qps rps rmbps wps wmbps rpq rkbpq wpi wkbpi csps cpups cspq cpupq dbgb1 dbgb2 rss maxop p50 p99 tag 7965 3684 68835 538.8 17205.5 236.4 18.685 149.761 2.160 30.393 155515 36.5 42.215 2378 395.5 459.5 48.7 0.021 464 320 pg1222_o2nofp.cx10a_c24r64 7965 3561 67051 525.2 17156.0 236.4 18.828 151.032 2.154 30.399 152134 36.7 42.720 2473 394.8 458.9 48.5 0.015 464 288 pg1322_o2nofp.cx10a_c24r64 7925 3462 65688 514.6 17028.7 234.5 18.977 152.241 2.149 30.306 149845 36.3 43.289 2517 394.6 458.7 48.6 0.337 448 80 pg1419_o2nofp.cx10a_c24r64 7947 3590 67346 528.2 17148.0 235.8 18.758 150.643 2.158 30.380 151662 37.3 42.243 2493 394.3 458.4 48.6 0.324 464 176 pg1515_o2nofp.cx10a_c24r64 7965 3692 68924 539.3 17212.3 236.6 18.671 149.606 2.161 30.425 153042 39.5 41.458 2568 394.2 458.2 48.6 0.018 464 336 pg1611_o2nofp.cx10a_c24r64 7965 3654 68303 535.3 17200.4 236.5 18.690 149.990 2.160 30.401 151466 39.9 41.447 2620 394.2 458.3 48.5 0.022 464 304 pg177_o2nofp.cx10a_c24r64 7965 3599 67735 533.0 17164.0 236.2 18.819 151.638 2.155 30.372 149852 40.8 41.635 2721 394.3 458.3 48.6 0.014 448 320 pg181_o2nofp.cx10b_c24r64 7960 3612 67804 531.4 17180.9 236.3 18.773 150.668 2.158 30.398 150125 40.2 41.566 2671 394.3 458.3 48.5 0.039 464 304 pg181_o2nofp.cx10b_walsize_c24r64
l.i0
- l.i0: load without secondary indexes
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 1.996 97.979 0.018 0.006 0.001 nonzero 0.000 0.000 0.000 0.853 pg1222_o2nofp.cx10a_c24r64 0.000 50.802 49.146 0.038 0.013 0.001 nonzero 0.000 0.000 0.000 0.480 pg1322_o2nofp.cx10a_c24r64 0.000 1.207 98.690 0.085 0.017 0.001 nonzero 0.000 0.000 0.000 0.513 pg1419_o2nofp.cx10a_c24r64 0.000 50.270 49.701 0.017 0.009 0.002 nonzero 0.000 0.000 0.000 0.510 pg1515_o2nofp.cx10a_c24r64 0.000 40.486 59.483 0.023 0.007 nonzero nonzero 0.000 0.000 0.000 0.438 pg1611_o2nofp.cx10a_c24r64 0.000 22.625 77.254 0.082 0.037 0.002 nonzero 0.000 0.000 0.000 0.450 pg177_o2nofp.cx10a_c24r64 0.000 25.879 74.086 0.026 0.008 nonzero nonzero 0.000 0.000 0.000 0.444 pg181_o2nofp.cx10b_c24r64 0.000 29.595 70.296 0.068 0.039 0.001 nonzero 0.000 0.000 0.000 0.456 pg181_o2nofp.cx10b_walsize_c24r64
l.x
- l.x: create secondary indexes
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
TODO - determine whether there is data for create index response time
l.i1
- l.i1: continue load after secondary indexes created with 50 inserts per transaction
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 77.891 22.108 0.000 0.001 0.000 0.000 0.000 0.437 pg1222_o2nofp.cx10a_c24r64 0.000 0.000 0.000 74.461 25.524 0.016 0.000 0.000 0.000 0.000 0.190 pg1322_o2nofp.cx10a_c24r64 0.000 0.000 0.000 77.030 22.955 0.015 0.000 0.000 0.000 0.000 0.131 pg1419_o2nofp.cx10a_c24r64 0.000 0.000 0.000 78.254 21.737 0.009 nonzero 0.000 0.000 0.000 0.262 pg1515_o2nofp.cx10a_c24r64 0.000 0.000 0.000 83.109 16.878 0.012 nonzero 0.000 0.000 0.000 0.451 pg1611_o2nofp.cx10a_c24r64 0.000 0.000 0.000 82.874 17.118 0.008 0.000 0.000 0.000 0.000 0.093 pg177_o2nofp.cx10a_c24r64 0.000 0.000 0.000 78.647 21.016 0.290 0.048 nonzero 0.000 0.000 2.409 pg181_o2nofp.cx10b_c24r64 0.000 0.000 0.000 81.819 18.172 0.009 0.000 0.000 0.000 0.000 0.102 pg181_o2nofp.cx10b_walsize_c24r64
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 1.156 7.457 31.308 60.078 0.000 0.001 0.000 0.000 0.000 0.431 pg1222_o2nofp.cx10a_c24r64 0.000 1.190 8.650 28.205 61.948 0.006 0.000 0.000 0.000 0.000 0.111 pg1322_o2nofp.cx10a_c24r64 0.000 1.280 7.319 33.414 57.984 0.004 0.000 0.000 0.000 0.000 0.078 pg1419_o2nofp.cx10a_c24r64 0.000 1.144 6.970 26.148 65.733 0.004 0.000 0.000 0.000 0.000 0.244 pg1515_o2nofp.cx10a_c24r64 0.000 1.048 6.440 21.953 70.556 0.003 0.000 0.000 0.000 0.000 0.090 pg1611_o2nofp.cx10a_c24r64 0.000 0.989 6.390 20.822 71.795 0.004 0.000 0.000 0.000 0.000 0.085 pg177_o2nofp.cx10a_c24r64 0.000 0.779 6.533 19.977 72.702 0.009 0.000 0.000 0.000 0.000 0.251 pg181_o2nofp.cx10b_c24r64 0.000 0.846 6.246 20.996 71.907 0.006 0.000 0.000 0.000 0.000 0.093 pg181_o2nofp.cx10b_walsize_c24r64
l.i2
- l.i2: continue load after secondary indexes created with 5 inserts per transaction
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 16.043 83.956 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg1222_o2nofp.cx10a_c24r64 0.000 20.713 79.278 0.009 0.000 0.000 0.000 0.000 0.000 0.000 0.014 pg1322_o2nofp.cx10a_c24r64 0.000 17.116 82.883 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg1419_o2nofp.cx10a_c24r64 0.000 12.683 87.316 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg1515_o2nofp.cx10a_c24r64 0.000 18.499 81.501 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg1611_o2nofp.cx10a_c24r64 0.000 14.263 85.538 0.113 0.070 0.016 0.000 0.000 0.000 0.000 0.146 pg177_o2nofp.cx10a_c24r64 0.000 13.469 86.530 0.001 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg181_o2nofp.cx10b_c24r64 0.000 12.749 87.248 0.003 nonzero 0.000 0.000 0.000 0.000 0.000 0.022 pg181_o2nofp.cx10b_walsize_c24r64
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 0.000 99.999 0.001 0.000 0.000 0.000 0.000 0.150 pg1222_o2nofp.cx10a_c24r64 0.002 0.881 1.059 11.445 86.613 nonzero 0.000 0.000 0.000 0.000 0.152 pg1322_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.000 99.999 0.001 0.000 0.000 0.000 0.000 0.191 pg1419_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.000 99.847 0.153 0.000 0.000 0.000 0.000 0.156 pg1515_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.000 99.998 0.002 0.000 0.000 0.000 0.000 0.176 pg1611_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.000 99.998 0.002 0.000 0.000 0.000 0.000 0.161 pg177_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.000 99.999 0.001 0.000 0.000 0.000 0.000 0.160 pg181_o2nofp.cx10b_c24r64 0.000 0.000 0.000 0.000 99.999 0.001 0.000 0.000 0.000 0.000 0.160 pg181_o2nofp.cx10b_walsize_c24r64
qr100.L1
- qr100.L1: range queries with 100 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.994 0.006 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1222_o2nofp.cx10a_c24r64 99.993 0.007 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg1322_o2nofp.cx10a_c24r64 99.994 0.006 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.002 pg1419_o2nofp.cx10a_c24r64 99.995 0.005 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1515_o2nofp.cx10a_c24r64 99.994 0.006 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg1611_o2nofp.cx10a_c24r64 99.995 0.005 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg177_o2nofp.cx10a_c24r64 99.994 0.006 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg181_o2nofp.cx10b_c24r64 99.990 0.010 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg181_o2nofp.cx10b_walsize_c24r64
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 99.934 0.066 0.000 0.000 0.000 0.000 0.000 0.019 pg1222_o2nofp.cx10a_c24r64 0.000 0.000 0.000 98.681 1.319 0.000 0.000 0.000 0.000 0.000 0.023 pg1322_o2nofp.cx10a_c24r64 0.000 0.000 0.000 99.819 0.181 0.000 0.000 0.000 0.000 0.000 0.021 pg1419_o2nofp.cx10a_c24r64 0.000 0.000 0.000 99.868 0.132 0.000 0.000 0.000 0.000 0.000 0.021 pg1515_o2nofp.cx10a_c24r64 0.000 0.000 0.000 99.885 0.115 0.000 0.000 0.000 0.000 0.000 0.020 pg1611_o2nofp.cx10a_c24r64 0.000 0.000 0.000 99.924 0.076 0.000 0.000 0.000 0.000 0.000 0.020 pg177_o2nofp.cx10a_c24r64 0.000 0.000 0.000 99.819 0.181 0.000 0.000 0.000 0.000 0.000 0.021 pg181_o2nofp.cx10b_c24r64 0.000 0.000 0.000 99.812 0.188 0.000 0.000 0.000 0.000 0.000 0.056 pg181_o2nofp.cx10b_walsize_c24r64
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 26.049 73.951 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.003 pg1222_o2nofp.cx10a_c24r64 0.000 25.247 74.740 0.014 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg1322_o2nofp.cx10a_c24r64 0.000 24.899 75.101 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg1419_o2nofp.cx10a_c24r64 0.000 27.809 72.191 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg1515_o2nofp.cx10a_c24r64 0.000 22.420 77.576 0.003 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg1611_o2nofp.cx10a_c24r64 0.000 24.552 75.448 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg177_o2nofp.cx10a_c24r64 0.000 19.719 80.260 0.021 0.000 0.000 0.000 0.000 0.000 0.000 0.005 pg181_o2nofp.cx10b_c24r64 0.000 19.604 80.396 0.000 0.000 0.000 0.000 0.000 0.000 0.000 0.004 pg181_o2nofp.cx10b_walsize_c24r64
qp100.L2
- qp100.L2: point queries with 100 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 1.540 98.031 0.394 0.025 0.011 0.000 0.000 0.000 0.000 0.228 pg1222_o2nofp.cx10a_c24r64 0.000 1.485 98.475 0.040 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg1322_o2nofp.cx10a_c24r64 0.000 1.655 98.324 0.021 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg1419_o2nofp.cx10a_c24r64 0.000 1.714 98.266 0.020 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg1515_o2nofp.cx10a_c24r64 0.000 1.645 98.338 0.016 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg1611_o2nofp.cx10a_c24r64 0.000 1.458 98.520 0.021 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg177_o2nofp.cx10a_c24r64 0.000 1.205 98.488 0.275 0.024 0.008 nonzero 0.000 0.000 0.000 0.668 pg181_o2nofp.cx10b_c24r64 0.000 1.160 98.424 0.358 0.046 0.010 0.000 0.000 0.000 0.000 0.213 pg181_o2nofp.cx10b_walsize_c24r64
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 51.028 48.111 0.799 0.062 0.000 0.000 0.000 0.354 pg1222_o2nofp.cx10a_c24r64 0.000 0.000 0.000 27.201 72.799 0.000 0.000 0.000 0.000 0.000 0.033 pg1322_o2nofp.cx10a_c24r64 0.000 0.000 0.000 58.153 41.847 0.000 0.000 0.000 0.000 0.000 0.032 pg1419_o2nofp.cx10a_c24r64 0.000 0.000 0.000 40.337 59.663 0.000 0.000 0.000 0.000 0.000 0.028 pg1515_o2nofp.cx10a_c24r64 0.000 0.000 0.000 50.931 49.069 0.000 0.000 0.000 0.000 0.000 0.025 pg1611_o2nofp.cx10a_c24r64 0.000 0.000 0.000 48.674 51.326 0.000 0.000 0.000 0.000 0.000 0.027 pg177_o2nofp.cx10a_c24r64 0.000 0.000 0.000 58.885 40.517 0.500 0.097 0.000 0.000 0.000 0.341 pg181_o2nofp.cx10b_c24r64 0.000 0.000 0.000 45.514 53.434 1.010 0.042 0.000 0.000 0.000 0.395 pg181_o2nofp.cx10b_walsize_c24r64
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 79.191 20.729 0.080 0.000 0.000 0.000 0.000 0.000 0.051 pg1222_o2nofp.cx10a_c24r64 0.000 0.000 72.868 27.128 0.003 0.000 0.000 0.000 0.000 0.000 0.016 pg1322_o2nofp.cx10a_c24r64 0.000 0.000 81.698 18.299 0.003 0.000 0.000 0.000 0.000 0.000 0.016 pg1419_o2nofp.cx10a_c24r64 0.000 0.000 78.715 21.278 0.007 0.000 0.000 0.000 0.000 0.000 0.017 pg1515_o2nofp.cx10a_c24r64 0.000 0.000 68.295 31.705 0.000 0.000 0.000 0.000 0.000 0.000 0.015 pg1611_o2nofp.cx10a_c24r64 0.000 0.000 66.233 33.764 0.003 0.000 0.000 0.000 0.000 0.000 0.016 pg177_o2nofp.cx10a_c24r64 0.000 0.000 65.656 34.253 0.083 0.007 0.000 0.000 0.000 0.000 0.075 pg181_o2nofp.cx10b_c24r64 0.000 0.000 63.701 36.222 0.076 0.000 0.000 0.000 0.000 0.000 0.063 pg181_o2nofp.cx10b_walsize_c24r64
qr500.L3
- qr500.L3: range queries with 500 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.913 0.086 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.048 pg1222_o2nofp.cx10a_c24r64 99.923 0.076 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.056 pg1322_o2nofp.cx10a_c24r64 99.928 0.071 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.051 pg1419_o2nofp.cx10a_c24r64 99.904 0.095 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.039 pg1515_o2nofp.cx10a_c24r64 99.906 0.093 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.053 pg1611_o2nofp.cx10a_c24r64 99.906 0.094 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.052 pg177_o2nofp.cx10a_c24r64 99.895 0.104 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.048 pg181_o2nofp.cx10b_c24r64 99.933 0.067 0.001 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.084 pg181_o2nofp.cx10b_walsize_c24r64
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 67.018 32.978 0.004 0.000 0.000 0.000 0.000 0.069 pg1222_o2nofp.cx10a_c24r64 0.000 0.000 0.000 58.610 41.348 0.033 0.008 0.000 0.000 0.000 0.281 pg1322_o2nofp.cx10a_c24r64 0.000 0.000 0.000 63.742 36.258 0.000 0.000 0.000 0.000 0.000 0.042 pg1419_o2nofp.cx10a_c24r64 0.000 0.000 0.000 85.190 14.810 0.000 0.000 0.000 0.000 0.000 0.036 pg1515_o2nofp.cx10a_c24r64 0.000 0.000 0.000 86.536 13.460 0.003 0.000 0.000 0.000 0.000 0.071 pg1611_o2nofp.cx10a_c24r64 0.000 0.000 0.000 84.474 15.519 0.001 0.006 0.000 0.000 0.000 0.317 pg177_o2nofp.cx10a_c24r64 0.000 0.000 0.000 80.472 19.528 0.000 0.000 0.000 0.000 0.000 0.063 pg181_o2nofp.cx10b_c24r64 0.000 0.000 0.000 77.373 22.203 0.359 0.065 0.000 0.000 0.000 0.485 pg181_o2nofp.cx10b_walsize_c24r64
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 3.980 78.303 17.717 0.000 0.000 0.000 0.000 0.000 0.042 pg1222_o2nofp.cx10a_c24r64 0.000 0.000 3.385 88.246 8.369 0.000 0.000 0.000 0.000 0.000 0.026 pg1322_o2nofp.cx10a_c24r64 0.000 0.000 3.444 90.542 6.015 0.000 0.000 0.000 0.000 0.000 0.026 pg1419_o2nofp.cx10a_c24r64 0.000 0.000 2.849 74.910 22.241 0.000 0.000 0.000 0.000 0.000 0.034 pg1515_o2nofp.cx10a_c24r64 0.000 0.000 1.106 70.837 28.055 0.002 0.000 0.000 0.000 0.000 0.070 pg1611_o2nofp.cx10a_c24r64 0.000 0.000 1.105 69.254 29.637 0.004 0.000 0.000 0.000 0.000 0.066 pg177_o2nofp.cx10a_c24r64 0.000 0.000 0.513 70.298 29.189 0.000 0.000 0.000 0.000 0.000 0.061 pg181_o2nofp.cx10b_c24r64 0.000 0.000 1.789 74.375 23.835 0.001 0.000 0.000 0.000 0.000 0.087 pg181_o2nofp.cx10b_walsize_c24r64
qp500.L4
- qp500.L4: point queries with 500 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.702 98.992 0.307 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg1222_o2nofp.cx10a_c24r64 0.000 0.443 98.711 0.814 0.026 0.007 nonzero 0.000 0.000 0.000 0.659 pg1322_o2nofp.cx10a_c24r64 0.000 0.558 99.082 0.361 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg1419_o2nofp.cx10a_c24r64 0.000 0.641 99.086 0.273 0.000 0.000 0.000 0.000 0.000 0.000 0.012 pg1515_o2nofp.cx10a_c24r64 0.000 0.619 99.132 0.249 nonzero 0.000 0.000 0.000 0.000 0.000 0.053 pg1611_o2nofp.cx10a_c24r64 0.000 0.462 98.352 1.122 0.053 0.011 nonzero 0.000 0.000 0.000 0.308 pg177_o2nofp.cx10a_c24r64 0.000 0.491 99.181 0.328 0.000 0.000 0.000 0.000 0.000 0.000 0.016 pg181_o2nofp.cx10b_c24r64 0.000 0.483 99.231 0.286 nonzero 0.000 0.000 0.000 0.000 0.000 0.017 pg181_o2nofp.cx10b_walsize_c24r64
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 18.604 81.394 0.001 0.000 0.000 0.000 0.000 0.076 pg1222_o2nofp.cx10a_c24r64 0.000 0.000 0.000 18.116 81.621 0.263 0.000 0.000 0.000 0.000 0.238 pg1322_o2nofp.cx10a_c24r64 0.000 0.000 0.000 18.628 81.369 0.002 0.000 0.000 0.000 0.000 0.083 pg1419_o2nofp.cx10a_c24r64 0.000 0.000 0.000 24.955 75.045 0.000 0.000 0.000 0.000 0.000 0.058 pg1515_o2nofp.cx10a_c24r64 0.000 0.000 0.000 29.492 70.503 0.005 0.000 0.000 0.000 0.000 0.072 pg1611_o2nofp.cx10a_c24r64 0.000 0.000 0.000 22.312 77.038 0.583 0.067 0.000 0.000 0.000 0.584 pg177_o2nofp.cx10a_c24r64 0.000 0.000 0.000 21.614 78.384 0.002 0.000 0.000 0.000 0.000 0.089 pg181_o2nofp.cx10b_c24r64 0.000 0.000 0.000 34.326 65.673 0.001 0.000 0.000 0.000 0.000 0.079 pg181_o2nofp.cx10b_walsize_c24r64
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 2.003 97.991 0.006 0.000 0.000 0.000 0.000 0.079 pg1222_o2nofp.cx10a_c24r64 0.000 0.000 0.000 1.186 98.804 0.010 0.000 0.000 0.000 0.000 0.083 pg1322_o2nofp.cx10a_c24r64 0.000 0.000 0.000 5.828 94.165 0.007 0.000 0.000 0.000 0.000 0.081 pg1419_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.574 99.421 0.006 0.000 0.000 0.000 0.000 0.086 pg1515_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.090 99.903 0.007 0.000 0.000 0.000 0.000 0.081 pg1611_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.353 99.606 0.041 0.000 0.000 0.000 0.000 0.174 pg177_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.060 99.934 0.006 0.000 0.000 0.000 0.000 0.084 pg181_o2nofp.cx10b_c24r64 0.000 0.000 0.000 0.496 99.499 0.006 0.000 0.000 0.000 0.000 0.081 pg181_o2nofp.cx10b_walsize_c24r64
qr1000.L5
- qr1000.L5: range queries with 1000 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.228 0.766 0.005 0.001 nonzero nonzero nonzero 0.000 0.000 0.000 0.270 pg1222_o2nofp.cx10a_c24r64 99.338 0.657 0.005 0.001 nonzero nonzero nonzero 0.000 0.000 0.000 0.258 pg1322_o2nofp.cx10a_c24r64 99.334 0.661 0.005 0.001 nonzero nonzero nonzero 0.000 0.000 0.000 0.293 pg1419_o2nofp.cx10a_c24r64 98.794 1.200 0.005 0.001 nonzero nonzero nonzero 0.000 0.000 0.000 0.257 pg1515_o2nofp.cx10a_c24r64 98.997 0.997 0.004 0.001 nonzero nonzero nonzero 0.000 0.000 0.000 0.263 pg1611_o2nofp.cx10a_c24r64 98.755 1.240 0.005 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.242 pg177_o2nofp.cx10a_c24r64 98.662 1.333 0.004 0.001 nonzero nonzero nonzero 0.000 0.000 0.000 0.280 pg181_o2nofp.cx10b_c24r64 98.941 1.053 0.005 0.001 nonzero nonzero nonzero 0.000 0.000 0.000 0.265 pg181_o2nofp.cx10b_walsize_c24r64
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 58.753 41.247 0.000 0.000 0.000 0.000 0.000 0.036 pg1222_o2nofp.cx10a_c24r64 0.000 0.000 0.000 56.142 43.858 0.000 0.000 0.000 0.000 0.000 0.044 pg1322_o2nofp.cx10a_c24r64 0.000 0.000 0.000 58.432 41.568 0.000 0.000 0.000 0.000 0.000 0.037 pg1419_o2nofp.cx10a_c24r64 0.000 0.000 0.000 64.554 35.446 0.000 0.000 0.000 0.000 0.000 0.034 pg1515_o2nofp.cx10a_c24r64 0.000 0.000 0.000 70.139 29.861 0.000 0.000 0.000 0.000 0.000 0.048 pg1611_o2nofp.cx10a_c24r64 0.000 0.000 0.000 68.598 31.399 0.003 0.000 0.000 0.000 0.000 0.146 pg177_o2nofp.cx10a_c24r64 0.000 0.000 0.000 70.907 29.091 0.002 0.000 0.000 0.000 0.000 0.072 pg181_o2nofp.cx10b_c24r64 0.000 0.000 0.000 65.612 34.387 0.000 0.000 0.000 0.000 0.000 0.061 pg181_o2nofp.cx10b_walsize_c24r64
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 0.649 99.348 0.003 0.000 0.000 0.000 0.000 0.124 pg1222_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.702 99.295 0.003 0.000 0.000 0.000 0.000 0.121 pg1322_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.936 99.061 0.003 0.000 0.000 0.000 0.000 0.119 pg1419_o2nofp.cx10a_c24r64 0.000 0.000 0.000 1.289 98.708 0.003 0.000 0.000 0.000 0.000 0.131 pg1515_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.040 99.957 0.003 0.000 0.000 0.000 0.000 0.126 pg1611_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.165 99.830 0.005 0.000 0.000 0.000 0.000 0.132 pg177_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.037 99.960 0.003 0.000 0.000 0.000 0.000 0.124 pg181_o2nofp.cx10b_c24r64 0.000 0.000 0.000 0.014 99.983 0.003 0.000 0.000 0.000 0.000 0.130 pg181_o2nofp.cx10b_walsize_c24r64
qp1000.L6
- qp1000.L6: point queries with 1000 insert/s per client
- Legend for results is here.
- Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.164 98.294 1.541 nonzero 0.000 0.000 0.000 0.000 0.000 0.021 pg1222_o2nofp.cx10a_c24r64 0.000 0.125 97.509 2.367 0.000 0.000 0.000 0.000 0.000 0.000 0.015 pg1322_o2nofp.cx10a_c24r64 0.000 0.102 97.297 2.525 0.064 0.012 nonzero 0.000 0.000 0.000 0.337 pg1419_o2nofp.cx10a_c24r64 0.000 0.094 98.611 1.270 0.018 0.007 nonzero 0.000 0.000 0.000 0.324 pg1515_o2nofp.cx10a_c24r64 0.000 0.139 98.535 1.326 nonzero 0.000 0.000 0.000 0.000 0.000 0.018 pg1611_o2nofp.cx10a_c24r64 0.000 0.123 98.517 1.360 nonzero 0.000 0.000 0.000 0.000 0.000 0.022 pg177_o2nofp.cx10a_c24r64 0.000 0.097 98.439 1.464 0.000 0.000 0.000 0.000 0.000 0.000 0.014 pg181_o2nofp.cx10b_c24r64 0.000 0.102 98.477 1.421 nonzero 0.000 0.000 0.000 0.000 0.000 0.039 pg181_o2nofp.cx10b_walsize_c24r64
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 19.860 80.140 0.000 0.000 0.000 0.000 0.000 0.053 pg1222_o2nofp.cx10a_c24r64 0.000 0.000 0.000 14.507 85.493 0.000 0.000 0.000 0.000 0.000 0.054 pg1322_o2nofp.cx10a_c24r64 0.000 0.000 0.000 24.945 74.441 0.568 0.046 0.000 0.000 0.000 0.516 pg1419_o2nofp.cx10a_c24r64 0.000 0.000 0.000 52.728 47.121 0.125 0.026 0.000 0.000 0.000 0.568 pg1515_o2nofp.cx10a_c24r64 0.000 0.000 0.000 29.976 70.024 0.000 0.000 0.000 0.000 0.000 0.044 pg1611_o2nofp.cx10a_c24r64 0.000 0.000 0.000 30.391 69.609 0.000 0.000 0.000 0.000 0.000 0.039 pg177_o2nofp.cx10a_c24r64 0.000 0.000 0.000 26.950 73.050 0.000 0.000 0.000 0.000 0.000 0.051 pg181_o2nofp.cx10b_c24r64 0.000 0.000 0.000 24.902 75.098 0.000 0.000 0.000 0.000 0.000 0.060 pg181_o2nofp.cx10b_walsize_c24r64
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 0.000 0.000 99.997 0.003 0.000 0.000 0.000 0.000 0.170 pg1222_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.000 99.997 0.003 0.000 0.000 0.000 0.000 0.165 pg1322_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.000 99.963 0.037 0.000 0.000 0.000 0.000 0.168 pg1419_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.000 99.980 0.020 0.000 0.000 0.000 0.000 0.179 pg1515_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.000 99.996 0.004 0.000 0.000 0.000 0.000 0.175 pg1611_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.000 99.997 0.003 0.000 0.000 0.000 0.000 0.161 pg177_o2nofp.cx10a_c24r64 0.000 0.000 0.000 0.000 99.997 0.003 0.000 0.000 0.000 0.000 0.170 pg181_o2nofp.cx10b_c24r64 0.000 0.000 0.000 0.000 99.997 0.003 0.000 0.000 0.000 0.000 0.177 pg181_o2nofp.cx10b_walsize_c24r64