Introduction

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:


Contents


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.

dbmsl.i0l.xl.i1l.i2qr100qp100qr500qp500qr1000qp1000
pg158_o2nofp.cx9a2a_c32r128 1666667259740438323494007390692128510375186127739370418126017
pg164_o2nofp.cx9a2a_c32r128 1652892259740438461598280392699128251383376127213377223125792
pg17beta3_o2nofp.cx9a2a_c32r128 16949152739727397022101652392546128510378062127254375401125869
pg17rc1_o2nofp.cx9a2a_c32r128 17094022816903393120104167387796127752374957126889370957125252

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.

dbmsl.i0l.xl.i1l.i2qr100qp100qr500qp500qr1000qp1000
pg158_o2nofp.cx9a2a_c32r128 1.001.001.001.001.001.001.001.001.001.00
pg164_o2nofp.cx9a2a_c32r128 0.991.001.001.051.011.001.021.001.021.00
pg17beta3_o2nofp.cx9a2a_c32r128 1.021.051.041.081.001.001.011.001.011.00
pg17rc1_o2nofp.cx9a2a_c32r128 1.031.081.031.110.990.991.000.991.000.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.

dbmsqr100.L1qp100.L2qr500.L3qp500.L4qr1000.L5qp1000.L6
pg158_o2nofp.cx9a2a_c32r12819771977988598851975819769
pg164_o2nofp.cx9a2a_c32r12819771977988598851975819769
pg17beta3_o2nofp.cx9a2a_c32r12819781977988598851975819769
pg17rc1_o2nofp.cx9a2a_c32r12819771977988598851975819769
target2000200010000100002000020000

l.i0

l.i0: load without secondary indexes. Graphs for performance per 1-second interval are here.

Average throughput:

Image

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12892.2827.6750.0210.0040.0100.0070.648
pg164_o2nofp.cx9a2a_c32r12892.4277.5270.0270.0040.0070.0080.741
pg17beta3_o2nofp.cx9a2a_c32r12892.9666.9860.0250.0060.0080.0090.489
pg17rc1_o2nofp.cx9a2a_c32r12893.0496.9010.0300.0070.0100.0040.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

l.x: create secondary indexes.

Average throughput:

Image

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

l.i1: continue load after secondary indexes created with 50 inserts per transaction. Graphs for performance per 1-second interval are here.

Average throughput:

Image

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r1281.48191.1836.7760.5540.006nonzero0.457
pg164_o2nofp.cx9a2a_c32r1281.46390.7937.2110.5260.0070.144
pg17beta3_o2nofp.cx9a2a_c32r1281.51290.5507.4180.5160.0040.0010.435
pg17rc1_o2nofp.cx9a2a_c32r1281.71190.3757.3790.5300.0050.0010.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12817.34379.2803.1030.2700.0040.236
pg164_o2nofp.cx9a2a_c32r12817.56079.2043.0000.2330.0030.145
pg17beta3_o2nofp.cx9a2a_c32r12822.01274.8512.8990.2350.003nonzero0.432
pg17rc1_o2nofp.cx9a2a_c32r12821.58675.3022.8790.2290.003nonzero0.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

l.i2: continue load after secondary indexes created with 5 inserts per transaction. Graphs for performance per 1-second interval are here.

Average throughput:

Image

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12886.51512.7070.7590.018nonzero0.032
pg164_o2nofp.cx9a2a_c32r12886.88212.2980.8000.019nonzerononzero0.072
pg17beta3_o2nofp.cx9a2a_c32r12889.9949.6440.3450.017nonzero0.060
pg17rc1_o2nofp.cx9a2a_c32r12890.3019.3460.3400.013nonzerononzero0.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r1282.68947.82049.4700.021nonzero0.026
pg164_o2nofp.cx9a2a_c32r1282.91247.84349.2180.0260.001nonzero0.073
pg17beta3_o2nofp.cx9a2a_c32r1283.69458.91137.3320.0630.0010.061
pg17rc1_o2nofp.cx9a2a_c32r1283.54557.30739.0920.0550.001nonzero0.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

qr100.L1: range queries with 100 insert/s per client. Graphs for performance per 1-second interval are here.

Average throughput:

Image

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12899.9970.0020.001nonzerononzero0.017
pg164_o2nofp.cx9a2a_c32r12899.9970.0020.001nonzero0.010
pg17beta3_o2nofp.cx9a2a_c32r12899.9970.0020.001nonzerononzero0.028
pg17rc1_o2nofp.cx9a2a_c32r12899.9960.0020.001nonzero0.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12899.6120.3830.0040.023
pg164_o2nofp.cx9a2a_c32r1280.00199.6720.3260.011
pg17beta3_o2nofp.cx9a2a_c32r1280.00199.6880.3070.0040.029
pg17rc1_o2nofp.cx9a2a_c32r1280.00499.7220.2680.0060.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12866.73633.2330.0290.0010.023
pg164_o2nofp.cx9a2a_c32r12869.79330.1850.0220.006
pg17beta3_o2nofp.cx9a2a_c32r12868.08331.8970.0170.0030.029
pg17rc1_o2nofp.cx9a2a_c32r12867.43632.5390.0210.0040.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

qp100.L2: point queries with 100 insert/s per client. Graphs for performance per 1-second interval are here.

Average throughput:

