Introduction

This is a report for the insert benchmark with 30M docs and 1 client(s). It is generated by scripts (bash, awk, sed) and Tufte might not be impressed. An overview of the insert benchmark is here and a short update is here. Below, by DBMS, I mean DBMS+version.config. An example is my8020.c10b40 where my means MySQL, 8020 is version 8.0.20 and c10b40 is the name for the configuration file.

The test server has 8 AMD cores, 32G RAM and an NVMe device for the database. The benchmark was run with 1 client 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 1 table with a table per client. It loads 30M rows per table without secondary indexes, creates 3 secondary indexes per table, then inserts 40m+10m rows per table with a delete per insert to avoid growing the table. It then does 6 read+write tests for 3600s 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 by Postgres. Clients and the DBMS share one server.

The tested DBMS are:

pg1222_o2nofp.cx10a_c8r32 - Postgres 12.22 with the x10a_c8r32 config
pg1322_o2nofp.cx10a_c8r32 - Postgres 13.22 with the x10a_c8r32 config
pg1323_o2nofp.cx10a_c8r32 - Postgres 13.23 with the x10a_c8r32 config
pg1419_o2nofp.cx10a_c8r32 - Postgres 14.19 with the x10a_c8r32 config
pg1420_o2nofp.cx10a_c8r32 - Postgres 14.20 with the x10a_c8r32 config
pg1514_o2nofp.cx10a_c8r32 - Postgres 15.14 with the x10a_c8r32 config
pg1515_o2nofp.cx10a_c8r32 - Postgres 15.15 with the x10a_c8r32 config
pg1610_o2nofp.cx10a_c8r32 - Postgres 16.10 with the x10a_c8r32 config
pg1611_o2nofp.cx10a_c8r32 - Postgres 16.11 with the x10a_c8r32 config
pg176_o2nofp.cx10a_c8r32 - Postgres 17.6 with the x10b_c8r32 config
pg177_o2nofp.cx10a_c8r32 - Postgres 17.7 with the x10b_c8r32 config
pg180_o2nofp.cx10b_c8r32 - Postgres 18.0 with the x10b_c8r32 config
pg180_o2nofp.cx10c_c8r32 - Postgres 18.0 with the x10c_c8r32 config
pg180_o2nofp.cx10d_c8r32 - Postgres 18.0 with the x10d_c8r32 config
pg181_o2nofp.cx10b_c8r32 - Postgres 18.1 with the x10b_c8r32 config

Summary
l.i0: load without secondary indexes
l.x: create secondary indexes
l.i1: continue load after secondary indexes created with 50 inserts per transaction
l.i2: continue load after secondary indexes created with 5 inserts per transaction
qr100.L1: range queries with 100 insert/s per client
qp100.L2: point queries with 100 insert/s per client
qr500.L3: range queries with 500 insert/s per client
qp500.L4: point queries with 500 insert/s per client
qr1000.L5: range queries with 1000 insert/s per client
qp1000.L6: point queries with 1000 insert/s per client

Summary

The numbers are inserts/s for l.i0, l.i1 and l.i2, indexed docs (or rows) /s for l.x and queries/s for qr100, qp100 thru qr1000, qp1000" The values are the average rate over the entire test for inserts (IPS) and queries (QPS). The range of values for IPS and QPS is split into 3 parts: bottom 25%, middle 50%, top 25%. Values in the bottom 25% have a red background, values in the top 25% have a green background and values in the middle have no color. A gray background is used for values that can be ignored because the DBMS did not sustain the target insert rate. Red backgrounds are not used when the minimum value is within 80% of the max value.

dbms	l.i0	l.x	l.i1	l.i2	qr100	qp100	qr500	qp500	qr1000	qp1000
pg1222_o2nofp.cx10a_c8r32	141509	340910	20418	2572	14702	8524	13901	8516	13893	8450
pg1322_o2nofp.cx10a_c8r32	144231	337080	20964	2642	14818	8515	13899	8454	13861	8458
pg1323_o2nofp.cx10a_c8r32	143541	333334	20439	2634	14977	8504	14082	8453	14007	8429
pg1419_o2nofp.cx10a_c8r32	140187	329671	19782	2511	14855	8392	13949	8397	13946	8396
pg1420_o2nofp.cx10a_c8r32	138889	322582	20070	2372	14884	8429	13950	8382	13942	8379
pg1514_o2nofp.cx10a_c8r32	144231	357144	20202	2384	15045	8493	14136	8459	14100	8488
pg1515_o2nofp.cx10a_c8r32	144928	361447	20964	2525	14897	8467	13905	8483	14006	8424
pg1610_o2nofp.cx10a_c8r32	142180	357144	19484	2431	14971	8545	14172	8433	14239	8444
pg1611_o2nofp.cx10a_c8r32	144231	370372	20682	2627	14912	8521	14133	8482	13998	8430
pg176_o2nofp.cx10a_c8r32	142857	375001	18010	2244	15080	8405	13821	8361	13880	8332
pg177_o2nofp.cx10a_c8r32	141509	379748	18683	2172	15118	8465	13946	8413	13996	8393
pg180_o2nofp.cx10b_c8r32	141509	375001	19157	2369	14902	8378	13898	8349	13842	8340
pg180_o2nofp.cx10c_c8r32	142180	379748	18930	2220	14824	8360	13861	8359	13774	8306
pg180_o2nofp.cx10d_c8r32	142180	379748	19222	2320	14874	8422	13810	8373	13963	8389
pg181_o2nofp.cx10b_c8r32	142180	357144	20471	2432	14736	8391	13609	8369	13673	8340

This table has relative throughput, throughput for the DBMS relative to the DBMS in the first line, using the absolute throughput from the previous table. Values less than 0.95 have a yellow background. Values greater than 1.05 have a blue background.

dbms	l.i0	l.x	l.i1	l.i2	qr100	qp100	qr500	qp500	qr1000	qp1000
pg1222_o2nofp.cx10a_c8r32	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00	1.00
pg1322_o2nofp.cx10a_c8r32	1.02	0.99	1.03	1.03	1.01	1.00	1.00	0.99	1.00	1.00
pg1323_o2nofp.cx10a_c8r32	1.01	0.98	1.00	1.02	1.02	1.00	1.01	0.99	1.01	1.00
pg1419_o2nofp.cx10a_c8r32	0.99	0.97	0.97	0.98	1.01	0.98	1.00	0.99	1.00	0.99
pg1420_o2nofp.cx10a_c8r32	0.98	0.95	0.98	0.92	1.01	0.99	1.00	0.98	1.00	0.99
pg1514_o2nofp.cx10a_c8r32	1.02	1.05	0.99	0.93	1.02	1.00	1.02	0.99	1.01	1.00
pg1515_o2nofp.cx10a_c8r32	1.02	1.06	1.03	0.98	1.01	0.99	1.00	1.00	1.01	1.00
pg1610_o2nofp.cx10a_c8r32	1.00	1.05	0.95	0.95	1.02	1.00	1.02	0.99	1.02	1.00
pg1611_o2nofp.cx10a_c8r32	1.02	1.09	1.01	1.02	1.01	1.00	1.02	1.00	1.01	1.00
pg176_o2nofp.cx10a_c8r32	1.01	1.10	0.88	0.87	1.03	0.99	0.99	0.98	1.00	0.99
pg177_o2nofp.cx10a_c8r32	1.00	1.11	0.92	0.84	1.03	0.99	1.00	0.99	1.01	0.99
pg180_o2nofp.cx10b_c8r32	1.00	1.10	0.94	0.92	1.01	0.98	1.00	0.98	1.00	0.99
pg180_o2nofp.cx10c_c8r32	1.00	1.11	0.93	0.86	1.01	0.98	1.00	0.98	0.99	0.98
pg180_o2nofp.cx10d_c8r32	1.00	1.11	0.94	0.90	1.01	0.99	0.99	0.98	1.01	0.99
pg181_o2nofp.cx10b_c8r32	1.00	1.05	1.00	0.95	1.00	0.98	0.98	0.98	0.98	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
pg1222_o2nofp.cx10a_c8r32	100	100	500	500	1000	1000
pg1322_o2nofp.cx10a_c8r32	100	100	500	500	1000	1000
pg1323_o2nofp.cx10a_c8r32	100	100	500	500	999	999
pg1419_o2nofp.cx10a_c8r32	100	100	500	500	1000	1000
pg1420_o2nofp.cx10a_c8r32	100	100	500	500	1000	1000
pg1514_o2nofp.cx10a_c8r32	100	100	500	500	999	1000
pg1515_o2nofp.cx10a_c8r32	100	100	500	500	999	999
pg1610_o2nofp.cx10a_c8r32	100	100	500	500	999	999
pg1611_o2nofp.cx10a_c8r32	100	100	500	500	1000	1000
pg176_o2nofp.cx10a_c8r32	100	100	500	500	999	999
pg177_o2nofp.cx10a_c8r32	100	100	500	500	999	999
pg180_o2nofp.cx10b_c8r32	100	100	500	500	1000	1000
pg180_o2nofp.cx10c_c8r32	100	100	500	500	1000	1000
pg180_o2nofp.cx10d_c8r32	100	100	500	500	1000	1000
pg181_o2nofp.cx10b_c8r32	100	100	500	500	1000	1000
target	100	100	500	500	1000	1000

l.i0

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

Average throughput:

Insert response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For the max column values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms	1ms	4ms	16ms	max
pg1222_o2nofp.cx10a_c8r32	99.979	0.021	nonzero	0.004
pg1322_o2nofp.cx10a_c8r32	99.970	0.030		0.002
pg1323_o2nofp.cx10a_c8r32	99.983	0.017		0.003
pg1419_o2nofp.cx10a_c8r32	99.985	0.015		0.002
pg1420_o2nofp.cx10a_c8r32	99.989	0.011		0.003
pg1514_o2nofp.cx10a_c8r32	99.985	0.015	0.001	0.006
pg1515_o2nofp.cx10a_c8r32	99.985	0.014	nonzero	0.005
pg1610_o2nofp.cx10a_c8r32	99.992	0.008		0.002
pg1611_o2nofp.cx10a_c8r32	99.984	0.016	nonzero	0.008
pg176_o2nofp.cx10a_c8r32	99.983	0.017		0.002
pg177_o2nofp.cx10a_c8r32	99.981	0.019		0.003
pg180_o2nofp.cx10b_c8r32	99.985	0.015		0.002
pg180_o2nofp.cx10c_c8r32	99.987	0.013		0.003
pg180_o2nofp.cx10d_c8r32	99.983	0.017		0.002
pg181_o2nofp.cx10b_c8r32	99.989	0.011		0.002

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
141509	0	0	0.0	528.4	59.7	0.000	0.000	0.004	0.432	17571	19.8	0.124	11	2.9	7.8	2.9	0.004	142082	140981	pg1222_o2nofp.cx10a_c8r32
144231	0	0	0.0	541.1	61.2	0.000	0.000	0.004	0.435	18248	20.6	0.127	11	2.9	7.8	0.8	0.002	144684	143979	pg1322_o2nofp.cx10a_c8r32
143541	0	0	0.0	538.8	60.9	0.000	0.000	0.004	0.435	18282	20.7	0.127	12	2.9	7.8	2.9	0.003	144082	143180	pg1323_o2nofp.cx10a_c8r32
140187	0	0	0.0	524.5	59.3	0.000	0.000	0.004	0.433	16989	19.6	0.121	11	2.9	7.8	0.4	0.002	140482	139582	pg1419_o2nofp.cx10a_c8r32
138889	0	0	0.0	516.6	58.4	0.000	0.000	0.004	0.431	16838	19.5	0.121	11	2.9	7.8	2.8	0.003	138883	138082	pg1420_o2nofp.cx10a_c8r32
144231	0	0	0.0	536.7	61.0	0.000	0.000	0.004	0.433	17736	20.4	0.123	11	2.9	7.8	2.9	0.006	144284	142884	pg1514_o2nofp.cx10a_c8r32
144928	0	0	0.0	540.0	61.4	0.000	0.000	0.004	0.433	17854	20.6	0.123	11	2.9	7.8	3.0	0.005	145384	144482	pg1515_o2nofp.cx10a_c8r32
142180	0	0	0.0	529.6	60.1	0.000	0.000	0.004	0.433	17195	19.7	0.121	11	2.9	7.8	2.9	0.002	142881	142274	pg1610_o2nofp.cx10a_c8r32
144231	0	0	0.0	537.5	61.0	0.000	0.000	0.004	0.433	17739	20.3	0.123	11	2.9	7.8	2.9	0.008	144580	143081	pg1611_o2nofp.cx10a_c8r32
142857	0	0	0.0	533.6	60.7	0.000	0.000	0.004	0.435	15427	20.3	0.108	11	2.9	7.8	2.1	0.002	143682	142783	pg176_o2nofp.cx10a_c8r32
141509	0	0	0.0	528.8	60.0	0.000	0.000	0.004	0.434	14737	20.0	0.104	11	2.9	7.8	2.9	0.003	142482	141582	pg177_o2nofp.cx10a_c8r32
141509	0	0	0.0	524.9	59.7	0.000	0.000	0.004	0.432	14972	19.9	0.106	11	2.9	7.8	2.9	0.002	141587	140783	pg180_o2nofp.cx10b_c8r32
142180	0	0	0.0	529.7	60.2	0.000	0.000	0.004	0.433	14931	19.9	0.105	11	2.9	7.8	2.9	0.003	143180	142281	pg180_o2nofp.cx10c_c8r32
142180	0	0	0.0	528.1	59.9	0.000	0.000	0.004	0.432	14826	19.8	0.104	11	2.9	7.8	2.9	0.002	142281	141284	pg180_o2nofp.cx10d_c8r32
142180	0	0	0.0	528.2	59.9	0.000	0.000	0.004	0.432	14723	20.0	0.104	11	2.9	7.8	2.9	0.002	142283	141280	pg181_o2nofp.cx10b_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
0.302	1.210	0.000	0.000	0.148	3.610	531.2	61548.9	29.37	5.786	0.587	114.7	2.244	11.00	0.000	0.000	0.502	4.796	29.47	1.841	0.379	9.305		pg1222_o2nofp.cx10a_c8r32
0.310	1.240	0.000	0.000	0.160	3.900	544.2	63087.8	28.64	5.530	0.366	114.6	2.330	13.28	0.000	0.000	0.550	5.412	30.12	1.426	0.236	7.976		pg1322_o2nofp.cx10a_c8r32
0.300	1.200	0.000	0.000	0.092	3.600	541.8	62777.6	28.37	5.511	0.388	114.5	2.355	16.12	0.000	0.000	0.522	6.069	29.99	1.444	0.260	7.969		pg1323_o2nofp.cx10a_c8r32
0.215	0.859	0.000	0.000	0.065	3.024	527.3	61127.6	27.79	5.539	0.360	114.6	2.361	22.95	0.000	0.000	0.400	8.101	29.24	1.091	0.212	6.674		pg1419_o2nofp.cx10a_c8r32
0.238	0.952	0.000	0.000	0.080	3.333	519.2	60168.0	27.52	5.587	0.384	114.6	2.338	27.52	0.000	0.000	0.507	9.689	28.93	1.280	0.240	7.191		pg1420_o2nofp.cx10a_c8r32
0.160	0.640	0.000	0.000	0.074	2.200	540.5	62903.6	27.12	5.178	0.362	115.1	0.130	1.860	0.000	0.000	0.082	5.156	30.03	1.032	0.238	6.495		pg1514_o2nofp.cx10a_c8r32
0.305	1.220	0.000	0.000	0.160	4.000	543.8	63306.9	28.78	5.390	0.375	115.3	0.070	1.420	0.000	0.000	0.086	2.186	30.29	1.100	0.243	6.806		pg1515_o2nofp.cx10a_c8r32
0.293	1.171	0.000	0.000	0.088	3.610	533.2	62045.2	28.15	5.458	0.367	115.1	0.044	9.639	0.000	0.000	0.067	15.34	29.75	1.008	0.227	6.403		pg1610_o2nofp.cx10a_c8r32
0.310	1.240	0.000	0.000	0.160	3.800	541.3	62926.0	28.45	5.369	0.360	115.2	0.080	57.42	0.000	0.000	0.035	53.44	30.11	1.093	0.225	6.773		pg1611_o2nofp.cx10a_c8r32
0.250	1.000	0.000	0.000	0.117	3.500	537.4	62631.7	27.80	5.373	0.382	115.4	0.045	0.620	0.000	0.000	0.048	1.233	29.91	0.976	0.222	6.400		pg176_o2nofp.cx10a_c8r32
0.307	1.229	0.000	0.000	0.117	3.610	532.4	61891.2	25.97	5.043	0.330	115.0	0.034	0.411	0.000	0.000	0.128	0.976	29.67	1.073	0.201	6.552		pg177_o2nofp.cx10a_c8r32
0.278	1.112	0.000	0.000	0.116	3.805	528.5	61543.9	25.20	4.927	0.412	115.2	0.063	0.859	0.000	0.000	0.106	1.301	29.46	1.437	0.253	7.662		pg180_o2nofp.cx10b_c8r32
0.283	1.132	0.000	0.000	0.139	3.902	533.3	62063.6	25.66	4.985	0.377	115.2	0.059	0.820	0.000	0.000	0.083	1.171	29.76	1.539	0.239	8.060		pg180_o2nofp.cx10c_c8r32
0.273	1.093	0.000	0.000	0.100	3.220	531.6	61828.1	25.44	4.916	0.401	115.1	0.112	1.015	0.000	0.000	0.080	1.174	29.61	1.469	0.250	7.863		pg180_o2nofp.cx10d_c8r32
0.302	1.210	0.000	0.000	0.096	3.610	531.7	61830.7	25.99	5.052	0.342	115.1	0.029	0.390	0.000	0.000	0.061	0.976	29.62	1.076	0.214	6.570		pg181_o2nofp.cx10b_c8r32

l.x

l.x: create secondary indexes.

Average throughput:

Performance metrics for the DBMS listed above. Some are normalized by throughput, others are not. Legend for results is here.

ips	qps	rps	rmbps	wps	wmbps	rpq	rkbpq	wpi	wkbpi	csps	cpups	cspq	cpupq	dbgb1	dbgb2	rss	maxop	p50	p99	tag
340910	0	0	0.0	640.4	78.4	0.000	0.000	0.002	0.235	1894	12.1	0.006	3	5.8	13.3	3.0	0.002	NA	NA	pg1222_o2nofp.cx10a_c8r32
337080	0	0	0.0	623.6	76.3	0.000	0.000	0.002	0.232	1836	12.0	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg1322_o2nofp.cx10a_c8r32
333334	0	0	0.0	622.5	76.2	0.000	0.000	0.002	0.234	1775	12.2	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg1323_o2nofp.cx10a_c8r32
329671	0	0	0.0	674.4	82.5	0.000	0.000	0.002	0.256	2016	12.2	0.006	3	5.8	13.3	3.0	0.002	NA	NA	pg1419_o2nofp.cx10a_c8r32
322582	0	0	0.0	651.4	79.6	0.000	0.000	0.002	0.253	1921	12.2	0.006	3	5.8	13.3	3.0	0.002	NA	NA	pg1420_o2nofp.cx10a_c8r32
357144	0	0	0.0	670.3	82.3	0.000	0.000	0.002	0.236	1897	12.1	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg1514_o2nofp.cx10a_c8r32
361447	0	0	0.0	696.3	85.5	0.000	0.000	0.002	0.242	1989	12.1	0.006	3	5.8	13.3	3.0	0.002	NA	NA	pg1515_o2nofp.cx10a_c8r32
357144	0	0	0.0	665.5	81.7	0.000	0.000	0.002	0.234	1876	12.1	0.005	3	5.8	13.3	3.1	0.002	NA	NA	pg1610_o2nofp.cx10a_c8r32
370372	0	0	0.0	747.1	91.6	0.000	0.000	0.002	0.253	2238	12.1	0.006	3	5.8	13.3	3.1	0.002	NA	NA	pg1611_o2nofp.cx10a_c8r32
375001	0	0	0.0	690.2	84.8	0.000	0.000	0.002	0.232	1910	12.3	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg176_o2nofp.cx10a_c8r32
379748	0	0	0.0	645.5	79.1	0.000	0.000	0.002	0.213	1947	12.3	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg177_o2nofp.cx10a_c8r32
375001	0	0	0.0	588.2	72.0	0.000	0.000	0.002	0.197	1909	12.1	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg180_o2nofp.cx10b_c8r32
379748	0	0	0.0	598.1	73.2	0.000	0.000	0.002	0.197	1927	12.1	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg180_o2nofp.cx10c_c8r32
379748	0	0	0.0	605.8	74.1	0.000	0.000	0.002	0.200	1965	12.1	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg180_o2nofp.cx10d_c8r32
357144	0	0	0.0	676.4	83.0	0.000	0.000	0.002	0.238	1840	12.5	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg181_o2nofp.cx10b_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
0.425	1.700	0.000	0.000	0.115	1.500	680.2	85283.3	24.46	24.65	2.474	58.40	2.263	23.60	0.000	0.000	1.824	7.879	7.513	2.009	1.251	5.612		pg1222_o2nofp.cx10a_c8r32
0.412	1.650	0.000	0.000	0.283	1.750	662.3	83037.9	24.19	20.52	2.276	73.30	2.125	13.35	0.000	0.000	1.700	5.867	7.338	1.575	1.357	5.287		pg1322_o2nofp.cx10a_c8r32
0.425	1.700	0.000	0.000	1.209	1.750	661.2	82902.9	24.04	19.85	2.280	65.96	2.175	11.05	0.000	0.000	1.766	5.017	7.250	1.709	1.316	5.353		pg1323_o2nofp.cx10a_c8r32
0.424	1.694	0.000	0.000	0.464	2.118	713.8	89476.3	27.42	23.04	2.486	70.42	2.506	43.29	0.000	0.000	1.482	13.79	8.271	1.361	1.265	5.382		pg1419_o2nofp.cx10a_c8r32
0.435	1.741	0.000	0.000	0.330	2.118	678.9	85015.7	25.95	21.96	1.965	76.89	2.506	78.35	0.000	0.000	1.726	23.29	8.118	1.954	0.823	5.620		pg1420_o2nofp.cx10a_c8r32
0.480	1.920	0.000	0.000	0.634	2.133	714.9	89882.5	24.03	19.71	3.751	78.51	0.253	1.760	0.000	0.000	0.109	0.925	8.000	1.149	1.425	5.059		pg1514_o2nofp.cx10a_c8r32
0.493	1.973	0.000	0.000	0.688	2.400	742.7	93350.1	25.45	17.84	3.351	86.40	0.227	82.08	0.000	0.000	0.151	68.53	8.427	1.226	1.427	5.240		pg1515_o2nofp.cx10a_c8r32
0.467	1.867	0.000	0.000	1.004	2.133	709.7	89272.6	23.43	25.01	3.946	72.11	0.213	12.53	0.000	0.000	0.111	9.264	7.960	0.969	1.357	4.980		pg1610_o2nofp.cx10a_c8r32
0.533	2.133	0.000	0.000	0.419	2.400	796.8	100076	27.67	18.50	3.525	86.84	0.133	2.027	0.000	0.000	0.067	2.533	9.493	1.595	1.427	5.891		pg1611_o2nofp.cx10a_c8r32
0.500	2.000	0.000	0.000	0.239	2.000	739.4	93031.6	24.27	21.83	4.038	75.99	0.257	2.229	0.000	0.000	0.161	1.607	8.271	0.946	1.401	5.120		pg176_o2nofp.cx10a_c8r32
0.457	1.829	0.000	0.000	0.858	2.286	691.5	86763.2	25.06	24.13	3.710	75.95	0.071	0.286	0.000	0.000	0.309	0.857	8.586	0.999	1.067	4.996		pg177_o2nofp.cx10a_c8r32
0.314	1.257	0.000	0.000	0.794	2.286	630.1	79044.3	23.27	21.60	4.235	75.48	0.157	2.686	0.000	0.000	0.121	2.466	8.000	1.936	1.267	5.423		pg180_o2nofp.cx10b_c8r32
0.357	1.429	0.000	0.000	0.300	2.286	640.7	80329.5	24.03	21.75	4.210	75.47	0.157	1.257	0.000	0.000	0.099	0.921	8.243	1.881	1.156	5.317		pg180_o2nofp.cx10c_c8r32
0.371	1.486	0.000	0.000	0.532	2.286	649.0	81341.7	24.27	22.35	4.311	75.15	0.129	1.029	0.000	0.000	0.103	0.571	8.300	2.000	1.180	5.276		pg180_o2nofp.cx10d_c8r32
0.493	1.973	0.000	0.000	0.743	1.867	721.4	90621.6	24.04	25.39	3.924	72.14	0.187	1.173	0.000	0.000	0.144	1.289	8.520	0.942	1.211	5.241		pg181_o2nofp.cx10b_c8r32

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:

