This is a report for the insert benchmark with 200M docs and 20 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 is an ax162-s from Hetzner (see here) with 48 cores, AMD SMT disabled, 128G RAM and ext4 using 2 NVMe devices with SW RAID 1. The benchmark was run with 20 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 10M rows per table without secondary indexes, creates 3 secondary indexes per table, then inserts 16m+4m 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 cached in memory. Clients and the DBMS share one server.
The tested DBMS are:
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 |
---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 1666667 | 2597404 | 383234 | 94007 | 390692 | 128510 | 375186 | 127739 | 370418 | 126017 |
pg164_o2nofp.cx9a2a_c32r128 | 1652892 | 2597404 | 384615 | 98280 | 392699 | 128251 | 383376 | 127213 | 377223 | 125792 |
pg17beta3_o2nofp.cx9a2a_c32r128 | 1694915 | 2739727 | 397022 | 101652 | 392546 | 128510 | 378062 | 127254 | 375401 | 125869 |
pg17rc1_o2nofp.cx9a2a_c32r128 | 1709402 | 2816903 | 393120 | 104167 | 387796 | 127752 | 374957 | 126889 | 370957 | 125252 |
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 |
---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 | 1.00 |
pg164_o2nofp.cx9a2a_c32r128 | 0.99 | 1.00 | 1.00 | 1.05 | 1.01 | 1.00 | 1.02 | 1.00 | 1.02 | 1.00 |
pg17beta3_o2nofp.cx9a2a_c32r128 | 1.02 | 1.05 | 1.04 | 1.08 | 1.00 | 1.00 | 1.01 | 1.00 | 1.01 | 1.00 |
pg17rc1_o2nofp.cx9a2a_c32r128 | 1.03 | 1.08 | 1.03 | 1.11 | 0.99 | 0.99 | 1.00 | 0.99 | 1.00 | 0.99 |
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 |
---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 1977 | 1977 | 9885 | 9885 | 19758 | 19769 |
pg164_o2nofp.cx9a2a_c32r128 | 1977 | 1977 | 9885 | 9885 | 19758 | 19769 |
pg17beta3_o2nofp.cx9a2a_c32r128 | 1978 | 1977 | 9885 | 9885 | 19758 | 19769 |
pg17rc1_o2nofp.cx9a2a_c32r128 | 1977 | 1977 | 9885 | 9885 | 19758 | 19769 |
target | 2000 | 2000 | 10000 | 10000 | 20000 | 20000 |
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 92.282 | 7.675 | 0.021 | 0.004 | 0.010 | 0.007 | 0.648 | ||||
pg164_o2nofp.cx9a2a_c32r128 | 92.427 | 7.527 | 0.027 | 0.004 | 0.007 | 0.008 | 0.741 | ||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 92.966 | 6.986 | 0.025 | 0.006 | 0.008 | 0.009 | 0.489 | ||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 93.049 | 6.901 | 0.030 | 0.007 | 0.010 | 0.004 | 0.539 |
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 1666667 0 1 0.0 6631.3 698.9 0.000 0.000 0.004 0.429 254940 46.0 0.153 13 19.1 51.7 1.9 0.648 110482 30967 pg158_o2nofp.cx9a2a_c32r128 1652892 0 2 0.0 6655.7 704.0 0.000 0.000 0.004 0.436 260915 45.6 0.158 13 19.1 51.7 1.9 0.741 111712 44751 pg164_o2nofp.cx9a2a_c32r128 1694915 0 3 0.0 6699.9 706.9 0.000 0.000 0.004 0.427 265066 45.3 0.156 13 19.1 51.7 1.4 0.489 112778 47449 pg17beta3_o2nofp.cx9a2a_c32r128 1709402 0 0 0.0 6770.0 718.3 0.000 0.000 0.004 0.430 274194 46.8 0.160 13 19.1 51.7 12.2 0.539 112979 49047 pg17rc1_o2nofp.cx9a2a_c32r128
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 2597404 0 0 0.0 6280.5 724.0 0.000 0.000 0.002 0.285 105828 17.8 0.041 3 38.4 88.6 6.9 0.045 NA NA pg158_o2nofp.cx9a2a_c32r128 2597404 0 0 0.0 6171.7 713.0 0.000 0.000 0.002 0.281 105324 17.9 0.041 3 38.4 88.6 6.3 0.044 NA NA pg164_o2nofp.cx9a2a_c32r128 2739727 0 1 0.0 6884.0 797.9 0.000 0.000 0.003 0.298 40487 17.1 0.015 3 38.4 88.5 6.4 0.044 NA NA pg17beta3_o2nofp.cx9a2a_c32r128 2816903 0 0 0.0 7336.8 855.7 0.000 0.000 0.003 0.311 42161 17.9 0.015 3 38.4 88.5 6.4 0.036 NA NA pg17rc1_o2nofp.cx9a2a_c32r128
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 1.481 | 91.183 | 6.776 | 0.554 | 0.006 | nonzero | 0.457 | ||||
pg164_o2nofp.cx9a2a_c32r128 | 1.463 | 90.793 | 7.211 | 0.526 | 0.007 | 0.144 | |||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 1.512 | 90.550 | 7.418 | 0.516 | 0.004 | 0.001 | 0.435 | ||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 1.711 | 90.375 | 7.379 | 0.530 | 0.005 | 0.001 | 0.696 |
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 17.343 | 79.280 | 3.103 | 0.270 | 0.004 | 0.236 | |||||
pg164_o2nofp.cx9a2a_c32r128 | 17.560 | 79.204 | 3.000 | 0.233 | 0.003 | 0.145 | |||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 22.012 | 74.851 | 2.899 | 0.235 | 0.003 | nonzero | 0.432 | ||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 21.586 | 75.302 | 2.879 | 0.229 | 0.003 | nonzero | 0.692 |
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 383234 0 932 5.5 6402.0 594.5 0.002 0.015 0.017 1.588 263431 54.8 0.687 69 56.4 152.4 42.5 0.457 22109 3946 pg158_o2nofp.cx9a2a_c32r128 384615 0 704 3.2 6213.6 589.1 0.002 0.009 0.016 1.568 270915 54.9 0.704 69 56.0 152.0 49.8 0.144 22076 3796 pg164_o2nofp.cx9a2a_c32r128 397022 0 644 2.9 6517.7 622.2 0.002 0.008 0.016 1.605 255362 53.6 0.643 65 56.0 152.0 38.7 0.435 22925 3246 pg17beta3_o2nofp.cx9a2a_c32r128 393120 0 631 2.9 6440.2 612.9 0.002 0.008 0.016 1.597 259091 53.0 0.659 65 56.1 152.1 8.7 0.696 22833 3346 pg17rc1_o2nofp.cx9a2a_c32r128
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 86.515 | 12.707 | 0.759 | 0.018 | nonzero | 0.032 | |||||
pg164_o2nofp.cx9a2a_c32r128 | 86.882 | 12.298 | 0.800 | 0.019 | nonzero | nonzero | 0.072 | ||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 89.994 | 9.644 | 0.345 | 0.017 | nonzero | 0.060 | |||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 90.301 | 9.346 | 0.340 | 0.013 | nonzero | nonzero | 0.064 |
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 2.689 | 47.820 | 49.470 | 0.021 | nonzero | 0.026 | |||||
pg164_o2nofp.cx9a2a_c32r128 | 2.912 | 47.843 | 49.218 | 0.026 | 0.001 | nonzero | 0.073 | ||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 3.694 | 58.911 | 37.332 | 0.063 | 0.001 | 0.061 | |||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 3.545 | 57.307 | 39.092 | 0.055 | 0.001 | nonzero | 0.064 |
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 94007 0 0 0.0 1418.9 135.4 0.000 0.000 0.015 1.475 383097 52.7 4.075 269 56.6 152.7 8.9 0.032 4001 3018 pg158_o2nofp.cx9a2a_c32r128 98280 0 0 0.0 1482.5 142.0 0.000 0.000 0.015 1.480 400824 54.4 4.078 266 56.2 152.3 6.3 0.072 4466 3311 pg164_o2nofp.cx9a2a_c32r128 101652 0 1 0.0 1496.9 143.1 0.000 0.000 0.015 1.442 385029 52.4 3.788 247 56.2 152.3 17.1 0.060 4800 3256 pg17beta3_o2nofp.cx9a2a_c32r128 104167 0 1 0.0 1559.2 147.9 0.000 0.000 0.015 1.454 392508 54.1 3.768 249 56.3 152.4 16.3 0.064 4483 3323 pg17rc1_o2nofp.cx9a2a_c32r128
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 99.997 | 0.002 | 0.001 | nonzero | nonzero | 0.017 | |||||
pg164_o2nofp.cx9a2a_c32r128 | 99.997 | 0.002 | 0.001 | nonzero | 0.010 | ||||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 99.997 | 0.002 | 0.001 | nonzero | nonzero | 0.028 | |||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 99.996 | 0.002 | 0.001 | nonzero | 0.012 |
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 99.612 | 0.383 | 0.004 | 0.023 | |||||||
pg164_o2nofp.cx9a2a_c32r128 | 0.001 | 99.672 | 0.326 | 0.011 | |||||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 0.001 | 99.688 | 0.307 | 0.004 | 0.029 | ||||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 0.004 | 99.722 | 0.268 | 0.006 | 0.023 |
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 66.736 | 33.233 | 0.029 | 0.001 | 0.023 | ||||||
pg164_o2nofp.cx9a2a_c32r128 | 69.793 | 30.185 | 0.022 | 0.006 | |||||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 68.083 | 31.897 | 0.017 | 0.003 | 0.029 | ||||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 67.436 | 32.539 | 0.021 | 0.004 | 0.025 |
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 1977 390692 0 0.0 122.2 10.4 0.000 0.000 0.062 5.388 1484857 42.6 3.801 52 56.6 152.7 0.5 0.017 20065 18412 pg158_o2nofp.cx9a2a_c32r128 1977 392699 0 0.0 120.9 10.4 0.000 0.000 0.061 5.401 1492924 42.5 3.802 52 56.2 152.2 2.0 0.010 19659 18043 pg164_o2nofp.cx9a2a_c32r128 1978 392546 1 0.0 121.6 10.4 0.000 0.000 0.061 5.409 1490918 42.5 3.798 52 56.2 152.3 0.5 0.028 19818 18108 pg17beta3_o2nofp.cx9a2a_c32r128 1977 387796 0 0.0 129.2 10.5 0.000 0.000 0.065 5.421 1474076 42.6 3.801 53 56.3 152.4 0.5 0.012 19691 18147 pg17rc1_o2nofp.cx9a2a_c32r128
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 99.702 | 0.237 | 0.062 | nonzero | 0.012 | ||||||
pg164_o2nofp.cx9a2a_c32r128 | 99.706 | 0.228 | 0.066 | nonzero | 0.007 | ||||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 99.717 | 0.220 | 0.062 | nonzero | 0.009 | ||||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 99.711 | 0.225 | 0.064 | nonzero | 0.008 |
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 99.492 | 0.508 | 0.013 | ||||||||
pg164_o2nofp.cx9a2a_c32r128 | 99.656 | 0.344 | 0.009 | ||||||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 99.656 | 0.344 | 0.011 | ||||||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 99.643 | 0.357 | 0.009 |
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 7.032 | 92.865 | 0.103 | 0.011 | |||||||
pg164_o2nofp.cx9a2a_c32r128 | 1.781 | 98.133 | 0.086 | 0.009 | |||||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 21.272 | 78.643 | 0.085 | 0.010 | |||||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 1.146 | 98.768 | 0.086 | 0.009 |
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 1977 128510 0 0.0 358.0 18.0 0.000 0.000 0.181 9.324 515516 44.4 4.012 166 56.6 149.5 0.5 0.012 6521 6393 pg158_o2nofp.cx9a2a_c32r128 1977 128251 0 0.0 343.8 17.9 0.000 0.000 0.174 9.247 513863 44.6 4.007 167 56.2 149.1 2.4 0.007 6521 6378 pg164_o2nofp.cx9a2a_c32r128 1977 128510 1 0.0 343.4 17.9 0.000 0.000 0.174 9.250 515352 44.5 4.010 166 56.2 149.2 0.5 0.009 6548 6407 pg17beta3_o2nofp.cx9a2a_c32r128 1977 127752 0 0.0 342.1 17.8 0.000 0.000 0.173 9.243 511978 44.7 4.008 168 56.3 149.2 0.5 0.008 6475 6345 pg17rc1_o2nofp.cx9a2a_c32r128
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 99.987 | 0.006 | 0.007 | nonzero | nonzero | 0.060 | |||||
pg164_o2nofp.cx9a2a_c32r128 | 99.987 | 0.006 | 0.007 | nonzero | nonzero | nonzero | 0.077 | ||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 99.987 | 0.006 | 0.007 | nonzero | nonzero | 0.026 | |||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 99.987 | 0.006 | 0.007 | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 4.269 | 94.575 | 1.127 | 0.028 | 0.033 | ||||||
pg164_o2nofp.cx9a2a_c32r128 | 4.631 | 94.353 | 0.975 | 0.041 | 0.038 | ||||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 10.606 | 88.368 | 0.985 | 0.041 | 0.036 | ||||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 8.110 | 90.932 | 0.930 | 0.028 | 0.037 |
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 49.923 | 49.333 | 0.736 | 0.009 | 0.032 | ||||||
pg164_o2nofp.cx9a2a_c32r128 | 50.872 | 48.481 | 0.629 | 0.019 | 0.026 | ||||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 54.559 | 44.807 | 0.618 | 0.016 | 0.025 | ||||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 53.090 | 46.301 | 0.597 | 0.011 | 0.037 |
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 9885 375186 0 0.0 518.7 27.5 0.000 0.000 0.052 2.852 1420911 43.4 3.787 56 56.7 142.9 40.2 0.060 19003 16430 pg158_o2nofp.cx9a2a_c32r128 9885 383376 0 0.0 511.6 27.4 0.000 0.000 0.052 2.842 1452434 43.3 3.789 54 56.3 142.4 33.7 0.077 19506 17309 pg164_o2nofp.cx9a2a_c32r128 9885 378062 0 0.0 509.8 27.4 0.000 0.000 0.052 2.836 1430822 43.2 3.785 55 56.3 142.6 39.0 0.026 19131 16878 pg17beta3_o2nofp.cx9a2a_c32r128 9885 374957 0 0.0 510.6 27.4 0.000 0.000 0.052 2.838 1419204 43.3 3.785 55 56.3 142.5 21.8 0.084 19035 16637 pg17rc1_o2nofp.cx9a2a_c32r128
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 99.631 | 0.282 | 0.086 | 0.001 | nonzero | nonzero | 0.067 | ||||
pg164_o2nofp.cx9a2a_c32r128 | 99.628 | 0.279 | 0.092 | 0.001 | nonzero | nonzero | 0.067 | ||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 99.640 | 0.271 | 0.088 | 0.001 | nonzero | nonzero | 0.095 | ||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 99.639 | 0.273 | 0.088 | 0.001 | nonzero | nonzero | 0.070 |
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 0.987 | 98.097 | 0.893 | 0.024 | 0.038 | ||||||
pg164_o2nofp.cx9a2a_c32r128 | 1.033 | 97.948 | 0.999 | 0.020 | 0.038 | ||||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 5.746 | 93.351 | 0.892 | 0.011 | 0.029 | ||||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 3.521 | 95.626 | 0.841 | 0.012 | 0.036 |
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 39.161 | 60.248 | 0.568 | 0.022 | 0.035 | ||||||
pg164_o2nofp.cx9a2a_c32r128 | 39.716 | 59.617 | 0.649 | 0.017 | 0.038 | ||||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 45.576 | 53.773 | 0.642 | 0.009 | 0.025 | ||||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 43.856 | 55.607 | 0.526 | 0.012 | 0.034 |
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 9885 127739 0 0.0 346.2 29.4 0.000 0.000 0.035 3.050 511683 45.2 4.006 170 56.7 138.8 29.8 0.067 6507 6297 pg158_o2nofp.cx9a2a_c32r128 9885 127213 0 0.0 344.5 29.2 0.000 0.000 0.035 3.024 511595 45.5 4.022 172 56.3 138.4 5.1 0.067 6456 6233 pg164_o2nofp.cx9a2a_c32r128 9885 127254 0 0.0 344.1 29.2 0.000 0.000 0.035 3.021 511268 45.5 4.018 172 56.4 138.5 36.1 0.095 6457 6249 pg17beta3_o2nofp.cx9a2a_c32r128 9885 126889 1 0.0 344.4 29.2 0.000 0.000 0.035 3.021 509594 45.5 4.016 172 56.4 138.5 33.3 0.070 6431 6233 pg17rc1_o2nofp.cx9a2a_c32r128
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 99.977 | 0.011 | 0.012 | nonzero | nonzero | nonzero | 0.088 | ||||
pg164_o2nofp.cx9a2a_c32r128 | 99.978 | 0.011 | 0.011 | nonzero | nonzero | nonzero | 0.095 | ||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 99.977 | 0.012 | 0.011 | nonzero | nonzero | nonzero | 0.086 | ||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 99.977 | 0.012 | 0.011 | nonzero | nonzero | nonzero | 0.080 |
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 19.989 | 79.266 | 0.736 | 0.008 | 0.031 | ||||||
pg164_o2nofp.cx9a2a_c32r128 | 17.020 | 82.349 | 0.626 | 0.006 | 0.032 | ||||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 33.402 | 66.059 | 0.534 | 0.004 | 0.049 | ||||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 26.222 | 73.229 | 0.541 | 0.008 | 0.032 |
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 46.709 | 52.902 | 0.384 | 0.004 | 0.027 | ||||||
pg164_o2nofp.cx9a2a_c32r128 | 48.999 | 50.674 | 0.326 | 0.002 | 0.030 | ||||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 55.202 | 44.494 | 0.302 | 0.002 | 0.027 | ||||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 53.693 | 45.996 | 0.308 | 0.003 | 0.031 |
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 19758 370418 0 0.0 396.6 33.6 0.000 0.000 0.020 1.743 1399767 44.3 3.779 57 56.6 135.0 44.4 0.088 18959 16590 pg158_o2nofp.cx9a2a_c32r128 19758 377223 0 0.0 396.9 33.4 0.000 0.000 0.020 1.732 1426020 44.2 3.780 56 56.3 134.7 32.0 0.095 18875 16669 pg164_o2nofp.cx9a2a_c32r128 19758 375401 0 0.0 396.9 33.4 0.000 0.000 0.020 1.733 1418168 44.1 3.778 56 56.3 134.7 24.0 0.086 18731 16542 pg17beta3_o2nofp.cx9a2a_c32r128 19758 370957 0 0.0 396.3 33.4 0.000 0.000 0.020 1.729 1399962 44.2 3.774 57 56.4 134.8 39.4 0.080 18955 16462 pg17rc1_o2nofp.cx9a2a_c32r128
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 99.493 | 0.380 | 0.125 | 0.002 | nonzero | nonzero | 0.090 | ||||
pg164_o2nofp.cx9a2a_c32r128 | 99.499 | 0.371 | 0.128 | 0.002 | nonzero | nonzero | 0.091 | ||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 99.510 | 0.365 | 0.123 | 0.002 | nonzero | nonzero | 0.096 | ||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 99.505 | 0.368 | 0.124 | 0.002 | nonzero | nonzero | 0.101 |
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 2.919 | 95.627 | 1.406 | 0.049 | 0.055 | ||||||
pg164_o2nofp.cx9a2a_c32r128 | 3.185 | 95.520 | 1.246 | 0.049 | 0.044 | ||||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 17.112 | 81.704 | 1.137 | 0.048 | 0.051 | ||||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 4.969 | 93.879 | 1.104 | 0.048 | 0.052 |
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
pg158_o2nofp.cx9a2a_c32r128 | 47.162 | 51.858 | 0.955 | 0.026 | 0.037 | ||||||
pg164_o2nofp.cx9a2a_c32r128 | 48.901 | 50.198 | 0.872 | 0.029 | 0.040 | ||||||
pg17beta3_o2nofp.cx9a2a_c32r128 | 54.234 | 44.914 | 0.831 | 0.022 | 0.029 | ||||||
pg17rc1_o2nofp.cx9a2a_c32r128 | 50.960 | 48.168 | 0.844 | 0.029 | 0.036 |
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 19769 126017 0 0.0 410.8 36.0 0.000 0.000 0.021 1.864 507864 45.8 4.030 174 56.3 133.6 25.1 0.090 6379 6153 pg158_o2nofp.cx9a2a_c32r128 19769 125792 0 0.0 409.6 35.8 0.000 0.000 0.021 1.855 508430 46.2 4.042 176 56.1 133.4 25.1 0.091 6381 6137 pg164_o2nofp.cx9a2a_c32r128 19769 125869 0 0.0 409.2 35.8 0.000 0.000 0.021 1.854 508062 46.1 4.036 176 56.1 133.4 24.9 0.096 6409 6153 pg17beta3_o2nofp.cx9a2a_c32r128 19769 125252 0 0.0 411.6 35.8 0.000 0.000 0.021 1.854 504632 46.3 4.029 177 56.2 133.5 9.3 0.101 6380 6121 pg17rc1_o2nofp.cx9a2a_c32r128
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 1666667 0 1 0.0 6631.3 698.9 0.000 0.000 0.004 0.429 254940 46.0 0.153 13 19.1 51.7 1.9 0.648 110482 30967 pg158_o2nofp.cx9a2a_c32r128 1652892 0 2 0.0 6655.7 704.0 0.000 0.000 0.004 0.436 260915 45.6 0.158 13 19.1 51.7 1.9 0.741 111712 44751 pg164_o2nofp.cx9a2a_c32r128 1694915 0 3 0.0 6699.9 706.9 0.000 0.000 0.004 0.427 265066 45.3 0.156 13 19.1 51.7 1.4 0.489 112778 47449 pg17beta3_o2nofp.cx9a2a_c32r128 1709402 0 0 0.0 6770.0 718.3 0.000 0.000 0.004 0.430 274194 46.8 0.160 13 19.1 51.7 12.2 0.539 112979 49047 pg17rc1_o2nofp.cx9a2a_c32r128
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 2597404 0 0 0.0 6280.5 724.0 0.000 0.000 0.002 0.285 105828 17.8 0.041 3 38.4 88.6 6.9 0.045 NA NA pg158_o2nofp.cx9a2a_c32r128 2597404 0 0 0.0 6171.7 713.0 0.000 0.000 0.002 0.281 105324 17.9 0.041 3 38.4 88.6 6.3 0.044 NA NA pg164_o2nofp.cx9a2a_c32r128 2739727 0 1 0.0 6884.0 797.9 0.000 0.000 0.003 0.298 40487 17.1 0.015 3 38.4 88.5 6.4 0.044 NA NA pg17beta3_o2nofp.cx9a2a_c32r128 2816903 0 0 0.0 7336.8 855.7 0.000 0.000 0.003 0.311 42161 17.9 0.015 3 38.4 88.5 6.4 0.036 NA NA pg17rc1_o2nofp.cx9a2a_c32r128
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 383234 0 932 5.5 6402.0 594.5 0.002 0.015 0.017 1.588 263431 54.8 0.687 69 56.4 152.4 42.5 0.457 22109 3946 pg158_o2nofp.cx9a2a_c32r128 384615 0 704 3.2 6213.6 589.1 0.002 0.009 0.016 1.568 270915 54.9 0.704 69 56.0 152.0 49.8 0.144 22076 3796 pg164_o2nofp.cx9a2a_c32r128 397022 0 644 2.9 6517.7 622.2 0.002 0.008 0.016 1.605 255362 53.6 0.643 65 56.0 152.0 38.7 0.435 22925 3246 pg17beta3_o2nofp.cx9a2a_c32r128 393120 0 631 2.9 6440.2 612.9 0.002 0.008 0.016 1.597 259091 53.0 0.659 65 56.1 152.1 8.7 0.696 22833 3346 pg17rc1_o2nofp.cx9a2a_c32r128
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 94007 0 0 0.0 1418.9 135.4 0.000 0.000 0.015 1.475 383097 52.7 4.075 269 56.6 152.7 8.9 0.032 4001 3018 pg158_o2nofp.cx9a2a_c32r128 98280 0 0 0.0 1482.5 142.0 0.000 0.000 0.015 1.480 400824 54.4 4.078 266 56.2 152.3 6.3 0.072 4466 3311 pg164_o2nofp.cx9a2a_c32r128 101652 0 1 0.0 1496.9 143.1 0.000 0.000 0.015 1.442 385029 52.4 3.788 247 56.2 152.3 17.1 0.060 4800 3256 pg17beta3_o2nofp.cx9a2a_c32r128 104167 0 1 0.0 1559.2 147.9 0.000 0.000 0.015 1.454 392508 54.1 3.768 249 56.3 152.4 16.3 0.064 4483 3323 pg17rc1_o2nofp.cx9a2a_c32r128
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 1977 390692 0 0.0 122.2 10.4 0.000 0.000 0.062 5.388 1484857 42.6 3.801 52 56.6 152.7 0.5 0.017 20065 18412 pg158_o2nofp.cx9a2a_c32r128 1977 392699 0 0.0 120.9 10.4 0.000 0.000 0.061 5.401 1492924 42.5 3.802 52 56.2 152.2 2.0 0.010 19659 18043 pg164_o2nofp.cx9a2a_c32r128 1978 392546 1 0.0 121.6 10.4 0.000 0.000 0.061 5.409 1490918 42.5 3.798 52 56.2 152.3 0.5 0.028 19818 18108 pg17beta3_o2nofp.cx9a2a_c32r128 1977 387796 0 0.0 129.2 10.5 0.000 0.000 0.065 5.421 1474076 42.6 3.801 53 56.3 152.4 0.5 0.012 19691 18147 pg17rc1_o2nofp.cx9a2a_c32r128
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 1977 128510 0 0.0 358.0 18.0 0.000 0.000 0.181 9.324 515516 44.4 4.012 166 56.6 149.5 0.5 0.012 6521 6393 pg158_o2nofp.cx9a2a_c32r128 1977 128251 0 0.0 343.8 17.9 0.000 0.000 0.174 9.247 513863 44.6 4.007 167 56.2 149.1 2.4 0.007 6521 6378 pg164_o2nofp.cx9a2a_c32r128 1977 128510 1 0.0 343.4 17.9 0.000 0.000 0.174 9.250 515352 44.5 4.010 166 56.2 149.2 0.5 0.009 6548 6407 pg17beta3_o2nofp.cx9a2a_c32r128 1977 127752 0 0.0 342.1 17.8 0.000 0.000 0.173 9.243 511978 44.7 4.008 168 56.3 149.2 0.5 0.008 6475 6345 pg17rc1_o2nofp.cx9a2a_c32r128
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 9885 375186 0 0.0 518.7 27.5 0.000 0.000 0.052 2.852 1420911 43.4 3.787 56 56.7 142.9 40.2 0.060 19003 16430 pg158_o2nofp.cx9a2a_c32r128 9885 383376 0 0.0 511.6 27.4 0.000 0.000 0.052 2.842 1452434 43.3 3.789 54 56.3 142.4 33.7 0.077 19506 17309 pg164_o2nofp.cx9a2a_c32r128 9885 378062 0 0.0 509.8 27.4 0.000 0.000 0.052 2.836 1430822 43.2 3.785 55 56.3 142.6 39.0 0.026 19131 16878 pg17beta3_o2nofp.cx9a2a_c32r128 9885 374957 0 0.0 510.6 27.4 0.000 0.000 0.052 2.838 1419204 43.3 3.785 55 56.3 142.5 21.8 0.084 19035 16637 pg17rc1_o2nofp.cx9a2a_c32r128
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 9885 127739 0 0.0 346.2 29.4 0.000 0.000 0.035 3.050 511683 45.2 4.006 170 56.7 138.8 29.8 0.067 6507 6297 pg158_o2nofp.cx9a2a_c32r128 9885 127213 0 0.0 344.5 29.2 0.000 0.000 0.035 3.024 511595 45.5 4.022 172 56.3 138.4 5.1 0.067 6456 6233 pg164_o2nofp.cx9a2a_c32r128 9885 127254 0 0.0 344.1 29.2 0.000 0.000 0.035 3.021 511268 45.5 4.018 172 56.4 138.5 36.1 0.095 6457 6249 pg17beta3_o2nofp.cx9a2a_c32r128 9885 126889 1 0.0 344.4 29.2 0.000 0.000 0.035 3.021 509594 45.5 4.016 172 56.4 138.5 33.3 0.070 6431 6233 pg17rc1_o2nofp.cx9a2a_c32r128
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 19758 370418 0 0.0 396.6 33.6 0.000 0.000 0.020 1.743 1399767 44.3 3.779 57 56.6 135.0 44.4 0.088 18959 16590 pg158_o2nofp.cx9a2a_c32r128 19758 377223 0 0.0 396.9 33.4 0.000 0.000 0.020 1.732 1426020 44.2 3.780 56 56.3 134.7 32.0 0.095 18875 16669 pg164_o2nofp.cx9a2a_c32r128 19758 375401 0 0.0 396.9 33.4 0.000 0.000 0.020 1.733 1418168 44.1 3.778 56 56.3 134.7 24.0 0.086 18731 16542 pg17beta3_o2nofp.cx9a2a_c32r128 19758 370957 0 0.0 396.3 33.4 0.000 0.000 0.020 1.729 1399962 44.2 3.774 57 56.4 134.8 39.4 0.080 18955 16462 pg17rc1_o2nofp.cx9a2a_c32r128
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 19769 126017 0 0.0 410.8 36.0 0.000 0.000 0.021 1.864 507864 45.8 4.030 174 56.3 133.6 25.1 0.090 6379 6153 pg158_o2nofp.cx9a2a_c32r128 19769 125792 0 0.0 409.6 35.8 0.000 0.000 0.021 1.855 508430 46.2 4.042 176 56.1 133.4 25.1 0.091 6381 6137 pg164_o2nofp.cx9a2a_c32r128 19769 125869 0 0.0 409.2 35.8 0.000 0.000 0.021 1.854 508062 46.1 4.036 176 56.1 133.4 24.9 0.096 6409 6153 pg17beta3_o2nofp.cx9a2a_c32r128 19769 125252 0 0.0 411.6 35.8 0.000 0.000 0.021 1.854 504632 46.3 4.029 177 56.2 133.5 9.3 0.101 6380 6121 pg17rc1_o2nofp.cx9a2a_c32r128
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 92.282 7.675 0.021 0.004 0.010 0.007 0.000 0.000 0.000 0.648 pg158_o2nofp.cx9a2a_c32r128 0.000 92.427 7.527 0.027 0.004 0.007 0.008 0.000 0.000 0.000 0.741 pg164_o2nofp.cx9a2a_c32r128 0.000 92.966 6.986 0.025 0.006 0.008 0.009 0.000 0.000 0.000 0.489 pg17beta3_o2nofp.cx9a2a_c32r128 0.000 93.049 6.901 0.030 0.007 0.010 0.004 0.000 0.000 0.000 0.539 pg17rc1_o2nofp.cx9a2a_c32r128
TODO - determine whether there is data for create index response time
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 1.481 91.183 6.776 0.554 0.006 nonzero 0.000 0.000 0.000 0.457 pg158_o2nofp.cx9a2a_c32r128 0.000 1.463 90.793 7.211 0.526 0.007 0.000 0.000 0.000 0.000 0.144 pg164_o2nofp.cx9a2a_c32r128 0.000 1.512 90.550 7.418 0.516 0.004 0.001 0.000 0.000 0.000 0.435 pg17beta3_o2nofp.cx9a2a_c32r128 0.000 1.711 90.375 7.379 0.530 0.005 0.001 0.000 0.000 0.000 0.696 pg17rc1_o2nofp.cx9a2a_c32r128
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 17.343 79.280 3.103 0.270 0.004 0.000 0.000 0.000 0.000 0.236 pg158_o2nofp.cx9a2a_c32r128 0.000 17.560 79.204 3.000 0.233 0.003 0.000 0.000 0.000 0.000 0.145 pg164_o2nofp.cx9a2a_c32r128 0.000 22.012 74.851 2.899 0.235 0.003 nonzero 0.000 0.000 0.000 0.432 pg17beta3_o2nofp.cx9a2a_c32r128 0.000 21.586 75.302 2.879 0.229 0.003 nonzero 0.000 0.000 0.000 0.692 pg17rc1_o2nofp.cx9a2a_c32r128
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 86.515 12.707 0.759 0.018 nonzero 0.000 0.000 0.000 0.000 0.000 0.032 pg158_o2nofp.cx9a2a_c32r128 86.882 12.298 0.800 0.019 nonzero nonzero 0.000 0.000 0.000 0.000 0.072 pg164_o2nofp.cx9a2a_c32r128 89.994 9.644 0.345 0.017 nonzero 0.000 0.000 0.000 0.000 0.000 0.060 pg17beta3_o2nofp.cx9a2a_c32r128 90.301 9.346 0.340 0.013 nonzero nonzero 0.000 0.000 0.000 0.000 0.064 pg17rc1_o2nofp.cx9a2a_c32r128
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 2.689 47.820 49.470 0.021 nonzero 0.000 0.000 0.000 0.000 0.000 0.026 pg158_o2nofp.cx9a2a_c32r128 2.912 47.843 49.218 0.026 0.001 nonzero 0.000 0.000 0.000 0.000 0.073 pg164_o2nofp.cx9a2a_c32r128 3.694 58.911 37.332 0.063 0.001 0.000 0.000 0.000 0.000 0.000 0.061 pg17beta3_o2nofp.cx9a2a_c32r128 3.545 57.307 39.092 0.055 0.001 nonzero 0.000 0.000 0.000 0.000 0.064 pg17rc1_o2nofp.cx9a2a_c32r128
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.997 0.002 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.017 pg158_o2nofp.cx9a2a_c32r128 99.997 0.002 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg164_o2nofp.cx9a2a_c32r128 99.997 0.002 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.028 pg17beta3_o2nofp.cx9a2a_c32r128 99.996 0.002 0.001 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.012 pg17rc1_o2nofp.cx9a2a_c32r128
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 99.612 0.383 0.004 0.000 0.000 0.000 0.000 0.000 0.023 pg158_o2nofp.cx9a2a_c32r128 0.000 0.001 99.672 0.326 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg164_o2nofp.cx9a2a_c32r128 0.000 0.001 99.688 0.307 0.004 0.000 0.000 0.000 0.000 0.000 0.029 pg17beta3_o2nofp.cx9a2a_c32r128 0.000 0.004 99.722 0.268 0.006 0.000 0.000 0.000 0.000 0.000 0.023 pg17rc1_o2nofp.cx9a2a_c32r128
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 66.736 33.233 0.029 0.001 0.000 0.000 0.000 0.000 0.000 0.023 pg158_o2nofp.cx9a2a_c32r128 0.000 69.793 30.185 0.022 0.000 0.000 0.000 0.000 0.000 0.000 0.006 pg164_o2nofp.cx9a2a_c32r128 0.000 68.083 31.897 0.017 0.003 0.000 0.000 0.000 0.000 0.000 0.029 pg17beta3_o2nofp.cx9a2a_c32r128 0.000 67.436 32.539 0.021 0.004 0.000 0.000 0.000 0.000 0.000 0.025 pg17rc1_o2nofp.cx9a2a_c32r128
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.702 0.237 0.062 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.012 pg158_o2nofp.cx9a2a_c32r128 99.706 0.228 0.066 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.007 pg164_o2nofp.cx9a2a_c32r128 99.717 0.220 0.062 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg17beta3_o2nofp.cx9a2a_c32r128 99.711 0.225 0.064 nonzero 0.000 0.000 0.000 0.000 0.000 0.000 0.008 pg17rc1_o2nofp.cx9a2a_c32r128
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.000 99.492 0.508 0.000 0.000 0.000 0.000 0.000 0.000 0.013 pg158_o2nofp.cx9a2a_c32r128 0.000 0.000 99.656 0.344 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg164_o2nofp.cx9a2a_c32r128 0.000 0.000 99.656 0.344 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg17beta3_o2nofp.cx9a2a_c32r128 0.000 0.000 99.643 0.357 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg17rc1_o2nofp.cx9a2a_c32r128
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 7.032 92.865 0.103 0.000 0.000 0.000 0.000 0.000 0.000 0.011 pg158_o2nofp.cx9a2a_c32r128 0.000 1.781 98.133 0.086 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg164_o2nofp.cx9a2a_c32r128 0.000 21.272 78.643 0.085 0.000 0.000 0.000 0.000 0.000 0.000 0.010 pg17beta3_o2nofp.cx9a2a_c32r128 0.000 1.146 98.768 0.086 0.000 0.000 0.000 0.000 0.000 0.000 0.009 pg17rc1_o2nofp.cx9a2a_c32r128
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.987 0.006 0.007 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.060 pg158_o2nofp.cx9a2a_c32r128 99.987 0.006 0.007 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.077 pg164_o2nofp.cx9a2a_c32r128 99.987 0.006 0.007 nonzero nonzero 0.000 0.000 0.000 0.000 0.000 0.026 pg17beta3_o2nofp.cx9a2a_c32r128 99.987 0.006 0.007 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.084 pg17rc1_o2nofp.cx9a2a_c32r128
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 4.269 94.575 1.127 0.028 0.000 0.000 0.000 0.000 0.000 0.033 pg158_o2nofp.cx9a2a_c32r128 0.000 4.631 94.353 0.975 0.041 0.000 0.000 0.000 0.000 0.000 0.038 pg164_o2nofp.cx9a2a_c32r128 0.000 10.606 88.368 0.985 0.041 0.000 0.000 0.000 0.000 0.000 0.036 pg17beta3_o2nofp.cx9a2a_c32r128 0.000 8.110 90.932 0.930 0.028 0.000 0.000 0.000 0.000 0.000 0.037 pg17rc1_o2nofp.cx9a2a_c32r128
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 49.923 49.333 0.736 0.009 0.000 0.000 0.000 0.000 0.000 0.032 pg158_o2nofp.cx9a2a_c32r128 0.000 50.872 48.481 0.629 0.019 0.000 0.000 0.000 0.000 0.000 0.026 pg164_o2nofp.cx9a2a_c32r128 0.000 54.559 44.807 0.618 0.016 0.000 0.000 0.000 0.000 0.000 0.025 pg17beta3_o2nofp.cx9a2a_c32r128 0.000 53.090 46.301 0.597 0.011 0.000 0.000 0.000 0.000 0.000 0.037 pg17rc1_o2nofp.cx9a2a_c32r128
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.631 0.282 0.086 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.067 pg158_o2nofp.cx9a2a_c32r128 99.628 0.279 0.092 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.067 pg164_o2nofp.cx9a2a_c32r128 99.640 0.271 0.088 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.095 pg17beta3_o2nofp.cx9a2a_c32r128 99.639 0.273 0.088 0.001 nonzero nonzero 0.000 0.000 0.000 0.000 0.070 pg17rc1_o2nofp.cx9a2a_c32r128
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 0.987 98.097 0.893 0.024 0.000 0.000 0.000 0.000 0.000 0.038 pg158_o2nofp.cx9a2a_c32r128 0.000 1.033 97.948 0.999 0.020 0.000 0.000 0.000 0.000 0.000 0.038 pg164_o2nofp.cx9a2a_c32r128 0.000 5.746 93.351 0.892 0.011 0.000 0.000 0.000 0.000 0.000 0.029 pg17beta3_o2nofp.cx9a2a_c32r128 0.000 3.521 95.626 0.841 0.012 0.000 0.000 0.000 0.000 0.000 0.036 pg17rc1_o2nofp.cx9a2a_c32r128
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 39.161 60.248 0.568 0.022 0.000 0.000 0.000 0.000 0.000 0.035 pg158_o2nofp.cx9a2a_c32r128 0.000 39.716 59.617 0.649 0.017 0.000 0.000 0.000 0.000 0.000 0.038 pg164_o2nofp.cx9a2a_c32r128 0.000 45.576 53.773 0.642 0.009 0.000 0.000 0.000 0.000 0.000 0.025 pg17beta3_o2nofp.cx9a2a_c32r128 0.000 43.856 55.607 0.526 0.012 0.000 0.000 0.000 0.000 0.000 0.034 pg17rc1_o2nofp.cx9a2a_c32r128
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.977 0.011 0.012 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.088 pg158_o2nofp.cx9a2a_c32r128 99.978 0.011 0.011 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.095 pg164_o2nofp.cx9a2a_c32r128 99.977 0.012 0.011 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.086 pg17beta3_o2nofp.cx9a2a_c32r128 99.977 0.012 0.011 nonzero nonzero nonzero 0.000 0.000 0.000 0.000 0.080 pg17rc1_o2nofp.cx9a2a_c32r128
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 19.989 79.266 0.736 0.008 0.000 0.000 0.000 0.000 0.000 0.031 pg158_o2nofp.cx9a2a_c32r128 0.000 17.020 82.349 0.626 0.006 0.000 0.000 0.000 0.000 0.000 0.032 pg164_o2nofp.cx9a2a_c32r128 0.000 33.402 66.059 0.534 0.004 0.000 0.000 0.000 0.000 0.000 0.049 pg17beta3_o2nofp.cx9a2a_c32r128 0.000 26.222 73.229 0.541 0.008 0.000 0.000 0.000 0.000 0.000 0.032 pg17rc1_o2nofp.cx9a2a_c32r128
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 46.709 52.902 0.384 0.004 0.000 0.000 0.000 0.000 0.000 0.027 pg158_o2nofp.cx9a2a_c32r128 0.000 48.999 50.674 0.326 0.002 0.000 0.000 0.000 0.000 0.000 0.030 pg164_o2nofp.cx9a2a_c32r128 0.000 55.202 44.494 0.302 0.002 0.000 0.000 0.000 0.000 0.000 0.027 pg17beta3_o2nofp.cx9a2a_c32r128 0.000 53.693 45.996 0.308 0.003 0.000 0.000 0.000 0.000 0.000 0.031 pg17rc1_o2nofp.cx9a2a_c32r128
Query response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 99.493 0.380 0.125 0.002 nonzero nonzero 0.000 0.000 0.000 0.000 0.090 pg158_o2nofp.cx9a2a_c32r128 99.499 0.371 0.128 0.002 nonzero nonzero 0.000 0.000 0.000 0.000 0.091 pg164_o2nofp.cx9a2a_c32r128 99.510 0.365 0.123 0.002 nonzero nonzero 0.000 0.000 0.000 0.000 0.096 pg17beta3_o2nofp.cx9a2a_c32r128 99.505 0.368 0.124 0.002 nonzero nonzero 0.000 0.000 0.000 0.000 0.101 pg17rc1_o2nofp.cx9a2a_c32r128
Insert response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 2.919 95.627 1.406 0.049 0.000 0.000 0.000 0.000 0.000 0.055 pg158_o2nofp.cx9a2a_c32r128 0.000 3.185 95.520 1.246 0.049 0.000 0.000 0.000 0.000 0.000 0.044 pg164_o2nofp.cx9a2a_c32r128 0.000 17.112 81.704 1.137 0.048 0.000 0.000 0.000 0.000 0.000 0.051 pg17beta3_o2nofp.cx9a2a_c32r128 0.000 4.969 93.879 1.104 0.048 0.000 0.000 0.000 0.000 0.000 0.052 pg17rc1_o2nofp.cx9a2a_c32r128
Delete response time histogram
256us 1ms 4ms 16ms 64ms 256ms 1s 4s 16s gt max tag 0.000 47.162 51.858 0.955 0.026 0.000 0.000 0.000 0.000 0.000 0.037 pg158_o2nofp.cx9a2a_c32r128 0.000 48.901 50.198 0.872 0.029 0.000 0.000 0.000 0.000 0.000 0.040 pg164_o2nofp.cx9a2a_c32r128 0.000 54.234 44.914 0.831 0.022 0.000 0.000 0.000 0.000 0.000 0.029 pg17beta3_o2nofp.cx9a2a_c32r128 0.000 50.960 48.168 0.844 0.029 0.000 0.000 0.000 0.000 0.000 0.036 pg17rc1_o2nofp.cx9a2a_c32r128