Image

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12899.7020.2370.062nonzero0.012
pg164_o2nofp.cx9a2a_c32r12899.7060.2280.066nonzero0.007
pg17beta3_o2nofp.cx9a2a_c32r12899.7170.2200.062nonzero0.009
pg17rc1_o2nofp.cx9a2a_c32r12899.7110.2250.064nonzero0.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12899.4920.5080.013
pg164_o2nofp.cx9a2a_c32r12899.6560.3440.009
pg17beta3_o2nofp.cx9a2a_c32r12899.6560.3440.011
pg17rc1_o2nofp.cx9a2a_c32r12899.6430.3570.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r1287.03292.8650.1030.011
pg164_o2nofp.cx9a2a_c32r1281.78198.1330.0860.009
pg17beta3_o2nofp.cx9a2a_c32r12821.27278.6430.0850.010
pg17rc1_o2nofp.cx9a2a_c32r1281.14698.7680.0860.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

qr500.L3: range queries with 500 insert/s per client. Graphs for performance per 1-second interval are here.

Average throughput:

Image

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12899.9870.0060.007nonzerononzero0.060
pg164_o2nofp.cx9a2a_c32r12899.9870.0060.007nonzerononzerononzero0.077
pg17beta3_o2nofp.cx9a2a_c32r12899.9870.0060.007nonzerononzero0.026
pg17rc1_o2nofp.cx9a2a_c32r12899.9870.0060.007nonzerononzerononzero0.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r1284.26994.5751.1270.0280.033
pg164_o2nofp.cx9a2a_c32r1284.63194.3530.9750.0410.038
pg17beta3_o2nofp.cx9a2a_c32r12810.60688.3680.9850.0410.036
pg17rc1_o2nofp.cx9a2a_c32r1288.11090.9320.9300.0280.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12849.92349.3330.7360.0090.032
pg164_o2nofp.cx9a2a_c32r12850.87248.4810.6290.0190.026
pg17beta3_o2nofp.cx9a2a_c32r12854.55944.8070.6180.0160.025
pg17rc1_o2nofp.cx9a2a_c32r12853.09046.3010.5970.0110.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

qp500.L4: point queries with 500 insert/s per client. Graphs for performance per 1-second interval are here.

Average throughput:

Image

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12899.6310.2820.0860.001nonzerononzero0.067
pg164_o2nofp.cx9a2a_c32r12899.6280.2790.0920.001nonzerononzero0.067
pg17beta3_o2nofp.cx9a2a_c32r12899.6400.2710.0880.001nonzerononzero0.095
pg17rc1_o2nofp.cx9a2a_c32r12899.6390.2730.0880.001nonzerononzero0.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r1280.98798.0970.8930.0240.038
pg164_o2nofp.cx9a2a_c32r1281.03397.9480.9990.0200.038
pg17beta3_o2nofp.cx9a2a_c32r1285.74693.3510.8920.0110.029
pg17rc1_o2nofp.cx9a2a_c32r1283.52195.6260.8410.0120.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12839.16160.2480.5680.0220.035
pg164_o2nofp.cx9a2a_c32r12839.71659.6170.6490.0170.038
pg17beta3_o2nofp.cx9a2a_c32r12845.57653.7730.6420.0090.025
pg17rc1_o2nofp.cx9a2a_c32r12843.85655.6070.5260.0120.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

qr1000.L5: range queries with 1000 insert/s per client. Graphs for performance per 1-second interval are here.

Average throughput:

Image

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12899.9770.0110.012nonzerononzerononzero0.088
pg164_o2nofp.cx9a2a_c32r12899.9780.0110.011nonzerononzerononzero0.095
pg17beta3_o2nofp.cx9a2a_c32r12899.9770.0120.011nonzerononzerononzero0.086
pg17rc1_o2nofp.cx9a2a_c32r12899.9770.0120.011nonzerononzerononzero0.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12819.98979.2660.7360.0080.031
pg164_o2nofp.cx9a2a_c32r12817.02082.3490.6260.0060.032
pg17beta3_o2nofp.cx9a2a_c32r12833.40266.0590.5340.0040.049
pg17rc1_o2nofp.cx9a2a_c32r12826.22273.2290.5410.0080.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12846.70952.9020.3840.0040.027
pg164_o2nofp.cx9a2a_c32r12848.99950.6740.3260.0020.030
pg17beta3_o2nofp.cx9a2a_c32r12855.20244.4940.3020.0020.027
pg17rc1_o2nofp.cx9a2a_c32r12853.69345.9960.3080.0030.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

qp1000.L6: point queries with 1000 insert/s per client. Graphs for performance per 1-second interval are here.

Average throughput:

Image

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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12899.4930.3800.1250.002nonzerononzero0.090
pg164_o2nofp.cx9a2a_c32r12899.4990.3710.1280.002nonzerononzero0.091
pg17beta3_o2nofp.cx9a2a_c32r12899.5100.3650.1230.002nonzerononzero0.096
pg17rc1_o2nofp.cx9a2a_c32r12899.5050.3680.1240.002nonzerononzero0.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r1282.91995.6271.4060.0490.055
pg164_o2nofp.cx9a2a_c32r1283.18595.5201.2460.0490.044
pg17beta3_o2nofp.cx9a2a_c32r12817.11281.7041.1370.0480.051
pg17rc1_o2nofp.cx9a2a_c32r1284.96993.8791.1040.0480.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.

dbms256us1ms4ms16ms64ms256ms1s4s16sgtmax
pg158_o2nofp.cx9a2a_c32r12847.16251.8580.9550.0260.037
pg164_o2nofp.cx9a2a_c32r12848.90150.1980.8720.0290.040
pg17beta3_o2nofp.cx9a2a_c32r12854.23444.9140.8310.0220.029
pg17rc1_o2nofp.cx9a2a_c32r12850.96048.1680.8440.0290.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

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

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

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

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

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

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

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

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

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

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

l.i0

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

l.x

TODO - determine whether there is data for create index response time


l.i1

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

l.i2

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

qr100.L1

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

qp100.L2

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

qr500.L3

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

qp500.L4

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

qr1000.L5

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

qp1000.L6

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