dbms	1ms	4ms	16ms	64ms	max
pg1222_o2nofp.cx10a_c8r32	46.971	53.019	0.005	0.005	0.029
pg1322_o2nofp.cx10a_c8r32	39.672	60.319	0.005	0.005	0.034
pg1323_o2nofp.cx10a_c8r32	33.383	66.608	0.004	0.005	0.035
pg1419_o2nofp.cx10a_c8r32	46.699	53.301	nonzero	nonzero	0.031
pg1420_o2nofp.cx10a_c8r32	41.446	58.553	0.001		0.013
pg1514_o2nofp.cx10a_c8r32	35.050	64.945	0.003	0.002	0.037
pg1515_o2nofp.cx10a_c8r32	32.089	67.897	0.005	0.009	0.040
pg1610_o2nofp.cx10a_c8r32	36.958	63.041	nonzero	nonzero	0.023
pg1611_o2nofp.cx10a_c8r32	31.139	68.849	0.005	0.007	0.031
pg176_o2nofp.cx10a_c8r32	51.104	48.893	0.002	0.001	0.025
pg177_o2nofp.cx10a_c8r32	51.168	48.828	0.002	0.001	0.026
pg180_o2nofp.cx10b_c8r32	44.125	55.872	0.002	0.001	0.032
pg180_o2nofp.cx10c_c8r32	46.457	53.536	0.005	0.002	0.025
pg180_o2nofp.cx10d_c8r32	49.358	50.640	0.001	0.001	0.032
pg181_o2nofp.cx10b_c8r32	37.144	62.852	0.004	nonzero	0.025

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	1ms	4ms	16ms	64ms	max
pg1222_o2nofp.cx10a_c8r32	24.762	56.847	18.386	0.005	0.028
pg1322_o2nofp.cx10a_c8r32	21.997	68.075	9.924	0.004	0.032
pg1323_o2nofp.cx10a_c8r32	21.750	66.503	11.743	0.004	0.035
pg1419_o2nofp.cx10a_c8r32	21.309	61.402	17.288	0.001	0.030
pg1420_o2nofp.cx10a_c8r32	20.972	65.556	13.471	nonzero	0.028
pg1514_o2nofp.cx10a_c8r32	21.302	67.392	11.304	0.002	0.049
pg1515_o2nofp.cx10a_c8r32	21.351	75.922	2.721	0.006	0.039
pg1610_o2nofp.cx10a_c8r32	19.968	63.317	16.714	0.001	0.025
pg1611_o2nofp.cx10a_c8r32	20.710	75.286	3.999	0.005	0.035
pg176_o2nofp.cx10a_c8r32	19.372	57.258	23.369	0.001	0.025
pg177_o2nofp.cx10a_c8r32	20.745	63.159	16.095	0.001	0.025
pg180_o2nofp.cx10b_c8r32	19.413	62.238	18.348	0.001	0.032
pg180_o2nofp.cx10c_c8r32	20.176	60.458	19.363	0.002	0.040
pg180_o2nofp.cx10d_c8r32	19.949	62.660	17.389	0.001	0.032
pg181_o2nofp.cx10b_c8r32	20.069	76.096	3.835	0.001	0.024

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
20418	0	0	0.0	251.9	27.2	0.000	0.000	0.012	1.363	10562	21.8	0.517	85	8.1	38.5	6.4	0.029	14498	8499	pg1222_o2nofp.cx10a_c8r32
20964	0	0	0.0	259.4	28.0	0.000	0.000	0.012	1.366	10856	22.2	0.518	85	8.1	38.5	5.5	0.034	15298	10299	pg1322_o2nofp.cx10a_c8r32
20439	0	0	0.0	253.4	27.3	0.000	0.000	0.012	1.369	10637	22.2	0.520	87	8.1	38.6	6.4	0.035	14848	9949	pg1323_o2nofp.cx10a_c8r32
19782	0	0	0.0	245.2	26.4	0.000	0.000	0.012	1.365	9846	20.5	0.498	83	7.9	38.4	6.8	0.031	14148	8299	pg1419_o2nofp.cx10a_c8r32
20070	0	0	0.0	247.7	26.7	0.000	0.000	0.012	1.360	9966	20.9	0.497	83	7.8	38.3	2.8	0.013	14398	9649	pg1420_o2nofp.cx10a_c8r32
20202	0	0	0.0	246.3	26.7	0.000	0.000	0.012	1.354	10451	20.7	0.517	82	7.8	38.2	3.8	0.037	15148	8599	pg1514_o2nofp.cx10a_c8r32
20964	0	0	0.0	256.7	27.9	0.000	0.000	0.012	1.364	10860	20.8	0.518	79	7.8	38.4	7.6	0.040	17047	11848	pg1515_o2nofp.cx10a_c8r32
19484	0	0	0.0	239.1	25.9	0.000	0.000	0.012	1.360	10110	20.4	0.519	84	7.8	38.4	7.3	0.023	13998	8049	pg1610_o2nofp.cx10a_c8r32
20682	0	0	0.0	253.2	27.5	0.000	0.000	0.012	1.362	10719	20.7	0.518	80	7.8	38.4	3.7	0.031	16847	11548	pg1611_o2nofp.cx10a_c8r32
18010	0	0	0.0	224.0	24.6	0.000	0.000	0.012	1.399	7665	19.6	0.426	87	7.8	38.5	3.0	0.025	12698	6349	pg176_o2nofp.cx10a_c8r32
18683	0	0	0.0	233.6	25.6	0.000	0.000	0.013	1.402	7927	19.7	0.424	84	7.8	38.3	3.6	0.026	15848	6199	pg177_o2nofp.cx10a_c8r32
19157	0	0	0.0	240.4	26.5	0.000	0.000	0.013	1.414	8112	20.3	0.423	85	7.8	38.3	2.7	0.032	13648	7899	pg180_o2nofp.cx10b_c8r32
18930	0	0	0.0	233.6	25.6	0.000	0.000	0.012	1.385	8168	20.1	0.431	85	7.8	38.2	3.0	0.025	13748	6399	pg180_o2nofp.cx10c_c8r32
19222	0	0	0.0	238.1	26.1	0.000	0.000	0.012	1.391	8215	20.0	0.427	83	7.8	38.3	3.0	0.032	14798	6599	pg180_o2nofp.cx10d_c8r32
20471	0	0	0.0	256.5	28.2	0.000	0.000	0.013	1.411	8670	20.8	0.424	81	7.8	38.2	4.3	0.025	16398	11698	pg181_o2nofp.cx10b_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
0.101	0.402	0.000	0.000	0.095	1.754	251.8	27824.2	15.20	6.094	1.865	109.5	2.078	10.24	0.000	0.000	0.739	4.927	17.89	1.709	0.302	6.684		pg1222_o2nofp.cx10a_c8r32
0.098	0.392	0.000	0.000	0.069	1.726	259.3	28630.8	15.73	6.040	1.724	110.0	2.088	10.40	0.000	0.000	0.737	4.924	18.62	1.542	0.319	6.667		pg1322_o2nofp.cx10a_c8r32
0.102	0.406	0.000	0.000	0.087	1.795	253.3	27963.8	15.31	6.045	1.773	110.0	2.084	11.37	0.000	0.000	0.713	5.333	18.17	1.555	0.320	6.651		pg1323_o2nofp.cx10a_c8r32
0.062	0.246	0.000	0.000	0.068	1.161	245.1	26990.3	14.23	5.977	1.702	109.9	2.081	11.96	0.000	0.000	0.634	5.568	18.11	1.100	0.265	5.633		pg1419_o2nofp.cx10a_c8r32
0.104	0.417	0.000	0.000	0.091	1.814	247.6	27279.1	13.94	5.795	1.795	110.2	2.082	12.08	0.000	0.000	0.749	5.537	18.16	1.451	0.317	6.534		pg1420_o2nofp.cx10a_c8r32
0.089	0.356	0.000	0.000	0.101	1.651	246.2	27333.1	11.43	4.540	1.842	111.5	0.012	0.059	0.000	0.000	0.023	0.107	18.02	1.115	0.315	5.895		pg1514_o2nofp.cx10a_c8r32
0.108	0.432	0.000	0.000	0.066	1.853	256.6	28583.5	12.39	4.784	1.663	112.0	0.006	0.040	0.000	0.000	0.019	0.105	18.39	1.162	0.305	5.837		pg1515_o2nofp.cx10a_c8r32
0.099	0.395	0.000	0.000	0.064	1.702	239.0	26481.3	10.99	4.556	1.942	111.1	0.004	0.018	0.000	0.000	0.017	0.059	17.80	1.106	0.288	5.579		pg1610_o2nofp.cx10a_c8r32
0.102	0.409	0.000	0.000	0.068	1.777	253.1	28154.7	12.24	4.779	1.735	111.9	0.006	0.023	0.000	0.000	0.011	0.062	18.27	1.133	0.311	5.962		pg1611_o2nofp.cx10a_c8r32
0.088	0.352	0.000	0.000	0.274	1.463	223.8	25185.8	10.32	4.584	2.567	112.2	0.011	0.098	0.000	0.000	0.015	0.095	14.63	1.172	0.300	5.124		pg176_o2nofp.cx10a_c8r32
0.097	0.390	0.000	0.000	0.437	1.705	227.8	25453.4	10.41	4.453	2.293	112.0	0.006	0.088	0.000	0.000	0.017	0.347	15.26	1.195	0.292	5.239		pg177_o2nofp.cx10a_c8r32
0.096	0.385	0.000	0.000	0.240	1.683	240.2	27070.3	10.48	4.410	2.174	112.8	0.012	0.150	0.000	0.000	0.027	0.209	16.07	1.634	0.321	6.165		pg180_o2nofp.cx10b_c8r32
0.094	0.374	0.000	0.000	0.268	1.596	233.4	26196.5	10.21	4.380	2.303	112.8	0.009	0.095	0.000	0.000	0.032	0.234	16.00	1.671	0.320	6.098		pg180_o2nofp.cx10c_c8r32
0.089	0.357	0.000	0.000	0.291	1.610	238.0	26725.0	10.64	4.489	2.247	113.0	0.009	7.801	0.000	0.000	0.034	13.06	16.60	1.669	0.303	5.858		pg180_o2nofp.cx10d_c8r32
0.106	0.424	0.000	0.000	0.066	1.707	256.4	28869.1	11.66	4.629	1.774	113.4	0.012	4.409	0.000	0.000	0.022	11.02	17.22	1.194	0.315	5.909		pg181_o2nofp.cx10b_c8r32

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:

dbms	256us	1ms	4ms	16ms	64ms	max
pg1222_o2nofp.cx10a_c8r32	50.816	49.183	0.001	nonzero	nonzero	0.036
pg1322_o2nofp.cx10a_c8r32	48.804	51.195	0.001	nonzero		0.010
pg1323_o2nofp.cx10a_c8r32	50.100	49.900	nonzero	nonzero		0.007
pg1419_o2nofp.cx10a_c8r32	45.506	54.494	nonzero			0.004
pg1420_o2nofp.cx10a_c8r32	41.043	58.956	nonzero	nonzero		0.009
pg1514_o2nofp.cx10a_c8r32	47.981	52.018	nonzero	nonzero		0.009
pg1515_o2nofp.cx10a_c8r32	45.707	54.293	nonzero	nonzero		0.007
pg1610_o2nofp.cx10a_c8r32	41.996	58.004	nonzero			0.002
pg1611_o2nofp.cx10a_c8r32	49.617	50.383	nonzero			0.003
pg176_o2nofp.cx10a_c8r32	42.567	57.432	nonzero			0.002
pg177_o2nofp.cx10a_c8r32	52.887	47.112	nonzero	nonzero		0.009
pg180_o2nofp.cx10b_c8r32	40.509	59.489	0.001	nonzero	nonzero	0.023
pg180_o2nofp.cx10c_c8r32	44.811	55.189	nonzero		nonzero	0.026
pg180_o2nofp.cx10d_c8r32	44.983	55.017	nonzero		nonzero	0.030
pg181_o2nofp.cx10b_c8r32	43.297	56.702	nonzero	nonzero		0.009

dbms	256us	1ms	4ms	16ms	64ms	max
pg1222_o2nofp.cx10a_c8r32	1.487	31.014	63.272	4.227	nonzero	0.037
pg1322_o2nofp.cx10a_c8r32	0.727	29.569	69.699	0.005		0.015
pg1323_o2nofp.cx10a_c8r32	1.169	28.074	70.726	0.031		0.015
pg1419_o2nofp.cx10a_c8r32	0.901	21.951	77.133	0.015		0.014
pg1420_o2nofp.cx10a_c8r32	1.142	26.188	71.345	1.325		0.013
pg1514_o2nofp.cx10a_c8r32	1.136	27.957	62.997	7.910		0.010
pg1515_o2nofp.cx10a_c8r32	1.262	26.013	72.712	0.013		0.015
pg1610_o2nofp.cx10a_c8r32	0.869	27.805	70.685	0.641		0.014
pg1611_o2nofp.cx10a_c8r32	0.894	20.143	78.947	0.017		0.014
pg176_o2nofp.cx10a_c8r32	0.942	26.016	65.412	7.631		0.007
pg177_o2nofp.cx10a_c8r32	1.191	28.452	52.467	17.890		0.015
pg180_o2nofp.cx10b_c8r32	0.817	23.318	75.783	0.082	nonzero	0.023
pg180_o2nofp.cx10c_c8r32	0.752	25.157	63.917	10.173	nonzero	0.027
pg180_o2nofp.cx10d_c8r32	0.813	27.998	63.846	7.343		0.013
pg181_o2nofp.cx10b_c8r32	0.768	21.115	78.101	0.016		0.007

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
2572	0	0	0.0	61.4	5.8	0.000	0.000	0.024	2.290	12490	15.4	4.856	479	8.1	40.2	6.6	0.036	1760	1020	pg1222_o2nofp.cx10a_c8r32
2642	0	0	0.0	62.2	5.9	0.000	0.000	0.024	2.284	12859	15.5	4.867	469	8.1	40.3	5.2	0.010	1980	1435	pg1322_o2nofp.cx10a_c8r32
2634	0	0	0.0	62.6	5.9	0.000	0.000	0.024	2.300	12828	15.5	4.870	471	8.2	40.3	4.7	0.007	1930	1310	pg1323_o2nofp.cx10a_c8r32
2511	0	0	0.0	58.7	5.5	0.000	0.000	0.023	2.236	11767	15.1	4.687	481	7.9	39.8	7.4	0.004	1965	1310	pg1419_o2nofp.cx10a_c8r32
2372	0	0	0.0	57.0	5.3	0.000	0.000	0.024	2.288	11134	15.0	4.694	506	7.9	39.7	0.9	0.009	1755	1130	pg1420_o2nofp.cx10a_c8r32
2384	0	0	0.0	55.8	5.4	0.000	0.000	0.023	2.309	11125	15.0	4.667	503	7.9	39.8	7.7	0.009	1625	985	pg1514_o2nofp.cx10a_c8r32
2525	0	0	0.0	58.0	5.6	0.000	0.000	0.023	2.271	11780	15.1	4.666	478	7.9	40.2	0.3	0.007	1940	1330	pg1515_o2nofp.cx10a_c8r32
2431	0	0	0.0	55.6	5.4	0.000	0.000	0.023	2.260	11319	15.1	4.657	497	7.9	39.7	0.3	0.002	1775	1230	pg1610_o2nofp.cx10a_c8r32
2627	0	0	0.0	58.9	5.7	0.000	0.000	0.022	2.230	12247	15.3	4.663	466	7.9	40.2	5.3	0.003	2145	1335	pg1611_o2nofp.cx10a_c8r32
2244	0	0	0.0	53.1	5.1	0.000	0.000	0.024	2.345	8822	14.8	3.932	528	7.9	39.9	7.3	0.002	1580	890	pg176_o2nofp.cx10a_c8r32
2172	0	0	0.0	52.3	5.1	0.000	0.000	0.024	2.385	8565	14.7	3.943	541	7.9	39.9	0.6	0.009	1355	710	pg177_o2nofp.cx10a_c8r32
2369	0	0	0.0	53.7	5.3	0.000	0.000	0.023	2.285	9294	15.0	3.923	507	7.9	39.7	7.0	0.023	1855	1305	pg180_o2nofp.cx10b_c8r32
2220	0	0	0.0	53.2	5.1	0.000	0.000	0.024	2.357	8769	14.9	3.950	537	7.9	39.6	0.4	0.026	1535	1030	pg180_o2nofp.cx10c_c8r32
2320	0	0	0.0	53.5	5.2	0.000	0.000	0.023	2.299	9117	14.9	3.929	514	7.9	39.6	7.0	0.030	1610	995	pg180_o2nofp.cx10d_c8r32
2432	0	0	0.0	55.1	5.4	0.000	0.000	0.023	2.277	9546	15.1	3.925	497	7.9	39.8	0.4	0.009	1970	1355	pg181_o2nofp.cx10b_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
0.003	0.013	0.000	0.000	0.003	0.062	60.97	5840.4	7.405	9.658	1.408	91.36	2.053	16.68	0.000	0.000	0.608	6.131	8.064	1.702	0.070	3.306		pg1222_o2nofp.cx10a_c8r32
0.003	0.014	0.000	0.000	0.003	0.069	62.05	6009.4	7.286	8.372	1.127	94.80	2.052	14.57	0.000	0.000	0.599	5.335	7.926	1.482	0.062	2.926		pg1322_o2nofp.cx10a_c8r32
0.004	0.017	0.000	0.000	0.003	0.079	62.66	6063.2	7.472	9.077	1.242	93.42	2.052	14.45	0.000	0.000	0.601	5.170	8.043	1.450	0.063	3.023		pg1323_o2nofp.cx10a_c8r32
0.002	0.006	0.000	0.000	0.000	0.030	58.68	5611.8	6.440	8.027	1.177	93.20	2.049	14.54	0.000	0.000	0.503	5.249	7.857	1.145	0.059	2.730		pg1419_o2nofp.cx10a_c8r32
0.003	0.013	0.000	0.000	0.001	0.057	57.04	5432.2	6.147	7.767	1.236	92.83	2.044	14.20	0.000	0.000	0.631	5.249	7.670	1.459	0.065	2.972		pg1420_o2nofp.cx10a_c8r32
0.003	0.011	0.000	0.000	0.001	0.053	55.55	5474.1	3.738	3.468	1.317	96.24	0.029	4.167	0.000	0.000	0.002	0.352	7.662	1.137	0.057	2.577		pg1514_o2nofp.cx10a_c8r32
0.004	0.017	0.000	0.000	0.003	0.076	58.01	5738.3	4.431	4.127	1.570	95.14	0.030	4.582	0.000	0.000	0.002	0.400	8.054	1.195	0.063	2.922		pg1515_o2nofp.cx10a_c8r32
0.003	0.012	0.000	0.000	0.002	0.054	55.67	5497.3	4.030	3.325	1.255	97.98	0.030	4.208	0.000	0.000	0.003	0.360	7.738	1.131	0.059	2.547		pg1610_o2nofp.cx10a_c8r32
0.004	0.015	0.000	0.000	0.014	0.074	58.41	5796.1	4.491	3.648	1.278	98.60	0.033	4.834	0.000	0.000	0.002	0.408	7.940	1.166	0.062	2.653		pg1611_o2nofp.cx10a_c8r32
0.002	0.010	0.000	0.000	0.021	0.049	53.03	5255.7	3.185	2.828	1.150	97.48	0.006	1.296	0.000	0.000	0.002	0.410	6.977	1.229	0.053	2.211		pg176_o2nofp.cx10a_c8r32
0.003	0.011	0.000	0.000	0.011	0.057	52.32	5182.0	3.248	2.834	1.310	96.34	0.007	1.452	0.000	0.000	0.003	0.588	7.102	1.227	0.055	2.458		pg177_o2nofp.cx10a_c8r32
0.003	0.010	0.000	0.000	0.021	0.052	53.70	5414.9	3.141	2.902	1.657	96.09	0.007	4.272	0.000	0.000	0.004	14.73	7.002	1.674	0.065	2.849		pg180_o2nofp.cx10b_c8r32
0.003	0.011	0.000	0.000	0.002	0.053	53.18	5228.2	3.023	2.715	1.340	95.70	0.007	2.997	0.000	0.000	0.004	4.624	7.055	1.661	0.061	2.671		pg180_o2nofp.cx10c_c8r32
0.003	0.010	0.000	0.000	0.019	0.051	53.55	5336.7	3.060	2.662	1.402	96.80	0.007	1.427	0.000	0.000	0.003	0.473	7.202	1.658	0.060	2.670		pg180_o2nofp.cx10d_c8r32
0.003	0.012	0.000	0.000	0.012	0.058	55.13	5542.1	3.431	3.024	1.298	99.07	0.008	1.590	0.000	0.000	0.003	0.511	7.274	1.199	0.060	2.434		pg181_o2nofp.cx10b_c8r32

