vanilla vs patched - prepared

gistfile1.txt

D:\Dev\postgres\performance_testing\venv\Scripts\python.exe D:/Dev/postgres/performance_testing/venv/performance_test.py
scale	projection	index_only_fetch	page_visibility	correlation	selectivity	protocol	vanilla_tps	patched_tps	ration
start...waiting...done
drop init alter update update2 index warm
test 0 = 8209 test 1 = 8218 test 2 = 8153 test 3 = 8284 test 4 = 8305 test 5 = 8337 fin
start...waiting...done
warm
test 0 = 8622 test 1 = 8598 test 2 = 8697 test 3 = 8683 test 4 = 8672 test 5 = 8697 fin
10	True	False	True	1.0	1.0	prepared	8661	8251	0.9526613555016742
start...waiting...done
warm
test 0 = 7847 test 1 = 7867 test 2 = 7836 test 3 = 7825 test 4 = 7829 test 5 = 7803 fin
start...waiting...done
warm
test 0 = 8069 test 1 = 8033 test 2 = 8114 test 3 = 8110 test 4 = 8141 test 5 = 8129 fin
10	True	False	True	1.0	0.66	prepared	8099	7834	0.9672799111001358
start...waiting...done
warm
test 0 = 6654 test 1 = 6654 test 2 = 6634 test 3 = 6681 test 4 = 6661 test 5 = 6671 fin
start...waiting...done
warm
test 0 = 6832 test 1 = 6829 test 2 = 6830 test 3 = 6924 test 4 = 6714 test 5 = 6689 fin
10	True	False	True	1.0	0.33	prepared	6803	6659	0.9788328678524181
start...waiting...done
warm
test 0 = 4099 test 1 = 4109 test 2 = 4102 test 3 = 4126 test 4 = 4133 test 5 = 4130 fin
start...waiting...done
warm
test 0 = 4204 test 1 = 4095 test 2 = 4237 test 3 = 4241 test 4 = 4239 test 5 = 4252 fin
10	True	False	True	1.0	0.1	prepared	4211	4117	0.977677511279981
start...waiting...done
warm
test 0 = 1173 test 1 = 1171 test 2 = 1180 test 3 = 1189 test 4 = 1186 test 5 = 1186 fin
start...waiting...done
warm
test 0 = 1195 test 1 = 1192 test 2 = 1189 test 3 = 1200 test 4 = 1207 test 5 = 1202 fin
10	True	False	True	1.0	0.01	prepared	1197	1181	0.9866332497911445
start...waiting...done
drop init alter update update2 index warm
test 0 = 8132 test 1 = 8100 test 2 = 8194 test 3 = 8160 test 4 = 8201 test 5 = 8167 fin
start...waiting...done
warm
test 0 = 8522 test 1 = 8461 test 2 = 8515 test 3 = 8482 test 4 = 8488 test 5 = 8510 fin
10	True	False	True	0.95	1.0	prepared	8496	8159	0.960334274952919
start...waiting...done
warm
test 0 = 7629 test 1 = 7621 test 2 = 7603 test 3 = 7646 test 4 = 7650 test 5 = 7617 fin
start...waiting...done
warm
test 0 = 7846 test 1 = 7839 test 2 = 7838 test 3 = 7924 test 4 = 7925 test 5 = 7891 fin
10	True	False	True	0.95	0.66	prepared	7877	7628	0.9683889805763616
start...waiting...done
warm
test 0 = 6360 test 1 = 6357 test 2 = 6373 test 3 = 6307 test 4 = 6298 test 5 = 6320 fin
start...waiting...done
warm
test 0 = 6556 test 1 = 6569 test 2 = 6557 test 3 = 6569 test 4 = 6600 test 5 = 6591 fin
10	True	False	True	0.95	0.33	prepared	6574	6336	0.9637967751749316
start...waiting...done
warm
test 0 = 3779 test 1 = 3767 test 2 = 3796 test 3 = 3786 test 4 = 3788 test 5 = 3800 fin
start...waiting...done
warm
test 0 = 3893 test 1 = 3902 test 2 = 3883 test 3 = 3885 test 4 = 3903 test 5 = 3911 fin
10	True	False	True	0.95	0.1	prepared	3896	3786	0.9717659137577002
start...waiting...done
warm
test 0 = 1049 test 1 = 1046 test 2 = 1050 test 3 = 1037 test 4 = 1036 test 5 = 1042 fin
start...waiting...done
warm
test 0 = 1064 test 1 = 1063 test 2 = 1060 test 3 = 1060 test 4 = 1068 test 5 = 1070 fin
10	True	False	True	0.95	0.01	prepared	1064	1043	0.9802631578947368
start...waiting...done
drop init alter update update2 index warm
test 0 = 8070 test 1 = 8124 test 2 = 8123 test 3 = 8150 test 4 = 8132 test 5 = 8129 fin
start...waiting...done
warm
test 0 = 8355 test 1 = 8376 test 2 = 8347 test 3 = 8378 test 4 = 8384 test 5 = 8372 fin
10	True	False	True	0.9	1.0	prepared	8369	8121	0.970366829967738
start...waiting...done
warm
test 0 = 7520 test 1 = 7503 test 2 = 7499 test 3 = 7523 test 4 = 7524 test 5 = 7483 fin
start...waiting...done
warm
test 0 = 7714 test 1 = 7712 test 2 = 7720 test 3 = 7718 test 4 = 7750 test 5 = 7766 fin
10	True	False	True	0.9	0.66	prepared	7730	7508	0.9712807244501941
start...waiting...done
warm
test 0 = 6186 test 1 = 6184 test 2 = 6179 test 3 = 6155 test 4 = 6156 test 5 = 6155 fin
start...waiting...done
warm
test 0 = 6345 test 1 = 6347 test 2 = 6323 test 3 = 6346 test 4 = 6344 test 5 = 6354 fin
10	True	False	True	0.9	0.33	prepared	6343	6169	0.9725681854012297
start...waiting...done
warm
test 0 = 3590 test 1 = 3577 test 2 = 3583 test 3 = 3588 test 4 = 3597 test 5 = 3593 fin
start...waiting...done
warm
test 0 = 3662 test 1 = 3666 test 2 = 3661 test 3 = 3687 test 4 = 3678 test 5 = 3686 fin
10	True	False	True	0.9	0.1	prepared	3673	3588	0.976858154097468
start...waiting...done
warm
test 0 = 976 test 1 = 975 test 2 = 970 test 3 = 975 test 4 = 973 test 5 = 975 fin
start...waiting...done
warm
test 0 = 985 test 1 = 984 test 2 = 984 test 3 = 982 test 4 = 983 test 5 = 987 fin
10	True	False	True	0.9	0.01	prepared	984	974	0.9898373983739838
start...waiting...done
drop init alter update update2 index warm
test 0 = 7979 test 1 = 7930 test 2 = 7980 test 3 = 7976 test 4 = 7982 test 5 = 8000 fin
start...waiting...done
warm
test 0 = 8246 test 1 = 8232 test 2 = 8234 test 3 = 8208 test 4 = 8240 test 5 = 8227 fin
10	True	False	True	0.85	1.0	prepared	8231	7974	0.9687765763576722
start...waiting...done
warm
test 0 = 7363 test 1 = 7332 test 2 = 7331 test 3 = 7328 test 4 = 7300 test 5 = 7332 fin
start...waiting...done
warm
test 0 = 7522 test 1 = 7522 test 2 = 7538 test 3 = 7526 test 4 = 7515 test 5 = 7536 fin
10	True	False	True	0.85	0.66	prepared	7526	7331	0.9740898219505714
start...waiting...done
warm
test 0 = 5961 test 1 = 5987 test 2 = 5949 test 3 = 5966 test 4 = 5986 test 5 = 5958 fin
start...waiting...done
warm
test 0 = 6127 test 1 = 6108 test 2 = 6101 test 3 = 6092 test 4 = 6117 test 5 = 6096 fin
10	True	False	True	0.85	0.33	prepared	6107	5968	0.9772392336662846
start...waiting...done
warm
test 0 = 3381 test 1 = 3370 test 2 = 3374 test 3 = 3375 test 4 = 3369 test 5 = 3391 fin
start...waiting...done
warm
test 0 = 3459 test 1 = 3461 test 2 = 3445 test 3 = 3464 test 4 = 3465 test 5 = 3464 fin
10	True	False	True	0.85	0.1	prepared	3460	3377	0.9760115606936416
start...waiting...done
warm
test 0 = 894 test 1 = 894 test 2 = 895 test 3 = 894 test 4 = 893 test 5 = 895 fin
start...waiting...done
warm
test 0 = 907 test 1 = 908 test 2 = 909 test 3 = 905 test 4 = 906 test 5 = 907 fin
10	True	False	True	0.85	0.01	prepared	907	894	0.9856670341786108
start...waiting...done
drop init alter update update2 index warm
test 0 = 7832 test 1 = 7843 test 2 = 7855 test 3 = 7891 test 4 = 7890 test 5 = 7884 fin
start...waiting...done
warm
test 0 = 8026 test 1 = 8056 test 2 = 8024 test 3 = 8075 test 4 = 8055 test 5 = 8064 fin
10	True	False	True	0.8	1.0	prepared	8050	7866	0.9771428571428571
start...waiting...done
warm
test 0 = 7150 test 1 = 7165 test 2 = 7156 test 3 = 7173 test 4 = 7171 test 5 = 7187 fin
start...waiting...done
warm
test 0 = 7371 test 1 = 7343 test 2 = 7340 test 3 = 7339 test 4 = 7359 test 5 = 7371 fin
10	True	False	True	0.8	0.66	prepared	7354	7167	0.974571661680718
start...waiting...done
warm
test 0 = 5771 test 1 = 5792 test 2 = 5762 test 3 = 5775 test 4 = 5770 test 5 = 5762 fin
start...waiting...done
warm
test 0 = 5891 test 1 = 5898 test 2 = 5867 test 3 = 5903 test 4 = 5922 test 5 = 5892 fin
10	True	False	True	0.8	0.33	prepared	5896	5772	0.9789687924016283
start...waiting...done
warm
test 0 = 3221 test 1 = 3224 test 2 = 3221 test 3 = 3224 test 4 = 3222 test 5 = 3234 fin
start...waiting...done
warm
test 0 = 3282 test 1 = 3280 test 2 = 3272 test 3 = 3276 test 4 = 3272 test 5 = 3270 fin
10	True	False	True	0.8	0.1	prepared	3276	3224	0.9841269841269841
start...waiting...done
warm
test 0 = 828 test 1 = 829 test 2 = 831 test 3 = 825 test 4 = 826 test 5 = 825 fin
start...waiting...done
warm
test 0 = 838 test 1 = 839 test 2 = 837 test 3 = 844 test 4 = 846 test 5 = 843 fin
10	True	False	True	0.8	0.01	prepared	841	827	0.9833531510107015
start...waiting...done
drop init alter update update2 index warm
test 0 = 7717 test 1 = 7701 test 2 = 7713 test 3 = 7745 test 4 = 7718 test 5 = 7710 fin
start...waiting...done
warm
test 0 = 7907 test 1 = 7896 test 2 = 7881 test 3 = 7884 test 4 = 7913 test 5 = 7906 fin
10	True	False	True	0.75	1.0	prepared	7898	7717	0.9770828057736136
start...waiting...done
warm
test 0 = 7009 test 1 = 7019 test 2 = 7020 test 3 = 7024 test 4 = 7020 test 5 = 7032 fin
start...waiting...done
warm
test 0 = 7203 test 1 = 7187 test 2 = 7200 test 3 = 7160 test 4 = 7171 test 5 = 7172 fin
10	True	False	True	0.75	0.66	prepared	7182	7021	0.9775828460038987
start...waiting...done
warm
test 0 = 5604 test 1 = 5597 test 2 = 5586 test 3 = 5581 test 4 = 5592 test 5 = 5578 fin
start...waiting...done
warm
test 0 = 5706 test 1 = 5702 test 2 = 5703 test 3 = 5703 test 4 = 5705 test 5 = 5704 fin
10	True	False	True	0.75	0.33	prepared	5704	5590	0.9800140252454418
start...waiting...done
warm
test 0 = 3032 test 1 = 3038 test 2 = 3024 test 3 = 3066 test 4 = 3053 test 5 = 3077 fin
start...waiting...done
warm
test 0 = 3087 test 1 = 3096 test 2 = 3091 test 3 = 3094 test 4 = 3089 test 5 = 3102 fin
10	True	False	True	0.75	0.1	prepared	3093	3048	0.98545101842871
start...waiting...done
warm
test 0 = 776 test 1 = 772 test 2 = 772 test 3 = 779 test 4 = 778 test 5 = 782 fin
start...waiting...done
warm
test 0 = 786 test 1 = 787 test 2 = 788 test 3 = 789 test 4 = 788 test 5 = 788 fin
10	True	False	True	0.75	0.01	prepared	788	777	0.9860406091370558
start...waiting...done
drop init alter update update2 index warm
test 0 = 7125 test 1 = 7147 test 2 = 7167 test 3 = 7199 test 4 = 7199 test 5 = 7141 fin
start...waiting...done
warm
test 0 = 7298 test 1 = 7252 test 2 = 7217 test 3 = 7301 test 4 = 7312 test 5 = 7306 fin
10	True	False	True	0.5	1.0	prepared	7281	7163	0.9837934349677242
start...waiting...done
warm
test 0 = 6416 test 1 = 6441 test 2 = 6403 test 3 = 6414 test 4 = 6439 test 5 = 6422 fin
start...waiting...done
warm
test 0 = 6542 test 1 = 6528 test 2 = 6486 test 3 = 6543 test 4 = 6525 test 5 = 6533 fin
10	True	False	True	0.5	0.66	prepared	6526	6422	0.9840637450199203
start...waiting...done
warm
test 0 = 4982 test 1 = 4969 test 2 = 4961 test 3 = 4963 test 4 = 4981 test 5 = 4984 fin
start...waiting...done
warm
test 0 = 5019 test 1 = 5035 test 2 = 5018 test 3 = 5022 test 4 = 5044 test 5 = 5052 fin
10	True	False	True	0.5	0.33	prepared	5032	4973	0.988275039745628
start...waiting...done
warm
test 0 = 2567 test 1 = 2575 test 2 = 2571 test 3 = 2581 test 4 = 2570 test 5 = 2570 fin
start...waiting...done
warm
test 0 = 2550 test 1 = 2555 test 2 = 2543 test 3 = 2614 test 4 = 2598 test 5 = 2587 fin
10	True	False	True	0.5	0.1	prepared	2574	2572	0.9992229992229992
start...waiting...done
warm
test 0 = 630 test 1 = 629 test 2 = 621 test 3 = 625 test 4 = 625 test 5 = 624 fin
start...waiting...done
warm
test 0 = 627 test 1 = 628 test 2 = 627 test 3 = 632 test 4 = 634 test 5 = 631 fin
10	True	False	True	0.5	0.01	prepared	630	626	0.9936507936507937
start...waiting...done
drop init alter update update2 index warm
test 0 = 6671 test 1 = 6575 test 2 = 6648 test 3 = 6683 test 4 = 6673 test 5 = 6643 fin
start...waiting...done
warm
test 0 = 6793 test 1 = 6787 test 2 = 6730 test 3 = 6757 test 4 = 6796 test 5 = 6802 fin
10	True	False	True	0.25	1.0	prepared	6777	6649	0.9811125866902759
start...waiting...done
warm
test 0 = 5967 test 1 = 5973 test 2 = 5964 test 3 = 5981 test 4 = 5968 test 5 = 5958 fin
start...waiting...done
warm
test 0 = 6046 test 1 = 6052 test 2 = 5963 test 3 = 5941 test 4 = 6030 test 5 = 6054 fin
10	True	False	True	0.25	0.66	prepared	6014	5969	0.9925174592617226
start...waiting...done
warm
test 0 = 4590 test 1 = 4579 test 2 = 4564 test 3 = 4593 test 4 = 4590 test 5 = 4568 fin
start...waiting...done
warm
test 0 = 4647 test 1 = 4639 test 2 = 4621 test 3 = 4636 test 4 = 4640 test 5 = 4623 fin
10	True	False	True	0.25	0.33	prepared	4634	4581	0.9885627967198964
start...waiting...done
warm
test 0 = 2272 test 1 = 2271 test 2 = 2264 test 3 = 2298 test 4 = 2306 test 5 = 2318 fin
start...waiting...done
warm
test 0 = 2325 test 1 = 2319 test 2 = 2314 test 3 = 2269 test 4 = 2280 test 5 = 2286 fin
10	True	False	True	0.25	0.1	prepared	2299	2288	0.9952153110047847
start...waiting...done
warm
test 0 = 554 test 1 = 554 test 2 = 554 test 3 = 555 test 4 = 554 test 5 = 555 fin
start...waiting...done
warm
test 0 = 558 test 1 = 557 test 2 = 556 test 3 = 552 test 4 = 559 test 5 = 555 fin
10	True	False	True	0.25	0.01	prepared	556	554	0.9964028776978417
start...waiting...done
drop init alter update update2 index warm
test 0 = 5942 test 1 = 5791 test 2 = 5958 test 3 = 5977 test 4 = 5973 test 5 = 5948 fin
start...waiting...done
warm
test 0 = 6044 test 1 = 6049 test 2 = 6048 test 3 = 6029 test 4 = 6052 test 5 = 6031 fin
10	True	False	True	0.1	1.0	prepared	6042	5931	0.9816285998013903
start...waiting...done
warm
test 0 = 5506 test 1 = 5511 test 2 = 5503 test 3 = 5504 test 4 = 5495 test 5 = 5506 fin
start...waiting...done
warm
test 0 = 5581 test 1 = 5573 test 2 = 5556 test 3 = 5550 test 4 = 5552 test 5 = 5573 fin
10	True	False	True	0.1	0.66	prepared	5564	5504	0.9892163910855499
start...waiting...done
warm
test 0 = 4343 test 1 = 4360 test 2 = 4364 test 3 = 4363 test 4 = 4365 test 5 = 4377 fin
start...waiting...done
warm
test 0 = 4401 test 1 = 4402 test 2 = 4390 test 3 = 4404 test 4 = 4400 test 5 = 4393 fin
10	True	False	True	0.1	0.33	prepared	4398	4362	0.9918144611186903
start...waiting...done
warm
test 0 = 2218 test 1 = 2213 test 2 = 2145 test 3 = 2153 test 4 = 2154 test 5 = 2156 fin
start...waiting...done
warm
test 0 = 2213 test 1 = 2225 test 2 = 2215 test 3 = 2172 test 4 = 2167 test 5 = 2161 fin
10	True	False	True	0.1	0.1	prepared	2192	2173	0.9913321167883211
start...waiting...done
warm
test 0 = 532 test 1 = 531 test 2 = 529 test 3 = 530 test 4 = 532 test 5 = 534 fin
start...waiting...done
warm
test 0 = 532 test 1 = 533 test 2 = 532 test 3 = 530 test 4 = 529 test 5 = 532 fin
10	True	False	True	0.1	0.01	prepared	531	531	1.0
start...waiting...done
drop init alter update update2 index warm
test 0 = 5483 test 1 = 5258 test 2 = 5200 test 3 = 5246 test 4 = 5450 test 5 = 5502 fin
start...waiting...done
warm
test 0 = 5539 test 1 = 5559 test 2 = 5488 test 3 = 5555 test 4 = 5568 test 5 = 5566 fin
10	True	False	True	0.01	1.0	prepared	5546	5357	0.9659213847818248
start...waiting...done
warm
test 0 = 4808 test 1 = 4829 test 2 = 4815 test 3 = 4815 test 4 = 4809 test 5 = 4822 fin
start...waiting...done
warm
test 0 = 4861 test 1 = 4876 test 2 = 4844 test 3 = 4868 test 4 = 4871 test 5 = 4853 fin
10	True	False	True	0.01	0.66	prepared	4862	4816	0.9905388728918141
start...waiting...done
warm
test 0 = 3622 test 1 = 3627 test 2 = 3610 test 3 = 3628 test 4 = 3619 test 5 = 3631 fin
start...waiting...done
warm
test 0 = 3647 test 1 = 3642 test 2 = 3625 test 3 = 3660 test 4 = 3653 test 5 = 3619 fin
10	True	False	True	0.01	0.33	prepared	3641	3623	0.9950563032134029
start...waiting...done
warm
test 0 = 1797 test 1 = 1785 test 2 = 1815 test 3 = 1823 test 4 = 1813 test 5 = 1818 fin
start...waiting...done
warm
test 0 = 1805 test 1 = 1799 test 2 = 1796 test 3 = 1829 test 4 = 1819 test 5 = 1792 fin
10	True	False	True	0.01	0.1	prepared	1807	1809	1.0011068068622024
start...waiting...done
warm
test 0 = 467 test 1 = 466 test 2 = 457 test 3 = 465 test 4 = 467 test 5 = 466 fin
start...waiting...done
warm
test 0 = 466 test 1 = 466 test 2 = 463 test 3 = 465 test 4 = 466 test 5 = 462 fin
10	True	False	True	0.01	0.01	prepared	465	465	1.0
start...waiting...done
drop init alter update update2 index warm
test 0 = 6831 test 1 = 6841 test 2 = 6824 test 3 = 6813 test 4 = 6825 test 5 = 6833 fin
start...waiting...done
warm
test 0 = 7064 test 1 = 7066 test 2 = 7011 test 3 = 7052 test 4 = 7055 test 5 = 7057 fin
100	True	False	True	1.0	1.0	prepared	7051	6828	0.9683732803857609
start...waiting...done
warm
test 0 = 6357 test 1 = 6366 test 2 = 6359 test 3 = 6377 test 4 = 6361 test 5 = 6373 fin
start...waiting...done
warm
test 0 = 6580 test 1 = 6568 test 2 = 6551 test 3 = 6565 test 4 = 6582 test 5 = 6582 fin
100	True	False	True	1.0	0.66	prepared	6571	6366	0.9688023131943387
start...waiting...done
warm
test 0 = 5347 test 1 = 5349 test 2 = 5339 test 3 = 5348 test 4 = 5335 test 5 = 5340 fin
start...waiting...done
warm
test 0 = 5510 test 1 = 5511 test 2 = 5475 test 3 = 5503 test 4 = 5488 test 5 = 5475 fin
100	True	False	True	1.0	0.33	prepared	5494	5343	0.9725154714233709
start...waiting...done
warm
test 0 = 3221 test 1 = 3221 test 2 = 3224 test 3 = 3207 test 4 = 3227 test 5 = 3225 fin
start...waiting...done
warm
test 0 = 3287 test 1 = 3280 test 2 = 3293 test 3 = 3282 test 4 = 3283 test 5 = 3289 fin
100	True	False	True	1.0	0.1	prepared	3286	3221	0.980219111381619
start...waiting...done
warm
test 0 = 895 test 1 = 893 test 2 = 896 test 3 = 896 test 4 = 890 test 5 = 890 fin
start...waiting...done
warm
test 0 = 910 test 1 = 909 test 2 = 909 test 3 = 906 test 4 = 907 test 5 = 904 fin
100	True	False	True	1.0	0.01	prepared	908	893	0.9834801762114538
start...waiting...done
drop init alter update update2 index warm
test 0 = 6158 test 1 = 6105 test 2 = 6120 test 3 = 6154 test 4 = 6144 test 5 = 6129 fin
start...waiting...done
warm
test 0 = 6319 test 1 = 6306 test 2 = 6280 test 3 = 6321 test 4 = 6325 test 5 = 6318 fin
100	True	False	True	0.95	1.0	prepared	6312	6135	0.971958174904943
start...waiting...done
warm
test 0 = 5599 test 1 = 5608 test 2 = 5619 test 3 = 5629 test 4 = 5623 test 5 = 5613 fin
start...waiting...done
warm
test 0 = 5759 test 1 = 5752 test 2 = 5733 test 3 = 5772 test 4 = 5747 test 5 = 5758 fin
100	True	False	True	0.95	0.66	prepared	5753	5615	0.976012515209456
start...waiting...done
warm
test 0 = 4538 test 1 = 4533 test 2 = 4536 test 3 = 4525 test 4 = 4519 test 5 = 4520 fin
start...waiting...done
warm
test 0 = 4605 test 1 = 4626 test 2 = 4634 test 3 = 4631 test 4 = 4637 test 5 = 4648 fin
100	True	False	True	0.95	0.33	prepared	4630	4528	0.9779697624190065
start...waiting...done
warm
test 0 = 2529 test 1 = 2543 test 2 = 2542 test 3 = 2524 test 4 = 2517 test 5 = 2514 fin
start...waiting...done
warm
test 0 = 2537 test 1 = 2550 test 2 = 2547 test 3 = 2569 test 4 = 2589 test 5 = 2574 fin
100	True	False	True	0.95	0.1	prepared	2561	2528	0.9871144084342054
start...waiting...done
warm
test 0 = 665 test 1 = 665 test 2 = 666 test 3 = 668 test 4 = 666 test 5 = 664 fin
start...waiting...done
warm
test 0 = 674 test 1 = 671 test 2 = 670 test 3 = 673 test 4 = 676 test 5 = 673 fin
100	True	False	True	0.95	0.01	prepared	673	666	0.9895988112927192
start...waiting...done
drop init alter update update2 index warm
test 0 = 5359 test 1 = 5333 test 2 = 5338 test 3 = 5343 test 4 = 5369 test 5 = 5360 fin
start...waiting...done
warm
test 0 = 5451 test 1 = 5475 test 2 = 5458 test 3 = 5486 test 4 = 5483 test 5 = 5478 fin
100	True	False	True	0.9	1.0	prepared	5472	5350	0.9777046783625731
start...waiting...done
warm
test 0 = 4688 test 1 = 4684 test 2 = 4694 test 3 = 4707 test 4 = 4682 test 5 = 4684 fin
start...waiting...done
warm
test 0 = 4826 test 1 = 4820 test 2 = 4773 test 3 = 4799 test 4 = 4800 test 5 = 4804 fin
100	True	False	True	0.9	0.66	prepared	4804	4690	0.9762697751873439
start...waiting...done
warm
test 0 = 3508 test 1 = 3519 test 2 = 3488 test 3 = 3496 test 4 = 3511 test 5 = 3507 fin
start...waiting...done
warm
test 0 = 3573 test 1 = 3572 test 2 = 3567 test 3 = 3582 test 4 = 3568 test 5 = 3567 fin
100	True	False	True	0.9	0.33	prepared	3572	3505	0.9812430011198209
start...waiting...done
warm
test 0 = 1669 test 1 = 1669 test 2 = 1675 test 3 = 1692 test 4 = 1684 test 5 = 1695 fin
start...waiting...done
warm
test 0 = 1710 test 1 = 1708 test 2 = 1706 test 3 = 1694 test 4 = 1687 test 5 = 1690 fin
100	True	False	True	0.9	0.1	prepared	1699	1681	0.9894055326662743
start...waiting...done
warm
test 0 = 398 test 1 = 396 test 2 = 397 test 3 = 399 test 4 = 397 test 5 = 397 fin
start...waiting...done
warm
test 0 = 400 test 1 = 401 test 2 = 403 test 3 = 399 test 4 = 399 test 5 = 400 fin
100	True	False	True	0.9	0.01	prepared	400	397	0.9925
start...waiting...done
drop init alter update update2 index warm
test 0 = 4621 test 1 = 4691 test 2 = 4694 test 3 = 4701 test 4 = 4680 test 5 = 4691 fin
start...waiting...done
warm
test 0 = 4775 test 1 = 4781 test 2 = 4762 test 3 = 4759 test 4 = 4787 test 5 = 4770 fin
100	True	False	True	0.85	1.0	prepared	4772	4680	0.980720871751886
start...waiting...done
warm
test 0 = 3972 test 1 = 3974 test 2 = 3972 test 3 = 3985 test 4 = 3960 test 5 = 3957 fin
start...waiting...done
warm
test 0 = 4046 test 1 = 4037 test 2 = 4034 test 3 = 4057 test 4 = 4033 test 5 = 4056 fin
100	True	False	True	0.85	0.66	prepared	4044	3970	0.9817012858555886
start...waiting...done
warm
test 0 = 2771 test 1 = 2775 test 2 = 2773 test 3 = 2749 test 4 = 2746 test 5 = 2749 fin
start...waiting...done
warm
test 0 = 2783 test 1 = 2785 test 2 = 2781 test 3 = 2807 test 4 = 2819 test 5 = 2810 fin
100	True	False	True	0.85	0.33	prepared	2797	2761	0.9871290668573471
start...waiting...done
warm
test 0 = 1222 test 1 = 1229 test 2 = 1225 test 3 = 1216 test 4 = 1218 test 5 = 1217 fin
start...waiting...done
warm
test 0 = 1228 test 1 = 1232 test 2 = 1232 test 3 = 1225 test 4 = 1223 test 5 = 1228 fin
100	True	False	True	0.85	0.1	prepared	1228	1221	0.994299674267101
start...waiting...done
warm
test 0 = 268 test 1 = 266 test 2 = 267 test 3 = 266 test 4 = 266 test 5 = 266 fin
start...waiting...done
warm
test 0 = 268 test 1 = 268 test 2 = 269 test 3 = 269 test 4 = 267 test 5 = 269 fin
100	True	False	True	0.85	0.01	prepared	268	267	0.996268656716418
start...waiting...done
drop init alter update update2 index warm
test 0 = 4136 test 1 = 4098 test 2 = 4155 test 3 = 4155 test 4 = 4159 test 5 = 4156 fin
start...waiting...done
warm
test 0 = 4221 test 1 = 4216 test 2 = 4188 test 3 = 4209 test 4 = 4209 test 5 = 4214 fin
100	True	False	True	0.8	1.0	prepared	4210	4143	0.9840855106888361
start...waiting...done
warm
test 0 = 3370 test 1 = 3416 test 2 = 3423 test 3 = 3419 test 4 = 3428 test 5 = 3409 fin
start...waiting...done
warm
test 0 = 3476 test 1 = 3447 test 2 = 3463 test 3 = 3478 test 4 = 3474 test 5 = 3451 fin
100	True	False	True	0.8	0.66	prepared	3465	3411	0.9844155844155844
start...waiting...done
warm
test 0 = 2251 test 1 = 2265 test 2 = 2266 test 3 = 2224 test 4 = 2215 test 5 = 2214 fin
start...waiting...done
warm
test 0 = 2273 test 1 = 2281 test 2 = 2276 test 3 = 2247 test 4 = 2241 test 5 = 2235 fin
100	True	False	True	0.8	0.33	prepared	2259	2239	0.9911465250110668
start...waiting...done
warm
test 0 = 946 test 1 = 945 test 2 = 946 test 3 = 945 test 4 = 949 test 5 = 943 fin
start...waiting...done
warm
test 0 = 950 test 1 = 946 test 2 = 945 test 3 = 953 test 4 = 953 test 5 = 955 fin
100	True	False	True	0.8	0.1	prepared	950	946	0.9957894736842106
start...waiting...done
warm
test 0 = 197 test 1 = 197 test 2 = 197 test 3 = 197 test 4 = 199 test 5 = 199 fin
start...waiting...done
warm
test 0 = 199 test 1 = 200 test 2 = 200 test 3 = 200 test 4 = 199 test 5 = 198 fin
100	True	False	True	0.8	0.01	prepared	199	198	0.9949748743718593
start...waiting...done
drop init alter update update2 index warm
test 0 = 3703 test 1 = 3672 test 2 = 3709 test 3 = 3725 test 4 = 3713 test 5 = 3707 fin
start...waiting...done
warm
test 0 = 3756 test 1 = 3754 test 2 = 3750 test 3 = 3748 test 4 = 3764 test 5 = 3765 fin
100	True	False	True	0.75	1.0	prepared	3756	3705	0.9864217252396166
start...waiting...done
warm
test 0 = 2977 test 1 = 2956 test 2 = 2954 test 3 = 2954 test 4 = 2943 test 5 = 2954 fin
start...waiting...done
warm
test 0 = 2992 test 1 = 2986 test 2 = 2980 test 3 = 2982 test 4 = 2987 test 5 = 2973 fin
100	True	False	True	0.75	0.66	prepared	2983	2956	0.9909487093530004
start...waiting...done
warm
test 0 = 1851 test 1 = 1850 test 2 = 1850 test 3 = 1848 test 4 = 1840 test 5 = 1847 fin
start...waiting...done
warm
test 0 = 1896 test 1 = 1881 test 2 = 1889 test 3 = 1877 test 4 = 1869 test 5 = 1865 fin
100	True	False	True	0.75	0.33	prepared	1880	1848	0.9829787234042553
start...waiting...done
warm
test 0 = 754 test 1 = 756 test 2 = 750 test 3 = 759 test 4 = 756 test 5 = 758 fin
start...waiting...done
warm
test 0 = 761 test 1 = 763 test 2 = 762 test 3 = 763 test 4 = 763 test 5 = 763 fin
100	True	False	True	0.75	0.1	prepared	763	755	0.9895150720838795
start...waiting...done
warm
test 0 = 155 test 1 = 155 test 2 = 155 test 3 = 155 test 4 = 155 test 5 = 155 fin
start...waiting...done
warm
test 0 = 156 test 1 = 157 test 2 = 155 test 3 = 157 test 4 = 156 test 5 = 156 fin
100	True	False	True	0.75	0.01	prepared	156	155	0.9935897435897436
start...waiting...done
drop init alter update update2 index warm
test 0 = 2299 test 1 = 2303 test 2 = 2363 test 3 = 2364 test 4 = 2368 test 5 = 2361 fin
start...waiting...done
warm
test 0 = 2372 test 1 = 2380 test 2 = 2372 test 3 = 2334 test 4 = 2326 test 5 = 2367 fin
100	True	False	True	0.5	1.0	prepared	2359	2343	0.993217465027554
start...waiting...done
warm
test 0 = 1743 test 1 = 1743 test 2 = 1742 test 3 = 1740 test 4 = 1736 test 5 = 1739 fin
start...waiting...done
warm
test 0 = 1766 test 1 = 1763 test 2 = 1765 test 3 = 1755 test 4 = 1758 test 5 = 1770 fin
100	True	False	True	0.5	0.66	prepared	1763	1740	0.9869540555870675
start...waiting...done
warm
test 0 = 1020 test 1 = 1023 test 2 = 1022 test 3 = 1026 test 4 = 1026 test 5 = 1028 fin
start...waiting...done
warm
test 0 = 1032 test 1 = 1033 test 2 = 1028 test 3 = 1035 test 4 = 1032 test 5 = 1038 fin
100	True	False	True	0.5	0.33	prepared	1033	1024	0.9912875121006777
start...waiting...done
warm
test 0 = 375 test 1 = 375 test 2 = 375 test 3 = 374 test 4 = 373 test 5 = 374 fin
start...waiting...done
warm
test 0 = 378 test 1 = 376 test 2 = 376 test 3 = 375 test 4 = 373 test 5 = 375 fin
100	True	False	True	0.5	0.1	prepared	375	374	0.9973333333333333
start...waiting...done
warm
test 0 = 73 test 1 = 73 test 2 = 73 test 3 = 73 test 4 = 73 test 5 = 73 fin
start...waiting...done
warm
test 0 = 73 test 1 = 74 test 2 = 74 test 3 = 73 test 4 = 72 test 5 = 73 fin
100	True	False	True	0.5	0.01	prepared	73	73	1.0
start...waiting...done
drop init alter update update2 index warm
test 0 = 1721 test 1 = 1728 test 2 = 1728 test 3 = 1726 test 4 = 1721 test 5 = 1704 fin
start...waiting...done
warm
test 0 = 1711 test 1 = 1703 test 2 = 1714 test 3 = 1709 test 4 = 1716 test 5 = 1722 fin
100	True	False	True	0.25	1.0	prepared	1712	1721	1.0052570093457944
start...waiting...done
warm
test 0 = 1258 test 1 = 1259 test 2 = 1256 test 3 = 1252 test 4 = 1257 test 5 = 1252 fin
start...waiting...done
warm
test 0 = 1267 test 1 = 1263 test 2 = 1259 test 3 = 1260 test 4 = 1261 test 5 = 1259 fin
100	True	False	True	0.25	0.66	prepared	1261	1256	0.9960348929421095
start...waiting...done
warm
test 0 = 710 test 1 = 708 test 2 = 708 test 3 = 715 test 4 = 713 test 5 = 706 fin
start...waiting...done
warm
test 0 = 709 test 1 = 707 test 2 = 702 test 3 = 704 test 4 = 711 test 5 = 711 fin
100	True	False	True	0.25	0.33	prepared	707	710	1.0042432814710043
start...waiting...done
warm
test 0 = 247 test 1 = 247 test 2 = 248 test 3 = 248 test 4 = 246 test 5 = 247 fin
start...waiting...done
warm
test 0 = 247 test 1 = 247 test 2 = 246 test 3 = 249 test 4 = 248 test 5 = 247 fin
100	True	False	True	0.25	0.1	prepared	247	247	1.0
start...waiting...done
warm
test 0 = 48 test 1 = 48 test 2 = 48 test 3 = 48 test 4 = 48 test 5 = 48 fin
start...waiting...done
warm
test 0 = 48 test 1 = 48 test 2 = 47 test 3 = 48 test 4 = 48 test 5 = 48 fin
100	True	False	True	0.25	0.01	prepared	48	48	1.0
start...waiting...done
drop init alter update update2 index warm
test 0 = 1477 test 1 = 1480 test 2 = 1471 test 3 = 1472 test 4 = 1486 test 5 = 1489 fin
start...waiting...done
warm
test 0 = 1479 test 1 = 1485 test 2 = 1486 test 3 = 1479 test 4 = 1475 test 5 = 1479 fin
100	True	False	True	0.1	1.0	prepared	1480	1479	0.9993243243243243
start...waiting...done
warm
test 0 = 1075 test 1 = 1078 test 2 = 1070 test 3 = 1080 test 4 = 1084 test 5 = 1078 fin
start...waiting...done
warm
test 0 = 1072 test 1 = 1081 test 2 = 1080 test 3 = 1080 test 4 = 1083 test 5 = 1081 fin
100	True	False	True	0.1	0.66	prepared	1079	1077	0.9981464318813716
start...waiting...done
warm
test 0 = 594 test 1 = 596 test 2 = 596 test 3 = 597 test 4 = 596 test 5 = 597 fin
start...waiting...done
warm
test 0 = 598 test 1 = 600 test 2 = 599 test 3 = 599 test 4 = 599 test 5 = 599 fin
100	True	False	True	0.1	0.33	prepared	599	596	0.994991652754591
start...waiting...done
warm
test 0 = 206 test 1 = 208 test 2 = 207 test 3 = 204 test 4 = 206 test 5 = 206 fin
start...waiting...done
warm
test 0 = 208 test 1 = 207 test 2 = 207 test 3 = 208 test 4 = 208 test 5 = 209 fin
100	True	False	True	0.1	0.1	prepared	208	206	0.9903846153846154
start...waiting...done
warm
test 0 = 39 test 1 = 39 test 2 = 39 test 3 = 39 test 4 = 39 test 5 = 39 fin
start...waiting...done
warm
test 0 = 39 test 1 = 39 test 2 = 40 test 3 = 39 test 4 = 39 test 5 = 39 fin
100	True	False	True	0.1	0.01	prepared	39	39	1.0
start...waiting...done
drop init alter update update2 index warm
test 0 = 1383 test 1 = 1385 test 2 = 1392 test 3 = 1395 test 4 = 1394 test 5 = 1398 fin
start...waiting...done
warm
test 0 = 1388 test 1 = 1394 test 2 = 1384 test 3 = 1397 test 4 = 1390 test 5 = 1393 fin
100	True	False	True	0.01	1.0	prepared	1391	1391	1.0
start...waiting...done
warm
test 0 = 996 test 1 = 1001 test 2 = 1001 test 3 = 999 test 4 = 1000 test 5 = 1000 fin
start...waiting...done
warm
test 0 = 995 test 1 = 1002 test 2 = 1003 test 3 = 1000 test 4 = 994 test 5 = 996 fin
100	True	False	True	0.01	0.66	prepared	998	999	1.001002004008016
start...waiting...done
warm
test 0 = 541 test 1 = 544 test 2 = 542 test 3 = 544 test 4 = 547 test 5 = 550 fin
start...waiting...done
warm
test 0 = 544 test 1 = 546 test 2 = 544 test 3 = 546 test 4 = 544 test 5 = 545 fin
100	True	False	True	0.01	0.33	prepared	545	545	1.0
start...waiting...done
warm
test 0 = 187 test 1 = 188 test 2 = 188 test 3 = 188 test 4 = 187 test 5 = 187 fin
start...waiting...done
warm
test 0 = 188 test 1 = 189 test 2 = 189 test 3 = 189 test 4 = 188 test 5 = 188 fin
100	True	False	True	0.01	0.1	prepared	189	187	0.9894179894179894
start...waiting...done
warm
test 0 = 35 test 1 = 36 test 2 = 35 test 3 = 35 test 4 = 35 test 5 = 35 fin
start...waiting...done
warm
test 0 = 36 test 1 = 36 test 2 = 35 test 3 = 36 test 4 = 35 test 5 = 36 fin
100	True	False	True	0.01	0.01	prepared	36	35	0.9722222222222222
start...waiting...done

Process finished with exit code 0