qr100.L1

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

Average throughput:

Query response time histogram: each cell has the percentage of responses that take <= the time in the header and max is the max response time in seconds. For max values in the top 25% of the range have a red background and in the bottom 25% of the range have a green background. The red background is not used when the min value is within 80% of the max value.

dbms	256us	1ms	4ms	16ms	max
pg1222_o2nofp.cx10a_c8r32	100.000	nonzero	nonzero		0.001
pg1322_o2nofp.cx10a_c8r32	100.000	nonzero	nonzero		0.001
pg1323_o2nofp.cx10a_c8r32	100.000	nonzero			0.001
pg1419_o2nofp.cx10a_c8r32	100.000	nonzero		nonzero	0.010
pg1420_o2nofp.cx10a_c8r32	100.000	nonzero	nonzero	nonzero	0.010
pg1514_o2nofp.cx10a_c8r32	100.000	nonzero			0.001
pg1515_o2nofp.cx10a_c8r32	100.000	nonzero			0.001
pg1610_o2nofp.cx10a_c8r32	100.000	nonzero			0.001
pg1611_o2nofp.cx10a_c8r32	100.000	nonzero	nonzero		0.001
pg176_o2nofp.cx10a_c8r32	100.000	nonzero			0.001
pg177_o2nofp.cx10a_c8r32	100.000	nonzero			0.001
pg180_o2nofp.cx10b_c8r32	100.000	nonzero	nonzero		0.002
pg180_o2nofp.cx10c_c8r32	100.000	nonzero	nonzero		0.003
pg180_o2nofp.cx10d_c8r32	100.000	nonzero	nonzero		0.002
pg181_o2nofp.cx10b_c8r32	100.000	nonzero	nonzero		0.001

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	1ms	4ms	16ms	max
pg1222_o2nofp.cx10a_c8r32		99.972	0.028	0.006
pg1322_o2nofp.cx10a_c8r32		99.944	0.056	0.006
pg1323_o2nofp.cx10a_c8r32		99.972	0.028	0.006
pg1419_o2nofp.cx10a_c8r32		99.944	0.056	0.006
pg1420_o2nofp.cx10a_c8r32		99.944	0.056	0.006
pg1514_o2nofp.cx10a_c8r32		99.944	0.056	0.006
pg1515_o2nofp.cx10a_c8r32	0.028	99.917	0.056	0.006
pg1610_o2nofp.cx10a_c8r32	0.083	99.861	0.056	0.006
pg1611_o2nofp.cx10a_c8r32	0.083	99.861	0.056	0.006
pg176_o2nofp.cx10a_c8r32	0.028	99.944	0.028	0.005
pg177_o2nofp.cx10a_c8r32	0.083	99.861	0.056	0.006
pg180_o2nofp.cx10b_c8r32	0.056	99.889	0.056	0.006
pg180_o2nofp.cx10c_c8r32	0.056	99.889	0.056	0.006
pg180_o2nofp.cx10d_c8r32		99.944	0.056	0.006
pg181_o2nofp.cx10b_c8r32	0.111	99.833	0.056	0.006

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	1ms	4ms	max
pg1222_o2nofp.cx10a_c8r32	49.806	50.194	0.002
pg1322_o2nofp.cx10a_c8r32	46.861	53.139	0.002
pg1323_o2nofp.cx10a_c8r32	55.611	44.389	0.002
pg1419_o2nofp.cx10a_c8r32	54.750	45.250	0.002
pg1420_o2nofp.cx10a_c8r32	60.417	39.583	0.002
pg1514_o2nofp.cx10a_c8r32	44.417	55.583	0.002
pg1515_o2nofp.cx10a_c8r32	51.694	48.306	0.002
pg1610_o2nofp.cx10a_c8r32	59.583	40.417	0.002
pg1611_o2nofp.cx10a_c8r32	63.194	36.806	0.002
pg176_o2nofp.cx10a_c8r32	41.972	58.028	0.002
pg177_o2nofp.cx10a_c8r32	49.528	50.472	0.002
pg180_o2nofp.cx10b_c8r32	51.250	48.750	0.002
pg180_o2nofp.cx10c_c8r32	45.722	54.278	0.002
pg180_o2nofp.cx10d_c8r32	40.083	59.917	0.002
pg181_o2nofp.cx10b_c8r32	55.472	44.528	0.002

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
100	14702	0	0.0	14.9	0.8	0.000	0.000	0.149	7.746	56201	11.3	3.823	61	8.1	40.2	0.1	0.001	14686	14542	pg1222_o2nofp.cx10a_c8r32
100	14818	0	0.0	14.9	0.8	0.000	0.000	0.149	7.743	56648	11.3	3.823	61	8.1	40.3	0.1	0.001	14814	14638	pg1322_o2nofp.cx10a_c8r32
100	14977	0	0.0	15.0	0.8	0.000	0.000	0.150	7.781	57258	12.5	3.823	67	8.2	40.3	0.1	0.001	14974	14782	pg1323_o2nofp.cx10a_c8r32
100	14855	0	0.0	15.3	0.8	0.000	0.000	0.153	7.889	56786	11.1	3.823	60	7.9	39.8	0.1	0.010	14878	14686	pg1419_o2nofp.cx10a_c8r32
100	14884	0	0.0	15.4	0.8	0.000	0.000	0.154	7.928	56892	12.4	3.822	67	7.9	39.7	0.1	0.010	14894	14686	pg1420_o2nofp.cx10a_c8r32
100	15045	0	0.0	13.2	0.8	0.000	0.000	0.132	7.708	57481	11.1	3.821	59	7.9	39.8	0.1	0.001	15054	14830	pg1514_o2nofp.cx10a_c8r32
100	14897	0	0.0	13.1	0.8	0.000	0.000	0.131	7.715	56891	12.4	3.819	67	7.9	40.1	0.1	0.001	14894	14686	pg1515_o2nofp.cx10a_c8r32
100	14971	0	0.0	13.3	0.8	0.000	0.000	0.133	7.719	57200	11.0	3.821	59	7.9	39.7	0.1	0.001	14975	14798	pg1610_o2nofp.cx10a_c8r32
100	14912	0	0.0	13.1	0.8	0.000	0.000	0.131	7.708	56978	12.4	3.821	67	7.9	40.2	0.1	0.001	14926	14686	pg1611_o2nofp.cx10a_c8r32
100	15080	0	0.0	12.4	0.8	0.000	0.000	0.124	7.731	57601	11.2	3.820	59	7.9	39.9	0.1	0.001	15070	14910	pg176_o2nofp.cx10a_c8r32
100	15118	0	0.0	12.4	0.8	0.000	0.000	0.124	7.750	57721	12.4	3.818	66	7.9	39.9	0.1	0.001	15118	14894	pg177_o2nofp.cx10a_c8r32
100	14902	0	0.0	12.3	0.8	0.000	0.000	0.123	7.710	56893	11.1	3.818	60	7.9	39.7	0.1	0.002	14894	14702	pg180_o2nofp.cx10b_c8r32
100	14824	0	0.0	12.4	0.8	0.000	0.000	0.124	7.740	56625	11.4	3.820	62	7.9	39.6	0.1	0.003	14830	14638	pg180_o2nofp.cx10c_c8r32
100	14874	0	0.0	12.4	0.8	0.000	0.000	0.124	7.743	56784	11.3	3.818	61	7.9	39.6	0.1	0.002	14878	14686	pg180_o2nofp.cx10d_c8r32
100	14736	0	0.0	12.4	0.8	0.000	0.000	0.124	7.737	56290	12.4	3.820	67	7.9	39.8	0.1	0.001	14750	14510	pg181_o2nofp.cx10b_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
0.000	0.000	0.000	0.000	0.000	0.000	14.87	772.8	2.788	16.78	5.606	52.49	2.000	9.598	0.000	0.000	1.679	4.799	3.433	2.170	0.093	3.928		pg1222_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	14.92	772.5	2.835	16.95	5.097	52.35	2.000	9.598	0.000	0.000	1.653	4.799	3.461	1.890	0.085	3.709		pg1322_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	15.02	776.4	2.879	17.30	5.364	52.42	2.000	9.604	0.000	0.000	1.586	4.802	3.460	1.877	0.089	3.777		pg1323_o2nofp.cx10a_c8r32
0.001	0.004	0.000	0.000	0.000	0.011	15.24	786.2	2.539	15.40	5.141	52.42	2.001	10.01	0.000	0.000	1.508	5.002	3.472	1.378	0.085	3.581		pg1419_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	15.35	790.0	2.514	15.17	5.390	52.44	2.001	10.01	0.000	0.000	1.819	5.002	3.477	1.903	0.091	3.822		pg1420_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	13.15	768.3	0.258	2.045	6.211	60.53	0.001	0.002	0.000	0.000	0.000	0.011	3.461	1.317	0.084	3.496		pg1514_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	13.09	769.7	0.261	2.085	6.241	60.58	0.001	0.002	0.000	0.000	0.003	0.011	3.446	1.548	0.085	3.570		pg1515_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	13.25	769.1	0.254	2.036	6.242	60.21	0.001	0.002	0.000	0.000	0.000	0.011	3.476	1.456	0.085	3.569		pg1610_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	13.10	768.2	0.250	1.986	6.258	60.62	0.001	0.002	0.000	0.000	0.000	0.011	3.452	1.478	0.085	3.512		pg1611_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	12.37	770.6	0.246	2.088	6.674	65.41	0.001	0.002	0.000	0.000	0.003	0.011	2.832	1.397	0.083	2.882		pg176_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	12.39	773.1	0.241	2.083	6.645	65.61	0.001	0.002	0.000	0.000	0.000	0.011	2.835	1.520	0.084	2.992		pg177_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	12.30	768.9	0.242	2.048	6.846	65.76	0.001	0.002	0.000	0.000	0.003	0.011	2.819	2.114	0.087	3.090		pg180_o2nofp.cx10b_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	12.37	771.3	0.245	2.068	6.864	65.50	0.001	0.002	0.000	0.000	0.003	0.011	2.843	2.090	0.087	3.127		pg180_o2nofp.cx10c_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	12.39	772.3	0.249	2.129	6.864	65.49	0.001	0.002	0.000	0.000	0.003	0.011	2.834	2.093	0.087	3.119		pg180_o2nofp.cx10d_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	12.39	770.9	0.246	2.080	6.709	65.40	0.001	0.002	0.000	0.000	0.000	0.011	2.831	1.476	0.085	2.959		pg181_o2nofp.cx10b_c8r32

qp100.L2

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

Average throughput:

dbms	256us	1ms	4ms	16ms	max
pg1222_o2nofp.cx10a_c8r32	99.999	0.001	nonzero		0.002
pg1322_o2nofp.cx10a_c8r32	99.999	0.001			0.001
pg1323_o2nofp.cx10a_c8r32	99.999	0.001			0.001
pg1419_o2nofp.cx10a_c8r32	99.999	0.001	nonzero		0.002
pg1420_o2nofp.cx10a_c8r32	99.998	0.002			0.001
pg1514_o2nofp.cx10a_c8r32	99.999	0.001	nonzero		0.002
pg1515_o2nofp.cx10a_c8r32	99.999	0.001	nonzero		0.001
pg1610_o2nofp.cx10a_c8r32	99.999	0.001			0.001
pg1611_o2nofp.cx10a_c8r32	99.999	0.001			0.001
pg176_o2nofp.cx10a_c8r32	99.999	0.001	nonzero		0.001
pg177_o2nofp.cx10a_c8r32	99.999	0.001	nonzero		0.001
pg180_o2nofp.cx10b_c8r32	99.999	0.001	nonzero	nonzero	0.004
pg180_o2nofp.cx10c_c8r32	99.999	0.001	nonzero		0.002
pg180_o2nofp.cx10d_c8r32	99.998	0.002	nonzero		0.002
pg181_o2nofp.cx10b_c8r32	99.999	0.001	nonzero		0.001

dbms	4ms	16ms	max
pg1222_o2nofp.cx10a_c8r32	99.944	0.056	0.006
pg1322_o2nofp.cx10a_c8r32	99.944	0.056	0.006
pg1323_o2nofp.cx10a_c8r32	99.972	0.028	0.005
pg1419_o2nofp.cx10a_c8r32	99.889	0.111	0.010
pg1420_o2nofp.cx10a_c8r32	99.972	0.028	0.006
pg1514_o2nofp.cx10a_c8r32	99.944	0.056	0.006
pg1515_o2nofp.cx10a_c8r32	99.944	0.056	0.006
pg1610_o2nofp.cx10a_c8r32	99.944	0.056	0.006
pg1611_o2nofp.cx10a_c8r32	99.944	0.056	0.006
pg176_o2nofp.cx10a_c8r32	99.944	0.056	0.005
pg177_o2nofp.cx10a_c8r32	99.944	0.056	0.005
pg180_o2nofp.cx10b_c8r32	99.833	0.167	0.009
pg180_o2nofp.cx10c_c8r32	99.778	0.222	0.010
pg180_o2nofp.cx10d_c8r32	99.944	0.056	0.006
pg181_o2nofp.cx10b_c8r32	99.972	0.028	0.006

dbms	1ms	4ms	16ms	max
pg1222_o2nofp.cx10a_c8r32	1.528	98.444	0.028	0.005
pg1322_o2nofp.cx10a_c8r32	0.028	99.944	0.028	0.005
pg1323_o2nofp.cx10a_c8r32	0.389	99.583	0.028	0.005
pg1419_o2nofp.cx10a_c8r32	0.306	99.639	0.056	0.011
pg1420_o2nofp.cx10a_c8r32	4.444	95.528	0.028	0.005
pg1514_o2nofp.cx10a_c8r32	3.111	96.861	0.028	0.004
pg1515_o2nofp.cx10a_c8r32	1.222	98.750	0.028	0.004
pg1610_o2nofp.cx10a_c8r32	1.194	98.778	0.028	0.005
pg1611_o2nofp.cx10a_c8r32	3.250	96.722	0.028	0.005
pg176_o2nofp.cx10a_c8r32		99.972	0.028	0.005
pg177_o2nofp.cx10a_c8r32	0.417	99.556	0.028	0.004
pg180_o2nofp.cx10b_c8r32	0.083	99.889	0.028	0.005
pg180_o2nofp.cx10c_c8r32	0.028	99.944	0.028	0.005
pg180_o2nofp.cx10d_c8r32	0.111	99.861	0.028	0.005
pg181_o2nofp.cx10b_c8r32	0.556	99.417	0.028	0.005

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
100	8524	0	0.0	63.4	1.7	0.000	0.000	0.634	17.041	33064	11.1	3.879	104	8.1	40.2	0.2	0.002	8527	8463	pg1222_o2nofp.cx10a_c8r32
100	8515	0	0.0	63.2	1.7	0.000	0.000	0.632	17.057	33031	11.3	3.879	106	8.1	40.3	0.2	0.001	8511	8463	pg1322_o2nofp.cx10a_c8r32
100	8504	0	0.0	63.2	1.7	0.000	0.000	0.633	17.068	33023	12.4	3.883	117	8.2	40.3	0.2	0.001	8511	8431	pg1323_o2nofp.cx10a_c8r32
100	8392	0	0.0	62.3	1.7	0.000	0.000	0.624	17.008	32502	11.5	3.873	110	7.9	39.8	0.1	0.002	8399	8351	pg1419_o2nofp.cx10a_c8r32
100	8429	0	0.0	62.3	1.7	0.000	0.000	0.624	17.016	32642	12.4	3.873	118	7.9	39.7	0.1	0.001	8431	8383	pg1420_o2nofp.cx10a_c8r32
100	8493	0	0.0	60.0	1.6	0.000	0.000	0.600	16.803	32852	11.5	3.868	108	7.9	39.8	0.2	0.002	8495	8447	pg1514_o2nofp.cx10a_c8r32
100	8467	0	0.0	60.0	1.6	0.000	0.000	0.600	16.798	32735	12.4	3.866	117	7.9	40.1	0.1	0.001	8463	8399	pg1515_o2nofp.cx10a_c8r32
100	8545	0	0.0	60.1	1.6	0.000	0.000	0.601	16.776	33051	11.3	3.868	106	7.9	39.7	0.1	0.001	8543	8495	pg1610_o2nofp.cx10a_c8r32
100	8521	0	0.0	60.0	1.6	0.000	0.000	0.600	16.813	32961	12.4	3.868	116	7.9	40.2	0.1	0.001	8527	8447	pg1611_o2nofp.cx10a_c8r32
100	8405	0	0.0	58.8	1.6	0.000	0.000	0.588	16.820	32497	11.5	3.866	109	7.9	39.9	0.1	0.001	8415	8367	pg176_o2nofp.cx10a_c8r32
100	8465	0	0.0	58.7	1.6	0.000	0.000	0.587	16.771	32714	12.4	3.865	117	7.9	39.9	0.1	0.001	8479	8383	pg177_o2nofp.cx10a_c8r32
100	8378	0	0.0	59.0	1.6	0.000	0.000	0.590	16.838	32381	11.5	3.865	110	7.9	39.7	0.1	0.004	8383	8319	pg180_o2nofp.cx10b_c8r32
100	8360	0	0.0	58.9	1.6	0.000	0.000	0.590	16.858	32325	11.5	3.867	110	7.9	39.6	0.1	0.002	8367	8303	pg180_o2nofp.cx10c_c8r32
100	8422	0	0.0	58.8	1.6	0.000	0.000	0.589	16.818	32560	11.5	3.866	109	7.9	39.6	0.1	0.002	8431	8367	pg180_o2nofp.cx10d_c8r32
100	8391	0	0.0	58.9	1.6	0.000	0.000	0.589	16.771	32428	12.4	3.865	118	7.9	39.8	0.1	0.001	8383	8335	pg181_o2nofp.cx10b_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
0.000	0.000	0.000	0.000	0.000	0.000	63.31	1697.5	3.271	6.338	4.736	29.22	2.001	9.600	0.000	0.000	0.934	4.799	3.418	1.904	0.312	4.371		pg1222_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	63.10	1699.0	3.338	6.347	4.746	29.40	2.001	9.600	0.000	0.000	1.230	4.799	3.411	1.645	0.309	4.312		pg1322_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	63.14	1698.6	3.315	6.280	4.759	29.45	2.001	9.607	0.000	0.000	1.290	4.802	3.418	1.712	0.309	4.376		pg1323_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	62.25	1692.6	3.112	6.090	4.787	30.08	2.001	10.01	0.000	0.000	1.084	5.002	3.417	1.236	0.307	4.200		pg1419_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	62.28	1693.4	2.995	5.790	4.730	29.75	1.998	9.988	0.000	0.000	1.185	4.970	3.419	1.671	0.305	4.344		pg1420_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	59.94	1672.2	0.636	1.242	5.209	31.34	0.001	0.002	0.000	0.000	0.003	0.011	3.415	1.254	0.315	4.202		pg1514_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	59.92	1673.4	0.648	1.339	5.177	31.33	0.001	0.002	0.000	0.000	0.000	0.011	3.421	1.375	0.312	4.168		pg1515_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	60.01	1669.3	0.641	1.279	5.217	31.20	0.001	0.002	0.000	0.000	0.003	0.011	3.421	1.246	0.317	4.185		pg1610_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	59.89	1672.9	0.627	1.196	5.216	31.38	0.001	0.002	0.000	0.000	0.003	0.011	3.417	1.321	0.316	4.215		pg1611_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	58.69	1673.7	0.634	1.237	5.905	32.75	0.001	9.130	0.000	0.000	0.003	45.65	2.603	1.354	0.349	4.026		pg176_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	58.60	1670.7	0.655	1.342	5.896	32.74	0.001	0.002	0.000	0.000	0.003	0.011	2.599	1.408	0.349	4.057		pg177_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	58.92	1677.5	0.780	1.819	5.872	32.86	0.001	0.002	0.000	0.000	0.000	0.011	2.592	1.850	0.350	4.093		pg180_o2nofp.cx10b_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	58.84	1677.6	0.929	2.276	5.911	32.75	0.001	0.002	0.000	0.000	0.006	0.011	2.566	1.844	0.351	4.113		pg180_o2nofp.cx10c_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	58.75	1673.7	0.638	1.301	5.882	32.43	0.001	0.002	0.000	0.000	0.003	0.011	2.583	1.861	0.349	4.124		pg180_o2nofp.cx10d_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	58.86	1670.8	0.641	1.299	5.924	32.29	0.001	0.002	0.000	0.000	0.000	0.011	2.598	1.361	0.352	4.017		pg181_o2nofp.cx10b_c8r32

qr500.L3

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

Average throughput:

dbms	256us	1ms	4ms	16ms	max
pg1222_o2nofp.cx10a_c8r32	99.999	0.001	nonzero		0.002
pg1322_o2nofp.cx10a_c8r32	99.999	0.001	nonzero		0.002
pg1323_o2nofp.cx10a_c8r32	100.000	nonzero	nonzero		0.002
pg1419_o2nofp.cx10a_c8r32	99.999	0.001	nonzero		0.002
pg1420_o2nofp.cx10a_c8r32	99.999	0.001	nonzero		0.002
pg1514_o2nofp.cx10a_c8r32	99.999	0.001	nonzero		0.002
pg1515_o2nofp.cx10a_c8r32	99.998	0.002	nonzero		0.003
pg1610_o2nofp.cx10a_c8r32	99.999	0.001	nonzero		0.003
pg1611_o2nofp.cx10a_c8r32	99.999	0.001	nonzero		0.004
pg176_o2nofp.cx10a_c8r32	99.998	0.002	nonzero		0.003
pg177_o2nofp.cx10a_c8r32	100.000	nonzero	nonzero	nonzero	0.007
pg180_o2nofp.cx10b_c8r32	99.999	0.001	nonzero		0.003
pg180_o2nofp.cx10c_c8r32	99.999	0.001	nonzero		0.002
pg180_o2nofp.cx10d_c8r32	99.999	0.001	nonzero		0.003
pg181_o2nofp.cx10b_c8r32	99.999	0.001	nonzero		0.003

dbms	1ms	4ms	16ms	max
pg1222_o2nofp.cx10a_c8r32	22.633	77.328	0.039	0.010
pg1322_o2nofp.cx10a_c8r32	19.439	80.517	0.044	0.009
pg1323_o2nofp.cx10a_c8r32	24.278	75.672	0.050	0.009
pg1419_o2nofp.cx10a_c8r32	20.117	79.650	0.233	0.010
pg1420_o2nofp.cx10a_c8r32	27.833	72.133	0.033	0.009
pg1514_o2nofp.cx10a_c8r32	17.572	82.150	0.278	0.010
pg1515_o2nofp.cx10a_c8r32	24.922	74.956	0.122	0.010
pg1610_o2nofp.cx10a_c8r32	29.633	70.317	0.050	0.010
pg1611_o2nofp.cx10a_c8r32	25.756	74.072	0.172	0.010
pg176_o2nofp.cx10a_c8r32	21.867	77.828	0.306	0.010
pg177_o2nofp.cx10a_c8r32	18.283	81.461	0.256	0.010
pg180_o2nofp.cx10b_c8r32	23.406	76.328	0.267	0.010
pg180_o2nofp.cx10c_c8r32	21.683	77.922	0.394	0.011
pg180_o2nofp.cx10d_c8r32	21.861	78.122	0.017	0.006
pg181_o2nofp.cx10b_c8r32	23.850	76.117	0.033	0.009

dbms	1ms	4ms	16ms	max
pg1222_o2nofp.cx10a_c8r32	1.939	97.222	0.839	0.006
pg1322_o2nofp.cx10a_c8r32		98.317	1.683	0.006
pg1323_o2nofp.cx10a_c8r32	0.206	97.911	1.883	0.005
pg1419_o2nofp.cx10a_c8r32	0.039	97.356	2.606	0.010
pg1420_o2nofp.cx10a_c8r32	0.883	96.833	2.283	0.006
pg1514_o2nofp.cx10a_c8r32	0.322	97.083	2.594	0.010
pg1515_o2nofp.cx10a_c8r32	0.089	97.717	2.194	0.007
pg1610_o2nofp.cx10a_c8r32	0.100	97.128	2.772	0.006
pg1611_o2nofp.cx10a_c8r32	0.033	97.061	2.906	0.010
pg176_o2nofp.cx10a_c8r32		92.506	7.494	0.013
pg177_o2nofp.cx10a_c8r32		93.561	6.439	0.011
pg180_o2nofp.cx10b_c8r32	0.022	95.756	4.222	0.006
pg180_o2nofp.cx10c_c8r32	0.017	96.139	3.844	0.012
pg180_o2nofp.cx10d_c8r32		96.167	3.833	0.006
pg181_o2nofp.cx10b_c8r32	0.206	96.039	3.756	0.006

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
500	13901	0	0.0	71.0	2.2	0.000	0.000	0.142	4.599	53379	11.1	3.840	64	8.2	39.0	0.4	0.002	13902	13342	pg1222_o2nofp.cx10a_c8r32
500	13899	0	0.0	70.6	2.2	0.000	0.000	0.141	4.589	53371	11.2	3.840	64	8.2	39.2	0.4	0.002	13902	13342	pg1322_o2nofp.cx10a_c8r32
500	14082	0	0.0	70.5	2.2	0.000	0.000	0.141	4.606	54114	13.0	3.843	74	8.2	39.1	0.4	0.002	14078	13486	pg1323_o2nofp.cx10a_c8r32
500	13949	0	0.0	70.4	2.3	0.000	0.000	0.141	4.707	53522	11.3	3.837	65	8.0	38.8	0.4	0.002	13950	13406	pg1419_o2nofp.cx10a_c8r32
500	13950	0	0.0	69.8	2.3	0.000	0.000	0.140	4.631	53509	13.0	3.836	75	7.9	38.5	0.3	0.002	13950	13406	pg1420_o2nofp.cx10a_c8r32
500	14136	0	0.0	68.1	2.3	0.000	0.000	0.136	4.665	54184	11.3	3.833	64	8.0	38.7	0.4	0.002	14158	13599	pg1514_o2nofp.cx10a_c8r32
500	13905	0	0.0	67.8	2.3	0.000	0.000	0.136	4.625	53275	12.9	3.831	74	8.0	39.0	0.3	0.003	13902	13326	pg1515_o2nofp.cx10a_c8r32
500	14172	0	0.0	67.9	2.2	0.000	0.000	0.136	4.589	54312	11.2	3.832	63	7.9	38.6	3.6	0.003	14174	13646	pg1610_o2nofp.cx10a_c8r32
500	14133	0	0.0	67.8	2.3	0.000	0.000	0.136	4.631	54175	13.0	3.833	74	8.0	39.1	4.0	0.004	14126	13566	pg1611_o2nofp.cx10a_c8r32
500	13821	0	0.0	67.3	2.3	0.000	0.000	0.135	4.655	52938	11.4	3.830	66	8.0	38.7	0.4	0.003	13838	13198	pg176_o2nofp.cx10a_c8r32
500	13946	0	0.0	67.4	2.3	0.000	0.000	0.135	4.642	53419	12.9	3.830	74	7.9	38.8	0.3	0.007	13950	13326	pg177_o2nofp.cx10a_c8r32
500	13898	0	0.0	67.6	2.3	0.000	0.000	0.135	4.652	53209	11.3	3.828	65	8.0	38.6	0.3	0.003	13902	13198	pg180_o2nofp.cx10b_c8r32
500	13861	0	0.0	67.5	2.3	0.000	0.000	0.135	4.689	53093	11.4	3.831	66	8.0	38.6	0.4	0.002	13854	13230	pg180_o2nofp.cx10c_c8r32
500	13810	0	0.0	67.2	2.2	0.000	0.000	0.134	4.590	52921	11.4	3.832	66	7.9	38.4	0.3	0.003	13822	13166	pg180_o2nofp.cx10d_c8r32
500	13609	0	0.0	67.2	2.2	0.000	0.000	0.134	4.584	52099	12.8	3.828	75	7.9	38.6	0.3	0.003	13598	12990	pg181_o2nofp.cx10b_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
0.000	0.000	0.000	0.000	0.000	0.000	70.86	2285.8	4.071	6.612	3.964	33.00	2.044	683.7	0.000	0.000	1.157	42.73	4.265	1.919	0.285	4.430		pg1222_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	70.53	2281.0	4.089	6.731	4.088	32.99	2.048	685.1	0.000	0.000	1.320	40.90	4.207	1.702	0.292	4.361		pg1322_o2nofp.cx10a_c8r32
0.001	0.002	0.000	0.000	0.000	0.011	70.43	2288.2	3.975	6.593	4.098	33.15	2.045	685.0	0.000	0.000	1.089	44.31	4.247	1.705	0.294	4.334		pg1323_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	70.32	2339.2	4.107	6.735	4.086	34.26	2.041	685.4	0.000	0.000	1.092	41.63	4.263	1.292	0.290	4.197		pg1419_o2nofp.cx10a_c8r32
0.001	0.002	0.000	0.000	0.000	0.011	69.69	2300.6	3.490	5.805	4.077	33.70	2.045	694.6	0.000	0.000	1.146	43.02	4.244	1.713	0.288	4.353		pg1420_o2nofp.cx10a_c8r32
0.001	0.002	0.000	0.000	0.025	0.011	68.04	2317.4	1.640	2.783	4.431	35.47	0.045	675.4	0.000	0.000	0.004	42.76	4.202	1.324	0.299	4.157		pg1514_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	67.70	2298.7	1.595	2.895	4.412	35.37	0.046	684.6	0.000	0.000	0.005	41.75	4.241	1.423	0.296	4.159		pg1515_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	67.81	2280.0	1.125	1.739	4.398	34.79	0.045	675.4	0.000	0.000	0.001	42.76	4.270	1.301	0.296	4.180		pg1610_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	67.70	2300.7	1.554	2.922	4.440	35.41	0.045	679.7	0.000	0.000	0.004	87.73	4.236	1.419	0.299	4.190		pg1611_o2nofp.cx10a_c8r32
0.001	0.002	0.000	0.000	0.000	0.011	67.20	2312.6	1.657	3.042	4.811	36.04	0.045	684.6	0.000	0.000	0.001	42.80	3.838	1.353	0.321	4.129		pg176_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	67.36	2306.6	1.452	2.623	4.678	35.94	0.044	684.6	0.000	0.000	0.005	43.89	3.940	1.409	0.313	4.193		pg177_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	67.50	2312.6	1.448	2.455	4.670	35.70	0.045	684.6	0.000	0.000	0.005	43.34	3.857	1.913	0.315	4.301		pg180_o2nofp.cx10b_c8r32
0.001	0.004	0.000	0.000	0.025	0.022	67.44	2329.9	1.733	3.077	4.669	36.29	0.045	684.6	0.000	0.000	0.002	42.80	3.807	1.913	0.314	4.297		pg180_o2nofp.cx10c_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	67.08	2279.8	1.147	1.791	4.734	35.34	0.046	684.6	0.000	0.000	0.005	42.27	3.895	1.877	0.314	4.309		pg180_o2nofp.cx10d_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	67.12	2278.7	1.201	1.948	4.728	35.33	0.043	684.6	0.000	0.000	0.002	44.46	3.918	1.399	0.314	4.138		pg181_o2nofp.cx10b_c8r32

qp500.L4

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

Average throughput:

dbms	256us	1ms	4ms	16ms	max
pg1222_o2nofp.cx10a_c8r32	99.996	0.004	nonzero		0.002
pg1322_o2nofp.cx10a_c8r32	99.996	0.004	nonzero		0.002
pg1323_o2nofp.cx10a_c8r32	99.996	0.004	nonzero		0.002
pg1419_o2nofp.cx10a_c8r32	99.996	0.003	nonzero		0.004
pg1420_o2nofp.cx10a_c8r32	99.996	0.004	nonzero		0.002
pg1514_o2nofp.cx10a_c8r32	99.996	0.004	nonzero		0.002
pg1515_o2nofp.cx10a_c8r32	99.996	0.003	nonzero		0.002
pg1610_o2nofp.cx10a_c8r32	99.996	0.004	nonzero		0.002
pg1611_o2nofp.cx10a_c8r32	99.996	0.004	nonzero		0.002
pg176_o2nofp.cx10a_c8r32	99.997	0.003	nonzero		0.002
pg177_o2nofp.cx10a_c8r32	99.997	0.003	nonzero		0.002
pg180_o2nofp.cx10b_c8r32	99.996	0.004	nonzero		0.002
pg180_o2nofp.cx10c_c8r32	99.996	0.004	nonzero	nonzero	0.006
pg180_o2nofp.cx10d_c8r32	99.997	0.003	nonzero		0.002
pg181_o2nofp.cx10b_c8r32	99.997	0.003	nonzero		0.002

dbms	1ms	4ms	16ms	64ms	max
pg1222_o2nofp.cx10a_c8r32	24.639	75.344	0.006	0.011	0.020
pg1322_o2nofp.cx10a_c8r32	21.578	78.389	0.022	0.011	0.029
pg1323_o2nofp.cx10a_c8r32	28.889	71.100	0.011		0.006
pg1419_o2nofp.cx10a_c8r32	10.461	89.500	0.022	0.017	0.023
pg1420_o2nofp.cx10a_c8r32	29.083	70.900	0.006	0.011	0.023
pg1514_o2nofp.cx10a_c8r32	30.922	69.022	0.050	0.006	0.020
pg1515_o2nofp.cx10a_c8r32	29.894	70.050	0.044	0.011	0.021
pg1610_o2nofp.cx10a_c8r32	20.167	79.789	0.033	0.011	0.024
pg1611_o2nofp.cx10a_c8r32	32.811	67.161	0.017	0.011	0.019
pg176_o2nofp.cx10a_c8r32	20.667	79.278	0.056		0.016
pg177_o2nofp.cx10a_c8r32	25.083	74.867	0.044	0.006	0.025
pg180_o2nofp.cx10b_c8r32	18.528	81.417	0.039	0.017	0.027
pg180_o2nofp.cx10c_c8r32	15.872	84.078	0.033	0.017	0.030
pg180_o2nofp.cx10d_c8r32	22.283	77.689	0.017	0.011	0.021
pg181_o2nofp.cx10b_c8r32	26.261	73.567	0.161	0.011	0.021

dbms	1ms	4ms	16ms	64ms	max
pg1222_o2nofp.cx10a_c8r32	31.983	63.722	4.289	0.006	0.018
pg1322_o2nofp.cx10a_c8r32	18.478	75.311	6.200	0.011	0.021
pg1323_o2nofp.cx10a_c8r32	25.189	67.367	7.444		0.013
pg1419_o2nofp.cx10a_c8r32	20.067	71.317	8.606	0.011	0.021
pg1420_o2nofp.cx10a_c8r32	26.417	64.244	9.328	0.011	0.022
pg1514_o2nofp.cx10a_c8r32	18.006	73.872	8.117	0.006	0.019
pg1515_o2nofp.cx10a_c8r32	17.950	71.383	10.656	0.011	0.020
pg1610_o2nofp.cx10a_c8r32	20.406	64.539	15.044	0.011	0.022
pg1611_o2nofp.cx10a_c8r32	20.267	64.661	15.061	0.011	0.017
pg176_o2nofp.cx10a_c8r32	18.356	59.078	22.567		0.014
pg177_o2nofp.cx10a_c8r32	18.150	59.767	22.078	0.006	0.023
pg180_o2nofp.cx10b_c8r32	16.278	75.961	7.744	0.017	0.026
pg180_o2nofp.cx10c_c8r32	17.117	77.300	5.567	0.017	0.022
pg180_o2nofp.cx10d_c8r32	17.400	77.383	5.211	0.006	0.019
pg181_o2nofp.cx10b_c8r32	17.322	77.483	5.189	0.006	0.019

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
500	8516	0	0.0	45.8	3.0	0.000	0.000	0.092	6.141	33186	11.6	3.897	109	8.2	36.9	0.3	0.002	8511	8431	pg1222_o2nofp.cx10a_c8r32
500	8454	0	0.0	45.9	3.0	0.000	0.000	0.092	6.128	32946	11.6	3.897	110	8.2	37.0	0.3	0.002	8463	8367	pg1322_o2nofp.cx10a_c8r32
500	8453	0	0.0	45.9	3.0	0.000	0.000	0.092	6.152	32978	12.6	3.902	119	8.2	37.0	0.3	0.002	8463	8399	pg1323_o2nofp.cx10a_c8r32
500	8397	0	0.0	45.4	3.0	0.000	0.000	0.091	6.129	32673	11.6	3.891	111	8.0	36.6	0.3	0.004	8399	8335	pg1419_o2nofp.cx10a_c8r32
500	8382	0	0.0	45.3	3.0	0.000	0.000	0.091	6.089	32590	12.6	3.888	120	7.9	36.4	0.3	0.002	8383	8319	pg1420_o2nofp.cx10a_c8r32
500	8459	0	0.0	43.2	3.0	0.000	0.000	0.087	6.082	32859	11.6	3.884	110	8.0	36.6	0.3	0.002	8463	8383	pg1514_o2nofp.cx10a_c8r32
500	8483	0	0.0	43.2	3.0	0.000	0.000	0.087	6.087	32956	12.6	3.885	119	8.0	36.9	0.3	0.002	8495	8399	pg1515_o2nofp.cx10a_c8r32
500	8433	0	0.0	43.2	3.0	0.000	0.000	0.087	6.056	32760	11.6	3.885	110	7.9	36.5	1.7	0.002	8431	8351	pg1610_o2nofp.cx10a_c8r32
500	8482	0	0.0	43.1	3.0	0.000	0.000	0.086	6.085	32949	12.6	3.885	119	8.0	37.0	1.7	0.002	8495	8399	pg1611_o2nofp.cx10a_c8r32
500	8361	0	0.0	42.0	3.0	0.000	0.000	0.084	6.085	32447	11.6	3.881	111	8.0	36.6	0.3	0.002	8367	8271	pg176_o2nofp.cx10a_c8r32
500	8413	0	0.0	41.9	3.0	0.000	0.000	0.084	6.079	32645	12.7	3.880	121	8.0	36.7	0.3	0.002	8415	8335	pg177_o2nofp.cx10a_c8r32
500	8349	0	0.0	41.9	3.0	0.000	0.000	0.084	6.066	32380	11.6	3.878	111	8.0	36.5	0.2	0.002	8351	8239	pg180_o2nofp.cx10b_c8r32
500	8359	0	0.0	41.6	2.9	0.000	0.000	0.083	6.033	32423	11.6	3.879	111	8.0	36.5	0.2	0.006	8367	8271	pg180_o2nofp.cx10c_c8r32
500	8373	0	0.0	41.5	2.9	0.000	0.000	0.083	6.033	32497	11.6	3.881	111	7.9	36.3	0.2	0.002	8383	8287	pg180_o2nofp.cx10d_c8r32
500	8369	0	0.0	41.8	3.0	0.000	0.000	0.084	6.062	32462	12.6	3.879	120	7.9	36.5	0.2	0.002	8367	8271	pg181_o2nofp.cx10b_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
0.000	0.000	0.000	0.000	0.000	0.000	45.53	3035.1	3.897	8.105	2.096	61.79	2.086	1251.1	0.000	0.000	0.839	43.45	3.992	1.824	0.091	3.241		pg1222_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	45.66	3028.8	3.960	8.471	2.084	61.48	2.085	1251.1	0.000	0.000	1.000	73.99	4.001	1.610	0.091	3.207		pg1322_o2nofp.cx10a_c8r32
0.001	0.004	0.000	0.000	0.000	0.011	45.67	3038.5	4.219	8.826	2.093	61.58	2.087	1261.5	0.000	0.000	0.943	43.96	4.029	1.661	0.092	3.190		pg1323_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	45.07	3026.6	3.673	7.740	2.134	62.04	2.086	1260.7	0.000	0.000	0.824	41.84	4.007	1.298	0.090	3.114		pg1419_o2nofp.cx10a_c8r32
0.003	0.011	0.000	0.000	0.000	0.011	45.05	3009.1	3.609	7.681	2.125	61.65	2.085	1251.5	0.000	0.000	1.017	43.81	4.002	1.487	0.092	3.245		pg1420_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	42.96	3004.4	1.490	2.457	2.377	65.18	0.089	1250.6	0.000	0.000	0.005	40.07	4.023	1.232	0.092	3.128		pg1514_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	42.94	3005.8	1.532	2.592	2.422	65.19	0.084	1241.5	0.000	0.000	0.005	41.68	4.021	1.380	0.095	3.160		pg1515_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	42.96	2991.0	1.354	2.154	2.375	64.86	0.086	1241.5	0.000	0.000	0.004	40.65	4.004	1.218	0.091	3.043		pg1610_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	42.85	3005.0	1.532	2.467	2.413	65.34	0.083	1241.5	0.000	0.000	0.008	42.25	3.986	1.372	0.093	3.147		pg1611_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	41.75	3006.0	1.558	2.597	2.654	67.85	0.087	1241.5	0.000	0.000	0.004	40.11	3.384	1.299	0.099	2.885		pg176_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	41.66	3002.3	1.461	2.443	2.626	67.53	0.085	1241.5	0.000	0.000	0.004	41.45	3.397	1.319	0.097	2.900		pg177_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	41.61	2997.5	1.564	3.069	2.722	67.06	0.086	1241.5	0.000	0.000	0.005	40.86	3.230	1.833	0.102	3.006		pg180_o2nofp.cx10b_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	41.30	2981.1	1.395	2.524	2.742	66.74	0.083	1241.5	0.000	0.000	0.005	42.25	3.134	1.824	0.098	2.995		pg180_o2nofp.cx10c_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	41.20	2979.9	1.478	2.900	2.746	66.50	0.086	1241.5	0.000	0.000	0.007	40.87	3.113	1.826	0.098	3.007		pg180_o2nofp.cx10d_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	41.55	2996.1	1.614	3.445	2.688	66.65	0.085	1241.5	0.000	0.000	0.004	41.40	3.178	1.383	0.098	2.871		pg181_o2nofp.cx10b_c8r32

qr1000.L5

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

Average throughput:

dbms	256us	1ms	4ms	16ms	max
pg1222_o2nofp.cx10a_c8r32	99.998	0.002	nonzero	nonzero	0.006
pg1322_o2nofp.cx10a_c8r32	99.998	0.002	nonzero	nonzero	0.006
pg1323_o2nofp.cx10a_c8r32	99.998	0.002	nonzero	nonzero	0.005
pg1419_o2nofp.cx10a_c8r32	99.998	0.002	nonzero	nonzero	0.006
pg1420_o2nofp.cx10a_c8r32	99.998	0.002	nonzero	nonzero	0.005
pg1514_o2nofp.cx10a_c8r32	99.998	0.002	nonzero	nonzero	0.005
pg1515_o2nofp.cx10a_c8r32	99.998	0.002	nonzero	nonzero	0.005
pg1610_o2nofp.cx10a_c8r32	99.998	0.002	nonzero	nonzero	0.005
pg1611_o2nofp.cx10a_c8r32	99.998	0.002	nonzero	nonzero	0.005
pg176_o2nofp.cx10a_c8r32	99.998	0.002	nonzero	nonzero	0.005
pg177_o2nofp.cx10a_c8r32	99.998	0.002	nonzero	nonzero	0.005
pg180_o2nofp.cx10b_c8r32	99.998	0.002	nonzero	nonzero	0.005
pg180_o2nofp.cx10c_c8r32	99.998	0.002	nonzero	nonzero	0.006
pg180_o2nofp.cx10d_c8r32	99.998	0.002	nonzero	nonzero	0.013
pg181_o2nofp.cx10b_c8r32	99.998	0.002	nonzero	nonzero	0.005

dbms	1ms	4ms	16ms	64ms	max
pg1222_o2nofp.cx10a_c8r32	39.497	60.492	0.011		0.010
pg1322_o2nofp.cx10a_c8r32	41.581	58.411	0.008		0.008
pg1323_o2nofp.cx10a_c8r32	44.081	55.917	0.003		0.005
pg1419_o2nofp.cx10a_c8r32	40.494	59.494	0.011		0.009
pg1420_o2nofp.cx10a_c8r32	47.342	52.647	0.011		0.015
pg1514_o2nofp.cx10a_c8r32	40.878	59.114	0.008		0.009
pg1515_o2nofp.cx10a_c8r32	45.494	54.497	0.008		0.007
pg1610_o2nofp.cx10a_c8r32	40.017	59.942	0.042		0.010
pg1611_o2nofp.cx10a_c8r32	46.425	53.561	0.014		0.009
pg176_o2nofp.cx10a_c8r32	45.189	54.789	0.022		0.011
pg177_o2nofp.cx10a_c8r32	43.536	56.442	0.019	0.003	0.022
pg180_o2nofp.cx10b_c8r32	46.939	53.042	0.019		0.010
pg180_o2nofp.cx10c_c8r32	49.031	50.958	0.011		0.008
pg180_o2nofp.cx10d_c8r32	47.442	52.475	0.078	0.006	0.018
pg181_o2nofp.cx10b_c8r32	48.981	50.981	0.039		0.010

dbms	1ms	4ms	16ms	64ms	max
pg1222_o2nofp.cx10a_c8r32	12.600	85.842	1.558		0.008
pg1322_o2nofp.cx10a_c8r32	9.939	87.244	2.817		0.009
pg1323_o2nofp.cx10a_c8r32	12.308	85.042	2.650		0.008
pg1419_o2nofp.cx10a_c8r32	9.469	87.439	3.092		0.008
pg1420_o2nofp.cx10a_c8r32	10.200	86.756	3.042	0.003	0.026
pg1514_o2nofp.cx10a_c8r32	10.989	86.178	2.833		0.008
pg1515_o2nofp.cx10a_c8r32	11.075	84.744	4.181		0.014
pg1610_o2nofp.cx10a_c8r32	12.828	82.931	4.242		0.010
pg1611_o2nofp.cx10a_c8r32	13.181	78.972	7.847		0.008
pg176_o2nofp.cx10a_c8r32	8.694	79.764	11.542		0.011
pg177_o2nofp.cx10a_c8r32	9.503	79.394	11.100	0.003	0.026
pg180_o2nofp.cx10b_c8r32	8.558	88.358	3.083		0.011
pg180_o2nofp.cx10c_c8r32	8.744	88.106	3.150		0.010
pg180_o2nofp.cx10d_c8r32	9.181	87.678	3.139	0.003	0.019
pg181_o2nofp.cx10b_c8r32	8.900	88.086	3.014		0.010

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
1000	13893	0	0.0	54.9	3.5	0.000	0.000	0.055	3.549	53604	11.8	3.858	68	8.2	34.5	0.4	0.006	13855	13038	pg1222_o2nofp.cx10a_c8r32
1000	13861	0	0.0	54.6	3.5	0.000	0.000	0.055	3.546	53486	11.9	3.859	69	8.2	34.7	0.4	0.006	13822	12974	pg1322_o2nofp.cx10a_c8r32
999	14007	0	0.0	54.7	3.5	0.000	0.000	0.055	3.551	54094	13.5	3.862	77	8.2	34.6	0.4	0.005	13966	13118	pg1323_o2nofp.cx10a_c8r32
1000	13946	0	0.0	54.1	3.4	0.000	0.000	0.054	3.518	53708	11.7	3.851	67	8.1	34.3	0.4	0.006	13902	13118	pg1419_o2nofp.cx10a_c8r32
1000	13942	0	0.0	53.7	3.4	0.000	0.000	0.054	3.497	53693	13.4	3.851	77	8.0	34.1	0.3	0.005	13918	13086	pg1420_o2nofp.cx10a_c8r32
999	14100	0	0.0	51.9	3.4	0.000	0.000	0.052	3.506	54274	11.7	3.849	66	8.0	34.3	0.1	0.005	14046	13246	pg1514_o2nofp.cx10a_c8r32
999	14006	0	0.0	51.5	3.4	0.000	0.000	0.052	3.490	53921	13.4	3.850	77	8.0	34.6	0.4	0.005	13982	13134	pg1515_o2nofp.cx10a_c8r32
999	14239	0	0.0	51.8	3.4	0.000	0.000	0.052	3.511	54812	11.6	3.850	65	8.0	34.2	6.5	0.005	14222	13359	pg1610_o2nofp.cx10a_c8r32
1000	13998	0	0.0	51.7	3.4	0.000	0.000	0.052	3.486	53856	13.5	3.847	77	8.0	34.6	3.2	0.005	13966	13118	pg1611_o2nofp.cx10a_c8r32
999	13880	0	0.0	51.2	3.4	0.000	0.000	0.051	3.495	53354	12.0	3.844	69	8.0	34.3	0.4	0.005	13838	12878	pg176_o2nofp.cx10a_c8r32
999	13996	0	0.0	51.1	3.4	0.000	0.000	0.051	3.501	53797	13.5	3.844	77	8.0	34.4	0.4	0.005	13950	13006	pg177_o2nofp.cx10a_c8r32
1000	13842	0	0.0	51.9	3.4	0.000	0.000	0.052	3.496	53181	11.7	3.842	68	8.0	34.2	0.3	0.005	13726	12943	pg180_o2nofp.cx10b_c8r32
1000	13774	0	0.0	52.0	3.4	0.000	0.000	0.052	3.487	52928	11.8	3.843	69	8.0	34.1	0.3	0.006	13646	13006	pg180_o2nofp.cx10c_c8r32
1000	13963	0	0.0	52.0	3.4	0.000	0.000	0.052	3.512	53648	11.8	3.842	68	8.0	34.0	0.3	0.013	13838	13166	pg180_o2nofp.cx10d_c8r32
1000	13673	0	0.0	52.2	3.4	0.000	0.000	0.052	3.523	52540	13.4	3.843	78	8.0	34.2	0.3	0.005	13534	12862	pg181_o2nofp.cx10b_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
0.000	0.000	0.000	0.000	0.000	0.000	54.69	3520.3	3.684	6.544	1.897	65.89	2.094	1387.9	0.000	0.000	0.808	43.51	4.771	1.821	0.097	3.340		pg1222_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	54.43	3517.2	3.972	7.175	1.918	66.29	2.100	1397.1	0.000	0.000	0.910	77.67	4.714	1.522	0.096	3.223		pg1322_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	54.49	3519.9	4.057	7.572	1.904	66.42	2.098	1387.9	0.000	0.000	0.944	76.79	4.739	1.625	0.096	3.239		pg1323_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	53.92	3488.7	3.715	6.709	1.984	66.00	2.092	1388.3	0.000	0.000	0.781	45.29	4.749	1.209	0.098	3.214		pg1419_o2nofp.cx10a_c8r32
0.001	0.004	0.000	0.000	0.000	0.011	53.46	3467.9	3.737	6.845	2.054	66.06	2.088	1388.3	0.000	0.000	0.902	60.73	4.749	1.476	0.102	3.315		pg1420_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	51.67	3474.3	1.603	2.293	2.186	69.17	0.091	1378.3	0.000	0.000	0.004	42.29	4.710	1.236	0.100	3.135		pg1514_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	51.26	3458.4	1.652	2.553	2.232	69.55	0.092	1378.3	0.000	0.000	0.001	41.78	4.733	1.284	0.100	3.188		pg1515_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	51.59	3479.6	1.746	2.802	2.257	69.80	0.090	1378.3	0.000	0.000	0.004	42.82	4.707	1.280	0.103	3.206		pg1610_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	51.53	3456.7	1.650	2.473	2.235	69.31	0.090	1378.3	0.000	0.000	0.005	42.82	4.742	1.346	0.101	3.209		pg1611_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	50.97	3464.2	1.674	2.517	2.370	70.64	0.091	1378.3	0.000	0.000	0.001	42.29	4.443	1.290	0.104	3.077		pg176_o2nofp.cx10a_c8r32
0.001	0.004	0.000	0.000	0.001	0.011	50.90	3470.0	1.618	2.661	2.404	70.24	0.094	1378.3	0.000	0.000	0.005	82.57	4.410	1.352	0.107	3.148		pg177_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	51.72	3465.7	1.644	2.478	2.432	68.39	0.089	1369.2	0.000	0.000	0.005	43.34	4.415	1.800	0.111	3.290		pg180_o2nofp.cx10b_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	51.76	3455.0	1.526	2.203	2.516	67.74	0.089	1360.1	0.000	0.000	0.003	88.66	4.372	1.787	0.116	3.308		pg180_o2nofp.cx10c_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	51.73	3480.4	1.763	2.748	2.434	68.01	0.088	1369.2	0.000	0.000	0.001	43.62	4.355	1.773	0.114	3.310		pg180_o2nofp.cx10d_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	52.01	3491.6	1.850	3.070	2.414	67.98	0.090	1369.2	0.000	0.000	0.003	85.31	4.422	1.361	0.110	3.160		pg181_o2nofp.cx10b_c8r32

qp1000.L6

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

Average throughput:

dbms	256us	1ms	4ms	64ms	max
pg1222_o2nofp.cx10a_c8r32	99.995	0.005	nonzero		0.002
pg1322_o2nofp.cx10a_c8r32	99.995	0.005	nonzero		0.002
pg1323_o2nofp.cx10a_c8r32	99.995	0.005	nonzero		0.001
pg1419_o2nofp.cx10a_c8r32	99.994	0.005	nonzero		0.002
pg1420_o2nofp.cx10a_c8r32	99.995	0.005	nonzero		0.001
pg1514_o2nofp.cx10a_c8r32	99.995	0.005	nonzero		0.002
pg1515_o2nofp.cx10a_c8r32	99.995	0.005	nonzero		0.002
pg1610_o2nofp.cx10a_c8r32	99.995	0.005	nonzero		0.002
pg1611_o2nofp.cx10a_c8r32	99.995	0.005			0.001
pg176_o2nofp.cx10a_c8r32	99.996	0.004	nonzero	nonzero	0.028
pg177_o2nofp.cx10a_c8r32	99.995	0.005	nonzero		0.002
pg180_o2nofp.cx10b_c8r32	99.995	0.005	nonzero		0.002
pg180_o2nofp.cx10c_c8r32	99.994	0.006	nonzero		0.001
pg180_o2nofp.cx10d_c8r32	99.995	0.005	nonzero		0.002
pg181_o2nofp.cx10b_c8r32	99.995	0.005	nonzero		0.002

dbms	1ms	4ms	16ms	64ms	max
pg1222_o2nofp.cx10a_c8r32	33.814	66.178	0.008		0.006
pg1322_o2nofp.cx10a_c8r32	24.981	75.008	0.011		0.009
pg1323_o2nofp.cx10a_c8r32	37.381	62.611	0.008		0.006
pg1419_o2nofp.cx10a_c8r32	27.744	72.247	0.006	0.003	0.021
pg1420_o2nofp.cx10a_c8r32	36.958	63.022	0.019		0.009
pg1514_o2nofp.cx10a_c8r32	32.161	67.825	0.014		0.007
pg1515_o2nofp.cx10a_c8r32	37.619	62.369	0.011		0.007
pg1610_o2nofp.cx10a_c8r32	30.144	69.844	0.011		0.006
pg1611_o2nofp.cx10a_c8r32	36.086	63.903	0.008	0.003	0.029
pg176_o2nofp.cx10a_c8r32	25.525	74.458	0.014	0.003	0.024
pg177_o2nofp.cx10a_c8r32	32.992	66.989	0.019		0.009
pg180_o2nofp.cx10b_c8r32	22.333	77.647	0.017	0.003	0.017
pg180_o2nofp.cx10c_c8r32	41.269	58.714	0.014	0.003	0.017
pg180_o2nofp.cx10d_c8r32	39.389	60.600	0.008	0.003	0.017
pg181_o2nofp.cx10b_c8r32	43.967	56.017	0.011	0.006	0.028

dbms	1ms	4ms	16ms	64ms	max
pg1222_o2nofp.cx10a_c8r32	15.597	82.672	1.731		0.011
pg1322_o2nofp.cx10a_c8r32	10.347	85.872	3.781		0.011
pg1323_o2nofp.cx10a_c8r32	10.047	85.889	4.064		0.010
pg1419_o2nofp.cx10a_c8r32	10.700	85.417	3.881	0.003	0.019
pg1420_o2nofp.cx10a_c8r32	10.192	85.639	4.169		0.011
pg1514_o2nofp.cx10a_c8r32	10.947	85.386	3.667		0.011
pg1515_o2nofp.cx10a_c8r32	10.000	84.331	5.669		0.011
pg1610_o2nofp.cx10a_c8r32	15.881	76.067	8.053		0.011
pg1611_o2nofp.cx10a_c8r32	10.519	80.181	9.297	0.003	0.027
pg176_o2nofp.cx10a_c8r32	8.197	78.631	13.169	0.003	0.022
pg177_o2nofp.cx10a_c8r32	8.997	79.653	11.350		0.012
pg180_o2nofp.cx10b_c8r32	13.747	81.283	4.969		0.012
pg180_o2nofp.cx10c_c8r32	26.881	69.847	3.272		0.016
pg180_o2nofp.cx10d_c8r32	26.906	69.389	3.706		0.015
pg181_o2nofp.cx10b_c8r32	23.042	73.225	3.728	0.006	0.026

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
1000	8450	0	0.0	44.8	3.6	0.000	0.000	0.045	3.643	33167	12.0	3.925	114	8.2	31.7	0.3	0.002	8447	8367	pg1222_o2nofp.cx10a_c8r32
1000	8458	0	0.0	44.9	3.6	0.000	0.000	0.045	3.645	33202	12.2	3.925	115	8.2	31.9	0.3	0.002	8463	8383	pg1322_o2nofp.cx10a_c8r32
999	8429	0	0.0	44.9	3.6	0.000	0.000	0.045	3.647	33123	13.3	3.930	126	8.2	31.9	6.5	0.001	8431	8367	pg1323_o2nofp.cx10a_c8r32
1000	8396	0	0.0	44.3	3.5	0.000	0.000	0.044	3.595	32874	12.3	3.915	117	8.1	31.5	0.3	0.002	8399	8335	pg1419_o2nofp.cx10a_c8r32
1000	8379	0	0.0	44.6	3.5	0.000	0.000	0.045	3.613	32812	13.2	3.916	126	8.0	31.4	0.3	0.001	8383	8303	pg1420_o2nofp.cx10a_c8r32
1000	8488	0	0.0	42.1	3.5	0.000	0.000	0.042	3.569	33177	12.0	3.909	113	8.1	31.5	2.5	0.002	8479	8399	pg1514_o2nofp.cx10a_c8r32
999	8424	0	0.0	42.5	3.5	0.000	0.000	0.042	3.589	32951	13.2	3.912	125	8.0	31.8	0.3	0.002	8431	8319	pg1515_o2nofp.cx10a_c8r32
999	8444	0	0.0	42.6	3.5	0.000	0.000	0.043	3.607	33029	12.2	3.912	116	8.1	31.4	3.6	0.002	8447	8367	pg1610_o2nofp.cx10a_c8r32
1000	8430	0	0.0	42.8	3.5	0.000	0.000	0.043	3.617	32957	13.2	3.910	125	8.1	31.9	3.2	0.001	8431	8351	pg1611_o2nofp.cx10a_c8r32
999	8332	0	0.0	41.3	3.5	0.000	0.000	0.041	3.606	32523	12.2	3.903	117	8.1	31.5	0.3	0.028	8335	8271	pg176_o2nofp.cx10a_c8r32
999	8393	0	0.0	40.8	3.5	0.000	0.000	0.041	3.582	32757	13.3	3.903	127	8.0	31.7	0.3	0.002	8399	8319	pg177_o2nofp.cx10a_c8r32
1000	8340	0	0.0	41.4	3.5	0.000	0.000	0.041	3.625	32534	12.3	3.901	118	8.0	31.4	7.8	0.002	8335	8255	pg180_o2nofp.cx10b_c8r32
1000	8306	0	0.0	41.1	3.5	0.000	0.000	0.041	3.602	32425	12.2	3.904	118	8.0	31.3	6.9	0.001	8303	8191	pg180_o2nofp.cx10c_c8r32
1000	8389	0	0.0	41.5	3.5	0.000	0.000	0.041	3.619	32721	12.3	3.900	117	8.0	31.2	0.2	0.002	8383	8303	pg180_o2nofp.cx10d_c8r32
1000	8340	0	0.0	41.4	3.5	0.000	0.000	0.041	3.629	32538	13.2	3.901	127	8.0	31.5	0.2	0.002	8335	8255	pg181_o2nofp.cx10b_c8r32

Average values from iostat.

r/s	rkB/s	rrqm/s	%rrqm	r_await	rareq-s	w/s	wkB/s	wrqm/s	%wrqm	w_await	wareq-s	d/s	dkB/s	drqm/s	%drqm	d_await	dareq-s	f/s	f_await	aqu-sz	%util	
0.000	0.000	0.000	0.000	0.000	0.000	44.51	3608.0	3.589	7.217	1.638	79.15	2.110	1652.7	0.000	0.000	0.812	45.46	4.089	1.821	0.066	2.732		pg1222_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	44.67	3611.0	4.232	8.544	1.461	78.89	2.110	1643.5	0.000	0.000	0.811	45.18	4.109	1.329	0.059	2.493		pg1322_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	44.55	3607.2	3.975	8.183	1.499	78.82	2.111	1643.5	0.000	0.000	0.833	80.62	4.098	1.632	0.062	2.609		pg1323_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	44.00	3556.8	3.542	7.121	1.635	78.69	2.111	1634.8	0.000	0.000	0.834	45.20	4.100	1.278	0.062	2.625		pg1419_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	44.28	3574.7	3.548	7.227	1.690	78.92	2.106	1634.8	0.000	0.000	0.868	84.24	4.087	1.518	0.068	2.718		pg1420_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	41.74	3530.9	1.686	2.508	1.869	83.14	0.111	1624.8	0.000	0.000	0.004	41.48	4.099	1.269	0.065	2.605		pg1514_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	42.15	3549.8	1.882	3.039	1.847	83.13	0.111	1624.8	0.000	0.000	0.002	40.83	4.096	1.344	0.065	2.577		pg1515_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	42.27	3566.1	1.848	3.052	1.861	82.91	0.110	1633.9	0.000	0.000	0.004	83.18	4.082	1.257	0.065	2.616		pg1610_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	42.53	3578.9	1.944	3.183	1.803	82.84	0.106	1633.9	0.000	0.000	0.001	43.24	4.111	1.339	0.064	2.532		pg1611_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	40.94	3566.4	1.829	3.081	1.988	86.94	0.108	1638.1	0.000	0.000	0.006	53.21	3.416	1.285	0.067	2.385		pg176_o2nofp.cx10a_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	40.47	3542.4	1.758	2.836	2.011	86.88	0.109	1624.8	0.000	0.000	0.004	41.89	3.398	1.312	0.068	2.372		pg177_o2nofp.cx10a_c8r32
0.001	0.004	0.000	0.000	0.001	0.011	41.06	3582.9	1.647	2.562	2.044	86.52	0.105	1633.9	0.000	0.000	0.005	43.47	3.257	1.821	0.072	2.537		pg180_o2nofp.cx10b_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	40.67	3556.0	1.608	2.528	2.122	85.66	0.109	1643.0	0.000	0.000	0.002	83.16	3.135	1.810	0.070	2.552		pg180_o2nofp.cx10c_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	41.07	3572.5	1.635	2.502	2.090	85.74	0.108	1643.0	0.000	0.000	0.004	85.42	3.157	1.827	0.068	2.504		pg180_o2nofp.cx10d_c8r32
0.000	0.000	0.000	0.000	0.000	0.000	41.03	3584.8	1.742	2.849	1.941	85.94	0.108	1643.0	0.000	0.000	0.005	79.06	3.240	1.324	0.068	2.276		pg181_o2nofp.cx10b_c8r32

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
141509	0	0	0.0	528.4	59.7	0.000	0.000	0.004	0.432	17571	19.8	0.124	11	2.9	7.8	2.9	0.004	142082	140981	pg1222_o2nofp.cx10a_c8r32
144231	0	0	0.0	541.1	61.2	0.000	0.000	0.004	0.435	18248	20.6	0.127	11	2.9	7.8	0.8	0.002	144684	143979	pg1322_o2nofp.cx10a_c8r32
143541	0	0	0.0	538.8	60.9	0.000	0.000	0.004	0.435	18282	20.7	0.127	12	2.9	7.8	2.9	0.003	144082	143180	pg1323_o2nofp.cx10a_c8r32
140187	0	0	0.0	524.5	59.3	0.000	0.000	0.004	0.433	16989	19.6	0.121	11	2.9	7.8	0.4	0.002	140482	139582	pg1419_o2nofp.cx10a_c8r32
138889	0	0	0.0	516.6	58.4	0.000	0.000	0.004	0.431	16838	19.5	0.121	11	2.9	7.8	2.8	0.003	138883	138082	pg1420_o2nofp.cx10a_c8r32
144231	0	0	0.0	536.7	61.0	0.000	0.000	0.004	0.433	17736	20.4	0.123	11	2.9	7.8	2.9	0.006	144284	142884	pg1514_o2nofp.cx10a_c8r32
144928	0	0	0.0	540.0	61.4	0.000	0.000	0.004	0.433	17854	20.6	0.123	11	2.9	7.8	3.0	0.005	145384	144482	pg1515_o2nofp.cx10a_c8r32
142180	0	0	0.0	529.6	60.1	0.000	0.000	0.004	0.433	17195	19.7	0.121	11	2.9	7.8	2.9	0.002	142881	142274	pg1610_o2nofp.cx10a_c8r32
144231	0	0	0.0	537.5	61.0	0.000	0.000	0.004	0.433	17739	20.3	0.123	11	2.9	7.8	2.9	0.008	144580	143081	pg1611_o2nofp.cx10a_c8r32
142857	0	0	0.0	533.6	60.7	0.000	0.000	0.004	0.435	15427	20.3	0.108	11	2.9	7.8	2.1	0.002	143682	142783	pg176_o2nofp.cx10a_c8r32
141509	0	0	0.0	528.8	60.0	0.000	0.000	0.004	0.434	14737	20.0	0.104	11	2.9	7.8	2.9	0.003	142482	141582	pg177_o2nofp.cx10a_c8r32
141509	0	0	0.0	524.9	59.7	0.000	0.000	0.004	0.432	14972	19.9	0.106	11	2.9	7.8	2.9	0.002	141587	140783	pg180_o2nofp.cx10b_c8r32
142180	0	0	0.0	529.7	60.2	0.000	0.000	0.004	0.433	14931	19.9	0.105	11	2.9	7.8	2.9	0.003	143180	142281	pg180_o2nofp.cx10c_c8r32
142180	0	0	0.0	528.1	59.9	0.000	0.000	0.004	0.432	14826	19.8	0.104	11	2.9	7.8	2.9	0.002	142281	141284	pg180_o2nofp.cx10d_c8r32
142180	0	0	0.0	528.2	59.9	0.000	0.000	0.004	0.432	14723	20.0	0.104	11	2.9	7.8	2.9	0.002	142283	141280	pg181_o2nofp.cx10b_c8r32

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
340910	0	0	0.0	640.4	78.4	0.000	0.000	0.002	0.235	1894	12.1	0.006	3	5.8	13.3	3.0	0.002	NA	NA	pg1222_o2nofp.cx10a_c8r32
337080	0	0	0.0	623.6	76.3	0.000	0.000	0.002	0.232	1836	12.0	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg1322_o2nofp.cx10a_c8r32
333334	0	0	0.0	622.5	76.2	0.000	0.000	0.002	0.234	1775	12.2	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg1323_o2nofp.cx10a_c8r32
329671	0	0	0.0	674.4	82.5	0.000	0.000	0.002	0.256	2016	12.2	0.006	3	5.8	13.3	3.0	0.002	NA	NA	pg1419_o2nofp.cx10a_c8r32
322582	0	0	0.0	651.4	79.6	0.000	0.000	0.002	0.253	1921	12.2	0.006	3	5.8	13.3	3.0	0.002	NA	NA	pg1420_o2nofp.cx10a_c8r32
357144	0	0	0.0	670.3	82.3	0.000	0.000	0.002	0.236	1897	12.1	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg1514_o2nofp.cx10a_c8r32
361447	0	0	0.0	696.3	85.5	0.000	0.000	0.002	0.242	1989	12.1	0.006	3	5.8	13.3	3.0	0.002	NA	NA	pg1515_o2nofp.cx10a_c8r32
357144	0	0	0.0	665.5	81.7	0.000	0.000	0.002	0.234	1876	12.1	0.005	3	5.8	13.3	3.1	0.002	NA	NA	pg1610_o2nofp.cx10a_c8r32
370372	0	0	0.0	747.1	91.6	0.000	0.000	0.002	0.253	2238	12.1	0.006	3	5.8	13.3	3.1	0.002	NA	NA	pg1611_o2nofp.cx10a_c8r32
375001	0	0	0.0	690.2	84.8	0.000	0.000	0.002	0.232	1910	12.3	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg176_o2nofp.cx10a_c8r32
379748	0	0	0.0	645.5	79.1	0.000	0.000	0.002	0.213	1947	12.3	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg177_o2nofp.cx10a_c8r32
375001	0	0	0.0	588.2	72.0	0.000	0.000	0.002	0.197	1909	12.1	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg180_o2nofp.cx10b_c8r32
379748	0	0	0.0	598.1	73.2	0.000	0.000	0.002	0.197	1927	12.1	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg180_o2nofp.cx10c_c8r32
379748	0	0	0.0	605.8	74.1	0.000	0.000	0.002	0.200	1965	12.1	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg180_o2nofp.cx10d_c8r32
357144	0	0	0.0	676.4	83.0	0.000	0.000	0.002	0.238	1840	12.5	0.005	3	5.8	13.3	3.0	0.002	NA	NA	pg181_o2nofp.cx10b_c8r32

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
20418	0	0	0.0	251.9	27.2	0.000	0.000	0.012	1.363	10562	21.8	0.517	85	8.1	38.5	6.4	0.029	14498	8499	pg1222_o2nofp.cx10a_c8r32
20964	0	0	0.0	259.4	28.0	0.000	0.000	0.012	1.366	10856	22.2	0.518	85	8.1	38.5	5.5	0.034	15298	10299	pg1322_o2nofp.cx10a_c8r32
20439	0	0	0.0	253.4	27.3	0.000	0.000	0.012	1.369	10637	22.2	0.520	87	8.1	38.6	6.4	0.035	14848	9949	pg1323_o2nofp.cx10a_c8r32
19782	0	0	0.0	245.2	26.4	0.000	0.000	0.012	1.365	9846	20.5	0.498	83	7.9	38.4	6.8	0.031	14148	8299	pg1419_o2nofp.cx10a_c8r32
20070	0	0	0.0	247.7	26.7	0.000	0.000	0.012	1.360	9966	20.9	0.497	83	7.8	38.3	2.8	0.013	14398	9649	pg1420_o2nofp.cx10a_c8r32
20202	0	0	0.0	246.3	26.7	0.000	0.000	0.012	1.354	10451	20.7	0.517	82	7.8	38.2	3.8	0.037	15148	8599	pg1514_o2nofp.cx10a_c8r32
20964	0	0	0.0	256.7	27.9	0.000	0.000	0.012	1.364	10860	20.8	0.518	79	7.8	38.4	7.6	0.040	17047	11848	pg1515_o2nofp.cx10a_c8r32
19484	0	0	0.0	239.1	25.9	0.000	0.000	0.012	1.360	10110	20.4	0.519	84	7.8	38.4	7.3	0.023	13998	8049	pg1610_o2nofp.cx10a_c8r32
20682	0	0	0.0	253.2	27.5	0.000	0.000	0.012	1.362	10719	20.7	0.518	80	7.8	38.4	3.7	0.031	16847	11548	pg1611_o2nofp.cx10a_c8r32
18010	0	0	0.0	224.0	24.6	0.000	0.000	0.012	1.399	7665	19.6	0.426	87	7.8	38.5	3.0	0.025	12698	6349	pg176_o2nofp.cx10a_c8r32
18683	0	0	0.0	233.6	25.6	0.000	0.000	0.013	1.402	7927	19.7	0.424	84	7.8	38.3	3.6	0.026	15848	6199	pg177_o2nofp.cx10a_c8r32
19157	0	0	0.0	240.4	26.5	0.000	0.000	0.013	1.414	8112	20.3	0.423	85	7.8	38.3	2.7	0.032	13648	7899	pg180_o2nofp.cx10b_c8r32
18930	0	0	0.0	233.6	25.6	0.000	0.000	0.012	1.385	8168	20.1	0.431	85	7.8	38.2	3.0	0.025	13748	6399	pg180_o2nofp.cx10c_c8r32
19222	0	0	0.0	238.1	26.1	0.000	0.000	0.012	1.391	8215	20.0	0.427	83	7.8	38.3	3.0	0.032	14798	6599	pg180_o2nofp.cx10d_c8r32
20471	0	0	0.0	256.5	28.2	0.000	0.000	0.013	1.411	8670	20.8	0.424	81	7.8	38.2	4.3	0.025	16398	11698	pg181_o2nofp.cx10b_c8r32

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
2572	0	0	0.0	61.4	5.8	0.000	0.000	0.024	2.290	12490	15.4	4.856	479	8.1	40.2	6.6	0.036	1760	1020	pg1222_o2nofp.cx10a_c8r32
2642	0	0	0.0	62.2	5.9	0.000	0.000	0.024	2.284	12859	15.5	4.867	469	8.1	40.3	5.2	0.010	1980	1435	pg1322_o2nofp.cx10a_c8r32
2634	0	0	0.0	62.6	5.9	0.000	0.000	0.024	2.300	12828	15.5	4.870	471	8.2	40.3	4.7	0.007	1930	1310	pg1323_o2nofp.cx10a_c8r32
2511	0	0	0.0	58.7	5.5	0.000	0.000	0.023	2.236	11767	15.1	4.687	481	7.9	39.8	7.4	0.004	1965	1310	pg1419_o2nofp.cx10a_c8r32
2372	0	0	0.0	57.0	5.3	0.000	0.000	0.024	2.288	11134	15.0	4.694	506	7.9	39.7	0.9	0.009	1755	1130	pg1420_o2nofp.cx10a_c8r32
2384	0	0	0.0	55.8	5.4	0.000	0.000	0.023	2.309	11125	15.0	4.667	503	7.9	39.8	7.7	0.009	1625	985	pg1514_o2nofp.cx10a_c8r32
2525	0	0	0.0	58.0	5.6	0.000	0.000	0.023	2.271	11780	15.1	4.666	478	7.9	40.2	0.3	0.007	1940	1330	pg1515_o2nofp.cx10a_c8r32
2431	0	0	0.0	55.6	5.4	0.000	0.000	0.023	2.260	11319	15.1	4.657	497	7.9	39.7	0.3	0.002	1775	1230	pg1610_o2nofp.cx10a_c8r32
2627	0	0	0.0	58.9	5.7	0.000	0.000	0.022	2.230	12247	15.3	4.663	466	7.9	40.2	5.3	0.003	2145	1335	pg1611_o2nofp.cx10a_c8r32
2244	0	0	0.0	53.1	5.1	0.000	0.000	0.024	2.345	8822	14.8	3.932	528	7.9	39.9	7.3	0.002	1580	890	pg176_o2nofp.cx10a_c8r32
2172	0	0	0.0	52.3	5.1	0.000	0.000	0.024	2.385	8565	14.7	3.943	541	7.9	39.9	0.6	0.009	1355	710	pg177_o2nofp.cx10a_c8r32
2369	0	0	0.0	53.7	5.3	0.000	0.000	0.023	2.285	9294	15.0	3.923	507	7.9	39.7	7.0	0.023	1855	1305	pg180_o2nofp.cx10b_c8r32
2220	0	0	0.0	53.2	5.1	0.000	0.000	0.024	2.357	8769	14.9	3.950	537	7.9	39.6	0.4	0.026	1535	1030	pg180_o2nofp.cx10c_c8r32
2320	0	0	0.0	53.5	5.2	0.000	0.000	0.023	2.299	9117	14.9	3.929	514	7.9	39.6	7.0	0.030	1610	995	pg180_o2nofp.cx10d_c8r32
2432	0	0	0.0	55.1	5.4	0.000	0.000	0.023	2.277	9546	15.1	3.925	497	7.9	39.8	0.4	0.009	1970	1355	pg181_o2nofp.cx10b_c8r32

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
100	14702	0	0.0	14.9	0.8	0.000	0.000	0.149	7.746	56201	11.3	3.823	61	8.1	40.2	0.1	0.001	14686	14542	pg1222_o2nofp.cx10a_c8r32
100	14818	0	0.0	14.9	0.8	0.000	0.000	0.149	7.743	56648	11.3	3.823	61	8.1	40.3	0.1	0.001	14814	14638	pg1322_o2nofp.cx10a_c8r32
100	14977	0	0.0	15.0	0.8	0.000	0.000	0.150	7.781	57258	12.5	3.823	67	8.2	40.3	0.1	0.001	14974	14782	pg1323_o2nofp.cx10a_c8r32
100	14855	0	0.0	15.3	0.8	0.000	0.000	0.153	7.889	56786	11.1	3.823	60	7.9	39.8	0.1	0.010	14878	14686	pg1419_o2nofp.cx10a_c8r32
100	14884	0	0.0	15.4	0.8	0.000	0.000	0.154	7.928	56892	12.4	3.822	67	7.9	39.7	0.1	0.010	14894	14686	pg1420_o2nofp.cx10a_c8r32
100	15045	0	0.0	13.2	0.8	0.000	0.000	0.132	7.708	57481	11.1	3.821	59	7.9	39.8	0.1	0.001	15054	14830	pg1514_o2nofp.cx10a_c8r32
100	14897	0	0.0	13.1	0.8	0.000	0.000	0.131	7.715	56891	12.4	3.819	67	7.9	40.1	0.1	0.001	14894	14686	pg1515_o2nofp.cx10a_c8r32
100	14971	0	0.0	13.3	0.8	0.000	0.000	0.133	7.719	57200	11.0	3.821	59	7.9	39.7	0.1	0.001	14975	14798	pg1610_o2nofp.cx10a_c8r32
100	14912	0	0.0	13.1	0.8	0.000	0.000	0.131	7.708	56978	12.4	3.821	67	7.9	40.2	0.1	0.001	14926	14686	pg1611_o2nofp.cx10a_c8r32
100	15080	0	0.0	12.4	0.8	0.000	0.000	0.124	7.731	57601	11.2	3.820	59	7.9	39.9	0.1	0.001	15070	14910	pg176_o2nofp.cx10a_c8r32
100	15118	0	0.0	12.4	0.8	0.000	0.000	0.124	7.750	57721	12.4	3.818	66	7.9	39.9	0.1	0.001	15118	14894	pg177_o2nofp.cx10a_c8r32
100	14902	0	0.0	12.3	0.8	0.000	0.000	0.123	7.710	56893	11.1	3.818	60	7.9	39.7	0.1	0.002	14894	14702	pg180_o2nofp.cx10b_c8r32
100	14824	0	0.0	12.4	0.8	0.000	0.000	0.124	7.740	56625	11.4	3.820	62	7.9	39.6	0.1	0.003	14830	14638	pg180_o2nofp.cx10c_c8r32
100	14874	0	0.0	12.4	0.8	0.000	0.000	0.124	7.743	56784	11.3	3.818	61	7.9	39.6	0.1	0.002	14878	14686	pg180_o2nofp.cx10d_c8r32
100	14736	0	0.0	12.4	0.8	0.000	0.000	0.124	7.737	56290	12.4	3.820	67	7.9	39.8	0.1	0.001	14750	14510	pg181_o2nofp.cx10b_c8r32

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
100	8524	0	0.0	63.4	1.7	0.000	0.000	0.634	17.041	33064	11.1	3.879	104	8.1	40.2	0.2	0.002	8527	8463	pg1222_o2nofp.cx10a_c8r32
100	8515	0	0.0	63.2	1.7	0.000	0.000	0.632	17.057	33031	11.3	3.879	106	8.1	40.3	0.2	0.001	8511	8463	pg1322_o2nofp.cx10a_c8r32
100	8504	0	0.0	63.2	1.7	0.000	0.000	0.633	17.068	33023	12.4	3.883	117	8.2	40.3	0.2	0.001	8511	8431	pg1323_o2nofp.cx10a_c8r32
100	8392	0	0.0	62.3	1.7	0.000	0.000	0.624	17.008	32502	11.5	3.873	110	7.9	39.8	0.1	0.002	8399	8351	pg1419_o2nofp.cx10a_c8r32
100	8429	0	0.0	62.3	1.7	0.000	0.000	0.624	17.016	32642	12.4	3.873	118	7.9	39.7	0.1	0.001	8431	8383	pg1420_o2nofp.cx10a_c8r32
100	8493	0	0.0	60.0	1.6	0.000	0.000	0.600	16.803	32852	11.5	3.868	108	7.9	39.8	0.2	0.002	8495	8447	pg1514_o2nofp.cx10a_c8r32
100	8467	0	0.0	60.0	1.6	0.000	0.000	0.600	16.798	32735	12.4	3.866	117	7.9	40.1	0.1	0.001	8463	8399	pg1515_o2nofp.cx10a_c8r32
100	8545	0	0.0	60.1	1.6	0.000	0.000	0.601	16.776	33051	11.3	3.868	106	7.9	39.7	0.1	0.001	8543	8495	pg1610_o2nofp.cx10a_c8r32
100	8521	0	0.0	60.0	1.6	0.000	0.000	0.600	16.813	32961	12.4	3.868	116	7.9	40.2	0.1	0.001	8527	8447	pg1611_o2nofp.cx10a_c8r32
100	8405	0	0.0	58.8	1.6	0.000	0.000	0.588	16.820	32497	11.5	3.866	109	7.9	39.9	0.1	0.001	8415	8367	pg176_o2nofp.cx10a_c8r32
100	8465	0	0.0	58.7	1.6	0.000	0.000	0.587	16.771	32714	12.4	3.865	117	7.9	39.9	0.1	0.001	8479	8383	pg177_o2nofp.cx10a_c8r32
100	8378	0	0.0	59.0	1.6	0.000	0.000	0.590	16.838	32381	11.5	3.865	110	7.9	39.7	0.1	0.004	8383	8319	pg180_o2nofp.cx10b_c8r32
100	8360	0	0.0	58.9	1.6	0.000	0.000	0.590	16.858	32325	11.5	3.867	110	7.9	39.6	0.1	0.002	8367	8303	pg180_o2nofp.cx10c_c8r32
100	8422	0	0.0	58.8	1.6	0.000	0.000	0.589	16.818	32560	11.5	3.866	109	7.9	39.6	0.1	0.002	8431	8367	pg180_o2nofp.cx10d_c8r32
100	8391	0	0.0	58.9	1.6	0.000	0.000	0.589	16.771	32428	12.4	3.865	118	7.9	39.8	0.1	0.001	8383	8335	pg181_o2nofp.cx10b_c8r32

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
500	13901	0	0.0	71.0	2.2	0.000	0.000	0.142	4.599	53379	11.1	3.840	64	8.2	39.0	0.4	0.002	13902	13342	pg1222_o2nofp.cx10a_c8r32
500	13899	0	0.0	70.6	2.2	0.000	0.000	0.141	4.589	53371	11.2	3.840	64	8.2	39.2	0.4	0.002	13902	13342	pg1322_o2nofp.cx10a_c8r32
500	14082	0	0.0	70.5	2.2	0.000	0.000	0.141	4.606	54114	13.0	3.843	74	8.2	39.1	0.4	0.002	14078	13486	pg1323_o2nofp.cx10a_c8r32
500	13949	0	0.0	70.4	2.3	0.000	0.000	0.141	4.707	53522	11.3	3.837	65	8.0	38.8	0.4	0.002	13950	13406	pg1419_o2nofp.cx10a_c8r32
500	13950	0	0.0	69.8	2.3	0.000	0.000	0.140	4.631	53509	13.0	3.836	75	7.9	38.5	0.3	0.002	13950	13406	pg1420_o2nofp.cx10a_c8r32
500	14136	0	0.0	68.1	2.3	0.000	0.000	0.136	4.665	54184	11.3	3.833	64	8.0	38.7	0.4	0.002	14158	13599	pg1514_o2nofp.cx10a_c8r32
500	13905	0	0.0	67.8	2.3	0.000	0.000	0.136	4.625	53275	12.9	3.831	74	8.0	39.0	0.3	0.003	13902	13326	pg1515_o2nofp.cx10a_c8r32
500	14172	0	0.0	67.9	2.2	0.000	0.000	0.136	4.589	54312	11.2	3.832	63	7.9	38.6	3.6	0.003	14174	13646	pg1610_o2nofp.cx10a_c8r32
500	14133	0	0.0	67.8	2.3	0.000	0.000	0.136	4.631	54175	13.0	3.833	74	8.0	39.1	4.0	0.004	14126	13566	pg1611_o2nofp.cx10a_c8r32
500	13821	0	0.0	67.3	2.3	0.000	0.000	0.135	4.655	52938	11.4	3.830	66	8.0	38.7	0.4	0.003	13838	13198	pg176_o2nofp.cx10a_c8r32
500	13946	0	0.0	67.4	2.3	0.000	0.000	0.135	4.642	53419	12.9	3.830	74	7.9	38.8	0.3	0.007	13950	13326	pg177_o2nofp.cx10a_c8r32
500	13898	0	0.0	67.6	2.3	0.000	0.000	0.135	4.652	53209	11.3	3.828	65	8.0	38.6	0.3	0.003	13902	13198	pg180_o2nofp.cx10b_c8r32
500	13861	0	0.0	67.5	2.3	0.000	0.000	0.135	4.689	53093	11.4	3.831	66	8.0	38.6	0.4	0.002	13854	13230	pg180_o2nofp.cx10c_c8r32
500	13810	0	0.0	67.2	2.2	0.000	0.000	0.134	4.590	52921	11.4	3.832	66	7.9	38.4	0.3	0.003	13822	13166	pg180_o2nofp.cx10d_c8r32
500	13609	0	0.0	67.2	2.2	0.000	0.000	0.134	4.584	52099	12.8	3.828	75	7.9	38.6	0.3	0.003	13598	12990	pg181_o2nofp.cx10b_c8r32

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
500	8516	0	0.0	45.8	3.0	0.000	0.000	0.092	6.141	33186	11.6	3.897	109	8.2	36.9	0.3	0.002	8511	8431	pg1222_o2nofp.cx10a_c8r32
500	8454	0	0.0	45.9	3.0	0.000	0.000	0.092	6.128	32946	11.6	3.897	110	8.2	37.0	0.3	0.002	8463	8367	pg1322_o2nofp.cx10a_c8r32
500	8453	0	0.0	45.9	3.0	0.000	0.000	0.092	6.152	32978	12.6	3.902	119	8.2	37.0	0.3	0.002	8463	8399	pg1323_o2nofp.cx10a_c8r32
500	8397	0	0.0	45.4	3.0	0.000	0.000	0.091	6.129	32673	11.6	3.891	111	8.0	36.6	0.3	0.004	8399	8335	pg1419_o2nofp.cx10a_c8r32
500	8382	0	0.0	45.3	3.0	0.000	0.000	0.091	6.089	32590	12.6	3.888	120	7.9	36.4	0.3	0.002	8383	8319	pg1420_o2nofp.cx10a_c8r32
500	8459	0	0.0	43.2	3.0	0.000	0.000	0.087	6.082	32859	11.6	3.884	110	8.0	36.6	0.3	0.002	8463	8383	pg1514_o2nofp.cx10a_c8r32
500	8483	0	0.0	43.2	3.0	0.000	0.000	0.087	6.087	32956	12.6	3.885	119	8.0	36.9	0.3	0.002	8495	8399	pg1515_o2nofp.cx10a_c8r32
500	8433	0	0.0	43.2	3.0	0.000	0.000	0.087	6.056	32760	11.6	3.885	110	7.9	36.5	1.7	0.002	8431	8351	pg1610_o2nofp.cx10a_c8r32
500	8482	0	0.0	43.1	3.0	0.000	0.000	0.086	6.085	32949	12.6	3.885	119	8.0	37.0	1.7	0.002	8495	8399	pg1611_o2nofp.cx10a_c8r32
500	8361	0	0.0	42.0	3.0	0.000	0.000	0.084	6.085	32447	11.6	3.881	111	8.0	36.6	0.3	0.002	8367	8271	pg176_o2nofp.cx10a_c8r32
500	8413	0	0.0	41.9	3.0	0.000	0.000	0.084	6.079	32645	12.7	3.880	121	8.0	36.7	0.3	0.002	8415	8335	pg177_o2nofp.cx10a_c8r32
500	8349	0	0.0	41.9	3.0	0.000	0.000	0.084	6.066	32380	11.6	3.878	111	8.0	36.5	0.2	0.002	8351	8239	pg180_o2nofp.cx10b_c8r32
500	8359	0	0.0	41.6	2.9	0.000	0.000	0.083	6.033	32423	11.6	3.879	111	8.0	36.5	0.2	0.006	8367	8271	pg180_o2nofp.cx10c_c8r32
500	8373	0	0.0	41.5	2.9	0.000	0.000	0.083	6.033	32497	11.6	3.881	111	7.9	36.3	0.2	0.002	8383	8287	pg180_o2nofp.cx10d_c8r32
500	8369	0	0.0	41.8	3.0	0.000	0.000	0.084	6.062	32462	12.6	3.879	120	7.9	36.5	0.2	0.002	8367	8271	pg181_o2nofp.cx10b_c8r32

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
1000	13893	0	0.0	54.9	3.5	0.000	0.000	0.055	3.549	53604	11.8	3.858	68	8.2	34.5	0.4	0.006	13855	13038	pg1222_o2nofp.cx10a_c8r32
1000	13861	0	0.0	54.6	3.5	0.000	0.000	0.055	3.546	53486	11.9	3.859	69	8.2	34.7	0.4	0.006	13822	12974	pg1322_o2nofp.cx10a_c8r32
999	14007	0	0.0	54.7	3.5	0.000	0.000	0.055	3.551	54094	13.5	3.862	77	8.2	34.6	0.4	0.005	13966	13118	pg1323_o2nofp.cx10a_c8r32
1000	13946	0	0.0	54.1	3.4	0.000	0.000	0.054	3.518	53708	11.7	3.851	67	8.1	34.3	0.4	0.006	13902	13118	pg1419_o2nofp.cx10a_c8r32
1000	13942	0	0.0	53.7	3.4	0.000	0.000	0.054	3.497	53693	13.4	3.851	77	8.0	34.1	0.3	0.005	13918	13086	pg1420_o2nofp.cx10a_c8r32
999	14100	0	0.0	51.9	3.4	0.000	0.000	0.052	3.506	54274	11.7	3.849	66	8.0	34.3	0.1	0.005	14046	13246	pg1514_o2nofp.cx10a_c8r32
999	14006	0	0.0	51.5	3.4	0.000	0.000	0.052	3.490	53921	13.4	3.850	77	8.0	34.6	0.4	0.005	13982	13134	pg1515_o2nofp.cx10a_c8r32
999	14239	0	0.0	51.8	3.4	0.000	0.000	0.052	3.511	54812	11.6	3.850	65	8.0	34.2	6.5	0.005	14222	13359	pg1610_o2nofp.cx10a_c8r32
1000	13998	0	0.0	51.7	3.4	0.000	0.000	0.052	3.486	53856	13.5	3.847	77	8.0	34.6	3.2	0.005	13966	13118	pg1611_o2nofp.cx10a_c8r32
999	13880	0	0.0	51.2	3.4	0.000	0.000	0.051	3.495	53354	12.0	3.844	69	8.0	34.3	0.4	0.005	13838	12878	pg176_o2nofp.cx10a_c8r32
999	13996	0	0.0	51.1	3.4	0.000	0.000	0.051	3.501	53797	13.5	3.844	77	8.0	34.4	0.4	0.005	13950	13006	pg177_o2nofp.cx10a_c8r32
1000	13842	0	0.0	51.9	3.4	0.000	0.000	0.052	3.496	53181	11.7	3.842	68	8.0	34.2	0.3	0.005	13726	12943	pg180_o2nofp.cx10b_c8r32
1000	13774	0	0.0	52.0	3.4	0.000	0.000	0.052	3.487	52928	11.8	3.843	69	8.0	34.1	0.3	0.006	13646	13006	pg180_o2nofp.cx10c_c8r32
1000	13963	0	0.0	52.0	3.4	0.000	0.000	0.052	3.512	53648	11.8	3.842	68	8.0	34.0	0.3	0.013	13838	13166	pg180_o2nofp.cx10d_c8r32
1000	13673	0	0.0	52.2	3.4	0.000	0.000	0.052	3.523	52540	13.4	3.843	78	8.0	34.2	0.3	0.005	13534	12862	pg181_o2nofp.cx10b_c8r32

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
1000	8450	0	0.0	44.8	3.6	0.000	0.000	0.045	3.643	33167	12.0	3.925	114	8.2	31.7	0.3	0.002	8447	8367	pg1222_o2nofp.cx10a_c8r32
1000	8458	0	0.0	44.9	3.6	0.000	0.000	0.045	3.645	33202	12.2	3.925	115	8.2	31.9	0.3	0.002	8463	8383	pg1322_o2nofp.cx10a_c8r32
999	8429	0	0.0	44.9	3.6	0.000	0.000	0.045	3.647	33123	13.3	3.930	126	8.2	31.9	6.5	0.001	8431	8367	pg1323_o2nofp.cx10a_c8r32
1000	8396	0	0.0	44.3	3.5	0.000	0.000	0.044	3.595	32874	12.3	3.915	117	8.1	31.5	0.3	0.002	8399	8335	pg1419_o2nofp.cx10a_c8r32
1000	8379	0	0.0	44.6	3.5	0.000	0.000	0.045	3.613	32812	13.2	3.916	126	8.0	31.4	0.3	0.001	8383	8303	pg1420_o2nofp.cx10a_c8r32
1000	8488	0	0.0	42.1	3.5	0.000	0.000	0.042	3.569	33177	12.0	3.909	113	8.1	31.5	2.5	0.002	8479	8399	pg1514_o2nofp.cx10a_c8r32
999	8424	0	0.0	42.5	3.5	0.000	0.000	0.042	3.589	32951	13.2	3.912	125	8.0	31.8	0.3	0.002	8431	8319	pg1515_o2nofp.cx10a_c8r32
999	8444	0	0.0	42.6	3.5	0.000	0.000	0.043	3.607	33029	12.2	3.912	116	8.1	31.4	3.6	0.002	8447	8367	pg1610_o2nofp.cx10a_c8r32
1000	8430	0	0.0	42.8	3.5	0.000	0.000	0.043	3.617	32957	13.2	3.910	125	8.1	31.9	3.2	0.001	8431	8351	pg1611_o2nofp.cx10a_c8r32
999	8332	0	0.0	41.3	3.5	0.000	0.000	0.041	3.606	32523	12.2	3.903	117	8.1	31.5	0.3	0.028	8335	8271	pg176_o2nofp.cx10a_c8r32
999	8393	0	0.0	40.8	3.5	0.000	0.000	0.041	3.582	32757	13.3	3.903	127	8.0	31.7	0.3	0.002	8399	8319	pg177_o2nofp.cx10a_c8r32
1000	8340	0	0.0	41.4	3.5	0.000	0.000	0.041	3.625	32534	12.3	3.901	118	8.0	31.4	7.8	0.002	8335	8255	pg180_o2nofp.cx10b_c8r32
1000	8306	0	0.0	41.1	3.5	0.000	0.000	0.041	3.602	32425	12.2	3.904	118	8.0	31.3	6.9	0.001	8303	8191	pg180_o2nofp.cx10c_c8r32
1000	8389	0	0.0	41.5	3.5	0.000	0.000	0.041	3.619	32721	12.3	3.900	117	8.0	31.2	0.2	0.002	8383	8303	pg180_o2nofp.cx10d_c8r32
1000	8340	0	0.0	41.4	3.5	0.000	0.000	0.041	3.629	32538	13.2	3.901	127	8.0	31.5	0.2	0.002	8335	8255	pg181_o2nofp.cx10b_c8r32

l.i0

l.i0: load without secondary indexes
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	99.979	0.021	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg1222_o2nofp.cx10a_c8r32
0.000	99.970	0.030	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1322_o2nofp.cx10a_c8r32
0.000	99.983	0.017	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg1323_o2nofp.cx10a_c8r32
0.000	99.985	0.015	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1419_o2nofp.cx10a_c8r32
0.000	99.989	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg1420_o2nofp.cx10a_c8r32
0.000	99.985	0.015	0.001	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1514_o2nofp.cx10a_c8r32
0.000	99.985	0.014	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1515_o2nofp.cx10a_c8r32
0.000	99.992	0.008	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1610_o2nofp.cx10a_c8r32
0.000	99.984	0.016	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg1611_o2nofp.cx10a_c8r32
0.000	99.983	0.017	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg176_o2nofp.cx10a_c8r32
0.000	99.981	0.019	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg177_o2nofp.cx10a_c8r32
0.000	99.985	0.015	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg180_o2nofp.cx10b_c8r32
0.000	99.987	0.013	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg180_o2nofp.cx10c_c8r32
0.000	99.983	0.017	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg180_o2nofp.cx10d_c8r32
0.000	99.989	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg181_o2nofp.cx10b_c8r32

l.x

l.x: create secondary indexes
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

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

l.i1

l.i1: continue load after secondary indexes created with 50 inserts per transaction
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	46.971	53.019	0.005	0.005	0.000	0.000	0.000	0.000	0.000	0.029	pg1222_o2nofp.cx10a_c8r32
0.000	39.672	60.319	0.005	0.005	0.000	0.000	0.000	0.000	0.000	0.034	pg1322_o2nofp.cx10a_c8r32
0.000	33.383	66.608	0.004	0.005	0.000	0.000	0.000	0.000	0.000	0.035	pg1323_o2nofp.cx10a_c8r32
0.000	46.699	53.301	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.031	pg1419_o2nofp.cx10a_c8r32
0.000	41.446	58.553	0.001	0.000	0.000	0.000	0.000	0.000	0.000	0.013	pg1420_o2nofp.cx10a_c8r32
0.000	35.050	64.945	0.003	0.002	0.000	0.000	0.000	0.000	0.000	0.037	pg1514_o2nofp.cx10a_c8r32
0.000	32.089	67.897	0.005	0.009	0.000	0.000	0.000	0.000	0.000	0.040	pg1515_o2nofp.cx10a_c8r32
0.000	36.958	63.041	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.023	pg1610_o2nofp.cx10a_c8r32
0.000	31.139	68.849	0.005	0.007	0.000	0.000	0.000	0.000	0.000	0.031	pg1611_o2nofp.cx10a_c8r32
0.000	51.104	48.893	0.002	0.001	0.000	0.000	0.000	0.000	0.000	0.025	pg176_o2nofp.cx10a_c8r32
0.000	51.168	48.828	0.002	0.001	0.000	0.000	0.000	0.000	0.000	0.026	pg177_o2nofp.cx10a_c8r32
0.000	44.125	55.872	0.002	0.001	0.000	0.000	0.000	0.000	0.000	0.032	pg180_o2nofp.cx10b_c8r32
0.000	46.457	53.536	0.005	0.002	0.000	0.000	0.000	0.000	0.000	0.025	pg180_o2nofp.cx10c_c8r32
0.000	49.358	50.640	0.001	0.001	0.000	0.000	0.000	0.000	0.000	0.032	pg180_o2nofp.cx10d_c8r32
0.000	37.144	62.852	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.025	pg181_o2nofp.cx10b_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	24.762	56.847	18.386	0.005	0.000	0.000	0.000	0.000	0.000	0.028	pg1222_o2nofp.cx10a_c8r32
0.000	21.997	68.075	9.924	0.004	0.000	0.000	0.000	0.000	0.000	0.032	pg1322_o2nofp.cx10a_c8r32
0.000	21.750	66.503	11.743	0.004	0.000	0.000	0.000	0.000	0.000	0.035	pg1323_o2nofp.cx10a_c8r32
0.000	21.309	61.402	17.288	0.001	0.000	0.000	0.000	0.000	0.000	0.030	pg1419_o2nofp.cx10a_c8r32
0.000	20.972	65.556	13.471	nonzero	0.000	0.000	0.000	0.000	0.000	0.028	pg1420_o2nofp.cx10a_c8r32
0.000	21.302	67.392	11.304	0.002	0.000	0.000	0.000	0.000	0.000	0.049	pg1514_o2nofp.cx10a_c8r32
0.000	21.351	75.922	2.721	0.006	0.000	0.000	0.000	0.000	0.000	0.039	pg1515_o2nofp.cx10a_c8r32
0.000	19.968	63.317	16.714	0.001	0.000	0.000	0.000	0.000	0.000	0.025	pg1610_o2nofp.cx10a_c8r32
0.000	20.710	75.286	3.999	0.005	0.000	0.000	0.000	0.000	0.000	0.035	pg1611_o2nofp.cx10a_c8r32
0.000	19.372	57.258	23.369	0.001	0.000	0.000	0.000	0.000	0.000	0.025	pg176_o2nofp.cx10a_c8r32
0.000	20.745	63.159	16.095	0.001	0.000	0.000	0.000	0.000	0.000	0.025	pg177_o2nofp.cx10a_c8r32
0.000	19.413	62.238	18.348	0.001	0.000	0.000	0.000	0.000	0.000	0.032	pg180_o2nofp.cx10b_c8r32
0.000	20.176	60.458	19.363	0.002	0.000	0.000	0.000	0.000	0.000	0.040	pg180_o2nofp.cx10c_c8r32
0.000	19.949	62.660	17.389	0.001	0.000	0.000	0.000	0.000	0.000	0.032	pg180_o2nofp.cx10d_c8r32
0.000	20.069	76.096	3.835	0.001	0.000	0.000	0.000	0.000	0.000	0.024	pg181_o2nofp.cx10b_c8r32

l.i2

l.i2: continue load after secondary indexes created with 5 inserts per transaction
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
50.816	49.183	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.036	pg1222_o2nofp.cx10a_c8r32
48.804	51.195	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1322_o2nofp.cx10a_c8r32
50.100	49.900	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg1323_o2nofp.cx10a_c8r32
45.506	54.494	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg1419_o2nofp.cx10a_c8r32
41.043	58.956	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg1420_o2nofp.cx10a_c8r32
47.981	52.018	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg1514_o2nofp.cx10a_c8r32
45.707	54.293	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg1515_o2nofp.cx10a_c8r32
41.996	58.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1610_o2nofp.cx10a_c8r32
49.617	50.383	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg1611_o2nofp.cx10a_c8r32
42.567	57.432	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg176_o2nofp.cx10a_c8r32
52.887	47.112	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg177_o2nofp.cx10a_c8r32
40.509	59.489	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.023	pg180_o2nofp.cx10b_c8r32
44.811	55.189	nonzero	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.026	pg180_o2nofp.cx10c_c8r32
44.983	55.017	nonzero	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.030	pg180_o2nofp.cx10d_c8r32
43.297	56.702	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg181_o2nofp.cx10b_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
1.487	31.014	63.272	4.227	nonzero	0.000	0.000	0.000	0.000	0.000	0.037	pg1222_o2nofp.cx10a_c8r32
0.727	29.569	69.699	0.005	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg1322_o2nofp.cx10a_c8r32
1.169	28.074	70.726	0.031	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg1323_o2nofp.cx10a_c8r32
0.901	21.951	77.133	0.015	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg1419_o2nofp.cx10a_c8r32
1.142	26.188	71.345	1.325	0.000	0.000	0.000	0.000	0.000	0.000	0.013	pg1420_o2nofp.cx10a_c8r32
1.136	27.957	62.997	7.910	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1514_o2nofp.cx10a_c8r32
1.262	26.013	72.712	0.013	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg1515_o2nofp.cx10a_c8r32
0.869	27.805	70.685	0.641	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg1610_o2nofp.cx10a_c8r32
0.894	20.143	78.947	0.017	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg1611_o2nofp.cx10a_c8r32
0.942	26.016	65.412	7.631	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg176_o2nofp.cx10a_c8r32
1.191	28.452	52.467	17.890	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg177_o2nofp.cx10a_c8r32
0.817	23.318	75.783	0.082	nonzero	0.000	0.000	0.000	0.000	0.000	0.023	pg180_o2nofp.cx10b_c8r32
0.752	25.157	63.917	10.173	nonzero	0.000	0.000	0.000	0.000	0.000	0.027	pg180_o2nofp.cx10c_c8r32
0.813	27.998	63.846	7.343	0.000	0.000	0.000	0.000	0.000	0.000	0.013	pg180_o2nofp.cx10d_c8r32
0.768	21.115	78.101	0.016	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg181_o2nofp.cx10b_c8r32

qr100.L1

qr100.L1: range queries with 100 insert/s per client
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
100.000	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1222_o2nofp.cx10a_c8r32
100.000	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1322_o2nofp.cx10a_c8r32
100.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1323_o2nofp.cx10a_c8r32
100.000	nonzero	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1419_o2nofp.cx10a_c8r32
100.000	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1420_o2nofp.cx10a_c8r32
100.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1514_o2nofp.cx10a_c8r32
100.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1515_o2nofp.cx10a_c8r32
100.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1610_o2nofp.cx10a_c8r32
100.000	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1611_o2nofp.cx10a_c8r32
100.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg176_o2nofp.cx10a_c8r32
100.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg177_o2nofp.cx10a_c8r32
100.000	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg180_o2nofp.cx10b_c8r32
100.000	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg180_o2nofp.cx10c_c8r32
100.000	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg180_o2nofp.cx10d_c8r32
100.000	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg181_o2nofp.cx10b_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	99.972	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1222_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1322_o2nofp.cx10a_c8r32
0.000	0.000	99.972	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1323_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1419_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1420_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1514_o2nofp.cx10a_c8r32
0.000	0.028	99.917	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1515_o2nofp.cx10a_c8r32
0.000	0.083	99.861	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1610_o2nofp.cx10a_c8r32
0.000	0.083	99.861	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1611_o2nofp.cx10a_c8r32
0.000	0.028	99.944	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg176_o2nofp.cx10a_c8r32
0.000	0.083	99.861	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg177_o2nofp.cx10a_c8r32
0.000	0.056	99.889	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg180_o2nofp.cx10b_c8r32
0.000	0.056	99.889	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg180_o2nofp.cx10c_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg180_o2nofp.cx10d_c8r32
0.000	0.111	99.833	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg181_o2nofp.cx10b_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	49.806	50.194	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1222_o2nofp.cx10a_c8r32
0.000	46.861	53.139	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1322_o2nofp.cx10a_c8r32
0.000	55.611	44.389	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1323_o2nofp.cx10a_c8r32
0.000	54.750	45.250	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1419_o2nofp.cx10a_c8r32
0.000	60.417	39.583	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1420_o2nofp.cx10a_c8r32
0.000	44.417	55.583	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1514_o2nofp.cx10a_c8r32
0.000	51.694	48.306	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1515_o2nofp.cx10a_c8r32
0.000	59.583	40.417	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1610_o2nofp.cx10a_c8r32
0.000	63.194	36.806	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1611_o2nofp.cx10a_c8r32
0.000	41.972	58.028	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg176_o2nofp.cx10a_c8r32
0.000	49.528	50.472	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg177_o2nofp.cx10a_c8r32
0.000	51.250	48.750	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg180_o2nofp.cx10b_c8r32
0.000	45.722	54.278	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg180_o2nofp.cx10c_c8r32
0.000	40.083	59.917	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg180_o2nofp.cx10d_c8r32
0.000	55.472	44.528	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg181_o2nofp.cx10b_c8r32

qp100.L2

qp100.L2: point queries with 100 insert/s per client
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1222_o2nofp.cx10a_c8r32
99.999	0.001	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1322_o2nofp.cx10a_c8r32
99.999	0.001	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1323_o2nofp.cx10a_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1419_o2nofp.cx10a_c8r32
99.998	0.002	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1420_o2nofp.cx10a_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1514_o2nofp.cx10a_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1515_o2nofp.cx10a_c8r32
99.999	0.001	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1610_o2nofp.cx10a_c8r32
99.999	0.001	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1611_o2nofp.cx10a_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg176_o2nofp.cx10a_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg177_o2nofp.cx10a_c8r32
99.999	0.001	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg180_o2nofp.cx10b_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg180_o2nofp.cx10c_c8r32
99.998	0.002	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg180_o2nofp.cx10d_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg181_o2nofp.cx10b_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1222_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1322_o2nofp.cx10a_c8r32
0.000	0.000	99.972	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1323_o2nofp.cx10a_c8r32
0.000	0.000	99.889	0.111	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1419_o2nofp.cx10a_c8r32
0.000	0.000	99.972	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1420_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1514_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1515_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1610_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1611_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg176_o2nofp.cx10a_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg177_o2nofp.cx10a_c8r32
0.000	0.000	99.833	0.167	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg180_o2nofp.cx10b_c8r32
0.000	0.000	99.778	0.222	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg180_o2nofp.cx10c_c8r32
0.000	0.000	99.944	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg180_o2nofp.cx10d_c8r32
0.000	0.000	99.972	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg181_o2nofp.cx10b_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	1.528	98.444	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1222_o2nofp.cx10a_c8r32
0.000	0.028	99.944	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1322_o2nofp.cx10a_c8r32
0.000	0.389	99.583	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1323_o2nofp.cx10a_c8r32
0.000	0.306	99.639	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg1419_o2nofp.cx10a_c8r32
0.000	4.444	95.528	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1420_o2nofp.cx10a_c8r32
0.000	3.111	96.861	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg1514_o2nofp.cx10a_c8r32
0.000	1.222	98.750	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg1515_o2nofp.cx10a_c8r32
0.000	1.194	98.778	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1610_o2nofp.cx10a_c8r32
0.000	3.250	96.722	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1611_o2nofp.cx10a_c8r32
0.000	0.000	99.972	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg176_o2nofp.cx10a_c8r32
0.000	0.417	99.556	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg177_o2nofp.cx10a_c8r32
0.000	0.083	99.889	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg180_o2nofp.cx10b_c8r32
0.000	0.028	99.944	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg180_o2nofp.cx10c_c8r32
0.000	0.111	99.861	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg180_o2nofp.cx10d_c8r32
0.000	0.556	99.417	0.028	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg181_o2nofp.cx10b_c8r32

qr500.L3

qr500.L3: range queries with 500 insert/s per client
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1222_o2nofp.cx10a_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1322_o2nofp.cx10a_c8r32
100.000	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1323_o2nofp.cx10a_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1419_o2nofp.cx10a_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1420_o2nofp.cx10a_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1514_o2nofp.cx10a_c8r32
99.998	0.002	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg1515_o2nofp.cx10a_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg1610_o2nofp.cx10a_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg1611_o2nofp.cx10a_c8r32
99.998	0.002	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg176_o2nofp.cx10a_c8r32
100.000	nonzero	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg177_o2nofp.cx10a_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg180_o2nofp.cx10b_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg180_o2nofp.cx10c_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg180_o2nofp.cx10d_c8r32
99.999	0.001	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.003	pg181_o2nofp.cx10b_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	22.633	77.328	0.039	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1222_o2nofp.cx10a_c8r32
0.000	19.439	80.517	0.044	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg1322_o2nofp.cx10a_c8r32
0.000	24.278	75.672	0.050	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg1323_o2nofp.cx10a_c8r32
0.000	20.117	79.650	0.233	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1419_o2nofp.cx10a_c8r32
0.000	27.833	72.133	0.033	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg1420_o2nofp.cx10a_c8r32
0.000	17.572	82.150	0.278	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1514_o2nofp.cx10a_c8r32
0.000	24.922	74.956	0.122	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1515_o2nofp.cx10a_c8r32
0.000	29.633	70.317	0.050	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1610_o2nofp.cx10a_c8r32
0.000	25.756	74.072	0.172	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1611_o2nofp.cx10a_c8r32
0.000	21.867	77.828	0.306	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg176_o2nofp.cx10a_c8r32
0.000	18.283	81.461	0.256	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg177_o2nofp.cx10a_c8r32
0.000	23.406	76.328	0.267	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg180_o2nofp.cx10b_c8r32
0.000	21.683	77.922	0.394	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg180_o2nofp.cx10c_c8r32
0.000	21.861	78.122	0.017	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg180_o2nofp.cx10d_c8r32
0.000	23.850	76.117	0.033	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg181_o2nofp.cx10b_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	1.939	97.222	0.839	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1222_o2nofp.cx10a_c8r32
0.000	0.000	98.317	1.683	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1322_o2nofp.cx10a_c8r32
0.000	0.206	97.911	1.883	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1323_o2nofp.cx10a_c8r32
0.000	0.039	97.356	2.606	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1419_o2nofp.cx10a_c8r32
0.000	0.883	96.833	2.283	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1420_o2nofp.cx10a_c8r32
0.000	0.322	97.083	2.594	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1514_o2nofp.cx10a_c8r32
0.000	0.089	97.717	2.194	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg1515_o2nofp.cx10a_c8r32
0.000	0.100	97.128	2.772	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1610_o2nofp.cx10a_c8r32
0.000	0.033	97.061	2.906	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1611_o2nofp.cx10a_c8r32
0.000	0.000	92.506	7.494	0.000	0.000	0.000	0.000	0.000	0.000	0.013	pg176_o2nofp.cx10a_c8r32
0.000	0.000	93.561	6.439	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg177_o2nofp.cx10a_c8r32
0.000	0.022	95.756	4.222	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg180_o2nofp.cx10b_c8r32
0.000	0.017	96.139	3.844	0.000	0.000	0.000	0.000	0.000	0.000	0.012	pg180_o2nofp.cx10c_c8r32
0.000	0.000	96.167	3.833	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg180_o2nofp.cx10d_c8r32
0.000	0.206	96.039	3.756	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg181_o2nofp.cx10b_c8r32

qp500.L4

qp500.L4: point queries with 500 insert/s per client
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.996	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1222_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1322_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1323_o2nofp.cx10a_c8r32
99.996	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.004	pg1419_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1420_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1514_o2nofp.cx10a_c8r32
99.996	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1515_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1610_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1611_o2nofp.cx10a_c8r32
99.997	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg176_o2nofp.cx10a_c8r32
99.997	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg177_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg180_o2nofp.cx10b_c8r32
99.996	0.004	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg180_o2nofp.cx10c_c8r32
99.997	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg180_o2nofp.cx10d_c8r32
99.997	0.003	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg181_o2nofp.cx10b_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	24.639	75.344	0.006	0.011	0.000	0.000	0.000	0.000	0.000	0.020	pg1222_o2nofp.cx10a_c8r32
0.000	21.578	78.389	0.022	0.011	0.000	0.000	0.000	0.000	0.000	0.029	pg1322_o2nofp.cx10a_c8r32
0.000	28.889	71.100	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1323_o2nofp.cx10a_c8r32
0.000	10.461	89.500	0.022	0.017	0.000	0.000	0.000	0.000	0.000	0.023	pg1419_o2nofp.cx10a_c8r32
0.000	29.083	70.900	0.006	0.011	0.000	0.000	0.000	0.000	0.000	0.023	pg1420_o2nofp.cx10a_c8r32
0.000	30.922	69.022	0.050	0.006	0.000	0.000	0.000	0.000	0.000	0.020	pg1514_o2nofp.cx10a_c8r32
0.000	29.894	70.050	0.044	0.011	0.000	0.000	0.000	0.000	0.000	0.021	pg1515_o2nofp.cx10a_c8r32
0.000	20.167	79.789	0.033	0.011	0.000	0.000	0.000	0.000	0.000	0.024	pg1610_o2nofp.cx10a_c8r32
0.000	32.811	67.161	0.017	0.011	0.000	0.000	0.000	0.000	0.000	0.019	pg1611_o2nofp.cx10a_c8r32
0.000	20.667	79.278	0.056	0.000	0.000	0.000	0.000	0.000	0.000	0.016	pg176_o2nofp.cx10a_c8r32
0.000	25.083	74.867	0.044	0.006	0.000	0.000	0.000	0.000	0.000	0.025	pg177_o2nofp.cx10a_c8r32
0.000	18.528	81.417	0.039	0.017	0.000	0.000	0.000	0.000	0.000	0.027	pg180_o2nofp.cx10b_c8r32
0.000	15.872	84.078	0.033	0.017	0.000	0.000	0.000	0.000	0.000	0.030	pg180_o2nofp.cx10c_c8r32
0.000	22.283	77.689	0.017	0.011	0.000	0.000	0.000	0.000	0.000	0.021	pg180_o2nofp.cx10d_c8r32
0.000	26.261	73.567	0.161	0.011	0.000	0.000	0.000	0.000	0.000	0.021	pg181_o2nofp.cx10b_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	31.983	63.722	4.289	0.006	0.000	0.000	0.000	0.000	0.000	0.018	pg1222_o2nofp.cx10a_c8r32
0.000	18.478	75.311	6.200	0.011	0.000	0.000	0.000	0.000	0.000	0.021	pg1322_o2nofp.cx10a_c8r32
0.000	25.189	67.367	7.444	0.000	0.000	0.000	0.000	0.000	0.000	0.013	pg1323_o2nofp.cx10a_c8r32
0.000	20.067	71.317	8.606	0.011	0.000	0.000	0.000	0.000	0.000	0.021	pg1419_o2nofp.cx10a_c8r32
0.000	26.417	64.244	9.328	0.011	0.000	0.000	0.000	0.000	0.000	0.022	pg1420_o2nofp.cx10a_c8r32
0.000	18.006	73.872	8.117	0.006	0.000	0.000	0.000	0.000	0.000	0.019	pg1514_o2nofp.cx10a_c8r32
0.000	17.950	71.383	10.656	0.011	0.000	0.000	0.000	0.000	0.000	0.020	pg1515_o2nofp.cx10a_c8r32
0.000	20.406	64.539	15.044	0.011	0.000	0.000	0.000	0.000	0.000	0.022	pg1610_o2nofp.cx10a_c8r32
0.000	20.267	64.661	15.061	0.011	0.000	0.000	0.000	0.000	0.000	0.017	pg1611_o2nofp.cx10a_c8r32
0.000	18.356	59.078	22.567	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg176_o2nofp.cx10a_c8r32
0.000	18.150	59.767	22.078	0.006	0.000	0.000	0.000	0.000	0.000	0.023	pg177_o2nofp.cx10a_c8r32
0.000	16.278	75.961	7.744	0.017	0.000	0.000	0.000	0.000	0.000	0.026	pg180_o2nofp.cx10b_c8r32
0.000	17.117	77.300	5.567	0.017	0.000	0.000	0.000	0.000	0.000	0.022	pg180_o2nofp.cx10c_c8r32
0.000	17.400	77.383	5.211	0.006	0.000	0.000	0.000	0.000	0.000	0.019	pg180_o2nofp.cx10d_c8r32
0.000	17.322	77.483	5.189	0.006	0.000	0.000	0.000	0.000	0.000	0.019	pg181_o2nofp.cx10b_c8r32

qr1000.L5

qr1000.L5: range queries with 1000 insert/s per client
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.998	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1222_o2nofp.cx10a_c8r32
99.998	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1322_o2nofp.cx10a_c8r32
99.998	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1323_o2nofp.cx10a_c8r32
99.998	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1419_o2nofp.cx10a_c8r32
99.998	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1420_o2nofp.cx10a_c8r32
99.998	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1514_o2nofp.cx10a_c8r32
99.998	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1515_o2nofp.cx10a_c8r32
99.998	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1610_o2nofp.cx10a_c8r32
99.998	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1611_o2nofp.cx10a_c8r32
99.998	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg176_o2nofp.cx10a_c8r32
99.998	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg177_o2nofp.cx10a_c8r32
99.998	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg180_o2nofp.cx10b_c8r32
99.998	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg180_o2nofp.cx10c_c8r32
99.998	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.013	pg180_o2nofp.cx10d_c8r32
99.998	0.002	nonzero	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg181_o2nofp.cx10b_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	39.497	60.492	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1222_o2nofp.cx10a_c8r32
0.000	41.581	58.411	0.008	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg1322_o2nofp.cx10a_c8r32
0.000	44.081	55.917	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.005	pg1323_o2nofp.cx10a_c8r32
0.000	40.494	59.494	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg1419_o2nofp.cx10a_c8r32
0.000	47.342	52.647	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg1420_o2nofp.cx10a_c8r32
0.000	40.878	59.114	0.008	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg1514_o2nofp.cx10a_c8r32
0.000	45.494	54.497	0.008	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg1515_o2nofp.cx10a_c8r32
0.000	40.017	59.942	0.042	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1610_o2nofp.cx10a_c8r32
0.000	46.425	53.561	0.014	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg1611_o2nofp.cx10a_c8r32
0.000	45.189	54.789	0.022	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg176_o2nofp.cx10a_c8r32
0.000	43.536	56.442	0.019	0.003	0.000	0.000	0.000	0.000	0.000	0.022	pg177_o2nofp.cx10a_c8r32
0.000	46.939	53.042	0.019	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg180_o2nofp.cx10b_c8r32
0.000	49.031	50.958	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg180_o2nofp.cx10c_c8r32
0.000	47.442	52.475	0.078	0.006	0.000	0.000	0.000	0.000	0.000	0.018	pg180_o2nofp.cx10d_c8r32
0.000	48.981	50.981	0.039	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg181_o2nofp.cx10b_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	12.600	85.842	1.558	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg1222_o2nofp.cx10a_c8r32
0.000	9.939	87.244	2.817	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg1322_o2nofp.cx10a_c8r32
0.000	12.308	85.042	2.650	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg1323_o2nofp.cx10a_c8r32
0.000	9.469	87.439	3.092	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg1419_o2nofp.cx10a_c8r32
0.000	10.200	86.756	3.042	0.003	0.000	0.000	0.000	0.000	0.000	0.026	pg1420_o2nofp.cx10a_c8r32
0.000	10.989	86.178	2.833	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg1514_o2nofp.cx10a_c8r32
0.000	11.075	84.744	4.181	0.000	0.000	0.000	0.000	0.000	0.000	0.014	pg1515_o2nofp.cx10a_c8r32
0.000	12.828	82.931	4.242	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1610_o2nofp.cx10a_c8r32
0.000	13.181	78.972	7.847	0.000	0.000	0.000	0.000	0.000	0.000	0.008	pg1611_o2nofp.cx10a_c8r32
0.000	8.694	79.764	11.542	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg176_o2nofp.cx10a_c8r32
0.000	9.503	79.394	11.100	0.003	0.000	0.000	0.000	0.000	0.000	0.026	pg177_o2nofp.cx10a_c8r32
0.000	8.558	88.358	3.083	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg180_o2nofp.cx10b_c8r32
0.000	8.744	88.106	3.150	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg180_o2nofp.cx10c_c8r32
0.000	9.181	87.678	3.139	0.003	0.000	0.000	0.000	0.000	0.000	0.019	pg180_o2nofp.cx10d_c8r32
0.000	8.900	88.086	3.014	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg181_o2nofp.cx10b_c8r32

qp1000.L6

qp1000.L6: point queries with 1000 insert/s per client
Legend for results is here.
Each entry lists the percentage of responses that fit in that bucket (slower than max time for previous bucket, faster than min time for next bucket).

Query response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
99.995	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1222_o2nofp.cx10a_c8r32
99.995	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1322_o2nofp.cx10a_c8r32
99.995	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1323_o2nofp.cx10a_c8r32
99.994	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1419_o2nofp.cx10a_c8r32
99.995	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1420_o2nofp.cx10a_c8r32
99.995	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1514_o2nofp.cx10a_c8r32
99.995	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1515_o2nofp.cx10a_c8r32
99.995	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg1610_o2nofp.cx10a_c8r32
99.995	0.005	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg1611_o2nofp.cx10a_c8r32
99.996	0.004	nonzero	0.000	nonzero	0.000	0.000	0.000	0.000	0.000	0.028	pg176_o2nofp.cx10a_c8r32
99.995	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg177_o2nofp.cx10a_c8r32
99.995	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg180_o2nofp.cx10b_c8r32
99.994	0.006	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001	pg180_o2nofp.cx10c_c8r32
99.995	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg180_o2nofp.cx10d_c8r32
99.995	0.005	nonzero	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.002	pg181_o2nofp.cx10b_c8r32

Insert response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	33.814	66.178	0.008	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1222_o2nofp.cx10a_c8r32
0.000	24.981	75.008	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg1322_o2nofp.cx10a_c8r32
0.000	37.381	62.611	0.008	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1323_o2nofp.cx10a_c8r32
0.000	27.744	72.247	0.006	0.003	0.000	0.000	0.000	0.000	0.000	0.021	pg1419_o2nofp.cx10a_c8r32
0.000	36.958	63.022	0.019	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg1420_o2nofp.cx10a_c8r32
0.000	32.161	67.825	0.014	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg1514_o2nofp.cx10a_c8r32
0.000	37.619	62.369	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.007	pg1515_o2nofp.cx10a_c8r32
0.000	30.144	69.844	0.011	0.000	0.000	0.000	0.000	0.000	0.000	0.006	pg1610_o2nofp.cx10a_c8r32
0.000	36.086	63.903	0.008	0.003	0.000	0.000	0.000	0.000	0.000	0.029	pg1611_o2nofp.cx10a_c8r32
0.000	25.525	74.458	0.014	0.003	0.000	0.000	0.000	0.000	0.000	0.024	pg176_o2nofp.cx10a_c8r32
0.000	32.992	66.989	0.019	0.000	0.000	0.000	0.000	0.000	0.000	0.009	pg177_o2nofp.cx10a_c8r32
0.000	22.333	77.647	0.017	0.003	0.000	0.000	0.000	0.000	0.000	0.017	pg180_o2nofp.cx10b_c8r32
0.000	41.269	58.714	0.014	0.003	0.000	0.000	0.000	0.000	0.000	0.017	pg180_o2nofp.cx10c_c8r32
0.000	39.389	60.600	0.008	0.003	0.000	0.000	0.000	0.000	0.000	0.017	pg180_o2nofp.cx10d_c8r32
0.000	43.967	56.017	0.011	0.006	0.000	0.000	0.000	0.000	0.000	0.028	pg181_o2nofp.cx10b_c8r32

Delete response time histogram

256us	1ms	4ms	16ms	64ms	256ms	1s	4s	16s	gt	max	tag
0.000	15.597	82.672	1.731	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg1222_o2nofp.cx10a_c8r32
0.000	10.347	85.872	3.781	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg1322_o2nofp.cx10a_c8r32
0.000	10.047	85.889	4.064	0.000	0.000	0.000	0.000	0.000	0.000	0.010	pg1323_o2nofp.cx10a_c8r32
0.000	10.700	85.417	3.881	0.003	0.000	0.000	0.000	0.000	0.000	0.019	pg1419_o2nofp.cx10a_c8r32
0.000	10.192	85.639	4.169	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg1420_o2nofp.cx10a_c8r32
0.000	10.947	85.386	3.667	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg1514_o2nofp.cx10a_c8r32
0.000	10.000	84.331	5.669	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg1515_o2nofp.cx10a_c8r32
0.000	15.881	76.067	8.053	0.000	0.000	0.000	0.000	0.000	0.000	0.011	pg1610_o2nofp.cx10a_c8r32
0.000	10.519	80.181	9.297	0.003	0.000	0.000	0.000	0.000	0.000	0.027	pg1611_o2nofp.cx10a_c8r32
0.000	8.197	78.631	13.169	0.003	0.000	0.000	0.000	0.000	0.000	0.022	pg176_o2nofp.cx10a_c8r32
0.000	8.997	79.653	11.350	0.000	0.000	0.000	0.000	0.000	0.000	0.012	pg177_o2nofp.cx10a_c8r32
0.000	13.747	81.283	4.969	0.000	0.000	0.000	0.000	0.000	0.000	0.012	pg180_o2nofp.cx10b_c8r32
0.000	26.881	69.847	3.272	0.000	0.000	0.000	0.000	0.000	0.000	0.016	pg180_o2nofp.cx10c_c8r32
0.000	26.906	69.389	3.706	0.000	0.000	0.000	0.000	0.000	0.000	0.015	pg180_o2nofp.cx10d_c8r32
0.000	23.042	73.225	3.728	0.006	0.000	0.000	0.000	0.000	0.000	0.026	pg181_o2nofp.cx10b_c8r32

Introduction

Contents

Summary

l.i0

l.x

l.i1

l.i2

qr100.L1

qp100.L2

qr500.L3

qp500.L4

qr1000.L5

qp1000.L6

l.i0

l.x

l.i1

l.i2

qr100.L1

qp100.L2

qr500.L3

qp500.L4

qr1000.L5

qp1000.L6

l.i0

l.x

l.i1

l.i2

qr100.L1

qp100.L2

qr500.L3

qp500.L4

qr1000.L5

qp1000.L6