vanila vs vanilla

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 = 8601 test 1 = 8591 test 2 = 8545 test 3 = 8572 test 4 = 8515 test 5 = 8579 fin
start...waiting...done
warm
test 0 = 8688 test 1 = 8695 test 2 = 8689 test 3 = 8633 test 4 = 8605 test 5 = 8731 fin
10	True	False	True	1.0	1.0	prepared	8674	8567	0.9876642840673276
start...waiting...done
warm
test 0 = 8186 test 1 = 8135 test 2 = 8087 test 3 = 8118 test 4 = 8117 test 5 = 8143 fin
start...waiting...done
warm
test 0 = 8152 test 1 = 8155 test 2 = 8072 test 3 = 8113 test 4 = 7839 test 5 = 7793 fin
10	True	False	True	1.0	0.66	prepared	8021	8131	1.0137140007480363
start...waiting...done
warm
test 0 = 6847 test 1 = 6716 test 2 = 6375 test 3 = 6636 test 4 = 6875 test 5 = 6871 fin
start...waiting...done
warm
test 0 = 6855 test 1 = 6858 test 2 = 6826 test 3 = 6881 test 4 = 6856 test 5 = 6890 fin
10	True	False	True	1.0	0.33	prepared	6861	6720	0.9794490599038042
start...waiting...done
warm
test 0 = 4235 test 1 = 4246 test 2 = 4230 test 3 = 4195 test 4 = 4201 test 5 = 4239 fin
start...waiting...done
warm
test 0 = 4260 test 1 = 4248 test 2 = 4234 test 3 = 4198 test 4 = 4198 test 5 = 4211 fin
10	True	False	True	1.0	0.1	prepared	4225	4224	0.9997633136094675
start...waiting...done
warm
test 0 = 1198 test 1 = 1197 test 2 = 1194 test 3 = 1205 test 4 = 1205 test 5 = 1200 fin
start...waiting...done
warm
test 0 = 1119 test 1 = 1131 test 2 = 1125 test 3 = 1175 test 4 = 1197 test 5 = 1204 fin
10	True	False	True	1.0	0.01	prepared	1159	1200	1.0353753235547887
start...waiting...done
drop init alter update update2 index warm
test 0 = 8446 test 1 = 8418 test 2 = 8122 test 3 = 8121 test 4 = 8398 test 5 = 8216 fin
start...waiting...done
warm
test 0 = 8532 test 1 = 8517 test 2 = 8463 test 3 = 8388 test 4 = 8402 test 5 = 8440 fin
10	True	False	True	0.95	1.0	prepared	8457	8287	0.979898309093059
start...waiting...done
warm
test 0 = 7926 test 1 = 7923 test 2 = 7678 test 3 = 7717 test 4 = 7835 test 5 = 7870 fin
start...waiting...done
warm
test 0 = 7888 test 1 = 7819 test 2 = 7910 test 3 = 7879 test 4 = 7893 test 5 = 7773 fin
10	True	False	True	0.95	0.66	prepared	7860	7825	0.9955470737913485
start...waiting...done
warm
test 0 = 6567 test 1 = 6500 test 2 = 6512 test 3 = 6521 test 4 = 6497 test 5 = 6494 fin
start...waiting...done
warm
test 0 = 6577 test 1 = 6546 test 2 = 6545 test 3 = 6478 test 4 = 6506 test 5 = 6565 fin
10	True	False	True	0.95	0.33	prepared	6536	6515	0.9967870257037944
start...waiting...done
warm
test 0 = 3895 test 1 = 3889 test 2 = 3888 test 3 = 3864 test 4 = 3884 test 5 = 3905 fin
start...waiting...done
warm
test 0 = 3777 test 1 = 3892 test 2 = 3882 test 3 = 3879 test 4 = 3866 test 5 = 3877 fin
10	True	False	True	0.95	0.1	prepared	3862	3888	1.0067322630761264
start...waiting...done
warm
test 0 = 1055 test 1 = 1066 test 2 = 1063 test 3 = 1066 test 4 = 1066 test 5 = 1067 fin
start...waiting...done
warm
test 0 = 1068 test 1 = 1066 test 2 = 1065 test 3 = 1063 test 4 = 1063 test 5 = 1064 fin
10	True	False	True	0.95	0.01	prepared	1065	1064	0.9990610328638497
start...waiting...done
drop init alter update update2 index warm
test 0 = 8297 test 1 = 8272 test 2 = 8240 test 3 = 8264 test 4 = 8268 test 5 = 8269 fin
start...waiting...done
warm
test 0 = 8364 test 1 = 8368 test 2 = 8352 test 3 = 8336 test 4 = 8313 test 5 = 8347 fin
10	True	False	True	0.9	1.0	prepared	8347	8268	0.9905355217443392
start...waiting...done
warm
test 0 = 7755 test 1 = 7745 test 2 = 7718 test 3 = 7716 test 4 = 7704 test 5 = 7703 fin
start...waiting...done
warm
test 0 = 7691 test 1 = 7717 test 2 = 7710 test 3 = 7700 test 4 = 7699 test 5 = 7716 fin
10	True	False	True	0.9	0.66	prepared	7705	7724	1.0024659312134978
start...waiting...done
warm
test 0 = 6260 test 1 = 6299 test 2 = 6292 test 3 = 6243 test 4 = 6211 test 5 = 6234 fin
start...waiting...done
warm
test 0 = 6347 test 1 = 6331 test 2 = 6345 test 3 = 6323 test 4 = 6320 test 5 = 6309 fin
10	True	False	True	0.9	0.33	prepared	6329	6257	0.9886237952283141
start...waiting...done
warm
test 0 = 3679 test 1 = 3681 test 2 = 3663 test 3 = 3652 test 4 = 3640 test 5 = 3659 fin
start...waiting...done
warm
test 0 = 3684 test 1 = 3664 test 2 = 3665 test 3 = 3677 test 4 = 3667 test 5 = 3644 fin
10	True	False	True	0.9	0.1	prepared	3667	3662	0.998636487592037
start...waiting...done
warm
test 0 = 983 test 1 = 983 test 2 = 982 test 3 = 988 test 4 = 990 test 5 = 986 fin
start...waiting...done
warm
test 0 = 984 test 1 = 986 test 2 = 988 test 3 = 986 test 4 = 986 test 5 = 984 fin
10	True	False	True	0.9	0.01	prepared	986	985	0.9989858012170385
start...waiting...done
drop init alter update update2 index warm
test 0 = 8198 test 1 = 8165 test 2 = 8175 test 3 = 8062 test 4 = 8035 test 5 = 8106 fin
start...waiting...done
warm
test 0 = 8062 test 1 = 7927 test 2 = 7980 test 3 = 7902 test 4 = 8105 test 5 = 8093 fin
10	True	False	True	0.85	1.0	prepared	8012	8123	1.013854218671992
start...waiting...done
warm
test 0 = 7503 test 1 = 7524 test 2 = 7516 test 3 = 7555 test 4 = 7539 test 5 = 7550 fin
start...waiting...done
warm
test 0 = 7512 test 1 = 7481 test 2 = 7527 test 3 = 7534 test 4 = 7531 test 5 = 7518 fin
10	True	False	True	0.85	0.66	prepared	7517	7531	1.0018624451243847
start...waiting...done
warm
test 0 = 6103 test 1 = 6032 test 2 = 6031 test 3 = 5956 test 4 = 6020 test 5 = 5990 fin
start...waiting...done
warm
test 0 = 6082 test 1 = 6062 test 2 = 6071 test 3 = 6093 test 4 = 6060 test 5 = 6101 fin
10	True	False	True	0.85	0.33	prepared	6078	6022	0.9907864429088517
start...waiting...done
warm
test 0 = 3456 test 1 = 3444 test 2 = 3377 test 3 = 3356 test 4 = 3384 test 5 = 3398 fin
start...waiting...done
warm
test 0 = 3379 test 1 = 3430 test 2 = 3442 test 3 = 3455 test 4 = 3455 test 5 = 3449 fin
10	True	False	True	0.85	0.1	prepared	3435	3403	0.990684133915575
start...waiting...done
warm
test 0 = 898 test 1 = 897 test 2 = 894 test 3 = 895 test 4 = 898 test 5 = 893 fin
start...waiting...done
warm
test 0 = 877 test 1 = 886 test 2 = 891 test 3 = 891 test 4 = 890 test 5 = 893 fin
10	True	False	True	0.85	0.01	prepared	888	896	1.009009009009009
start...waiting...done
drop init alter update update2 index warm
test 0 = 8043 test 1 = 7978 test 2 = 7935 test 3 = 8007 test 4 = 8020 test 5 = 8012 fin
start...waiting...done
warm
test 0 = 8064 test 1 = 8056 test 2 = 7935 test 3 = 7877 test 4 = 7882 test 5 = 8004 fin
10	True	False	True	0.8	1.0	prepared	7970	7999	1.0036386449184442
start...waiting...done
warm
test 0 = 7265 test 1 = 7349 test 2 = 7347 test 3 = 7281 test 4 = 7100 test 5 = 7155 fin
start...waiting...done
warm
test 0 = 7309 test 1 = 7329 test 2 = 7335 test 3 = 7352 test 4 = 7329 test 5 = 7293 fin
10	True	False	True	0.8	0.66	prepared	7324	7249	0.9897596941561988
start...waiting...done
warm
test 0 = 5781 test 1 = 5869 test 2 = 5830 test 3 = 5802 test 4 = 5885 test 5 = 5892 fin
start...waiting...done
warm
test 0 = 5851 test 1 = 5872 test 2 = 5897 test 3 = 5889 test 4 = 5913 test 5 = 5881 fin
10	True	False	True	0.8	0.33	prepared	5884	5843	0.993031951053705
start...waiting...done
warm
test 0 = 3286 test 1 = 3279 test 2 = 3268 test 3 = 3279 test 4 = 3254 test 5 = 3266 fin
start...waiting...done
warm
test 0 = 3271 test 1 = 3281 test 2 = 3273 test 3 = 3269 test 4 = 3263 test 5 = 3271 fin
10	True	False	True	0.8	0.1	prepared	3271	3272	1.000305716906145
start...waiting...done
warm
test 0 = 848 test 1 = 849 test 2 = 850 test 3 = 850 test 4 = 848 test 5 = 850 fin
start...waiting...done
warm
test 0 = 850 test 1 = 852 test 2 = 850 test 3 = 850 test 4 = 851 test 5 = 847 fin
10	True	False	True	0.8	0.01	prepared	850	849	0.9988235294117647
start...waiting...done
drop init alter update update2 index warm
test 0 = 7878 test 1 = 7853 test 2 = 7877 test 3 = 7890 test 4 = 7893 test 5 = 7899 fin
start...waiting...done
warm
test 0 = 7949 test 1 = 7921 test 2 = 7899 test 3 = 7911 test 4 = 7928 test 5 = 7929 fin
10	True	False	True	0.75	1.0	prepared	7923	7882	0.9948251924775968
start...waiting...done
warm
test 0 = 7126 test 1 = 7192 test 2 = 7121 test 3 = 7197 test 4 = 7186 test 5 = 7170 fin
start...waiting...done
warm
test 0 = 7173 test 1 = 7162 test 2 = 7145 test 3 = 7179 test 4 = 7192 test 5 = 7203 fin
10	True	False	True	0.75	0.66	prepared	7176	7165	0.9984671125975474
start...waiting...done
warm
test 0 = 5649 test 1 = 5663 test 2 = 5648 test 3 = 5697 test 4 = 5699 test 5 = 5694 fin
start...waiting...done
warm
test 0 = 5680 test 1 = 5669 test 2 = 5678 test 3 = 5721 test 4 = 5718 test 5 = 5691 fin
10	True	False	True	0.75	0.33	prepared	5693	5675	0.9968382223783594
start...waiting...done
warm
test 0 = 3108 test 1 = 3088 test 2 = 3079 test 3 = 3105 test 4 = 3108 test 5 = 3111 fin
start...waiting...done
warm
test 0 = 3101 test 1 = 3105 test 2 = 3100 test 3 = 3082 test 4 = 3080 test 5 = 3080 fin
10	True	False	True	0.75	0.1	prepared	3091	3100	1.0029116790682626
start...waiting...done
warm
test 0 = 777 test 1 = 780 test 2 = 779 test 3 = 780 test 4 = 779 test 5 = 777 fin
start...waiting...done
warm
test 0 = 780 test 1 = 780 test 2 = 774 test 3 = 779 test 4 = 776 test 5 = 778 fin
10	True	False	True	0.75	0.01	prepared	778	778	1.0
start...waiting...done
drop init alter update update2 index warm
test 0 = 7254 test 1 = 7266 test 2 = 7278 test 3 = 7288 test 4 = 7285 test 5 = 7272 fin
start...waiting...done
warm
test 0 = 7279 test 1 = 7293 test 2 = 7262 test 3 = 7323 test 4 = 7309 test 5 = 7259 fin
10	True	False	True	0.5	1.0	prepared	7287	7274	0.9982160010978455
start...waiting...done
warm
test 0 = 6541 test 1 = 6514 test 2 = 6488 test 3 = 6514 test 4 = 6499 test 5 = 6495 fin
start...waiting...done
warm
test 0 = 6495 test 1 = 6494 test 2 = 6521 test 3 = 6516 test 4 = 6508 test 5 = 6530 fin
10	True	False	True	0.5	0.66	prepared	6511	6509	0.999692827522654
start...waiting...done
warm
test 0 = 5042 test 1 = 4993 test 2 = 4985 test 3 = 5026 test 4 = 4952 test 5 = 5006 fin
start...waiting...done
warm
test 0 = 4989 test 1 = 4910 test 2 = 5009 test 3 = 5027 test 4 = 5000 test 5 = 4817 fin
10	True	False	True	0.5	0.33	prepared	4959	5000	1.0082677959265982
start...waiting...done
warm
test 0 = 2564 test 1 = 2563 test 2 = 2560 test 3 = 2539 test 4 = 2572 test 5 = 2568 fin
start...waiting...done
warm
test 0 = 2534 test 1 = 2551 test 2 = 2558 test 3 = 2588 test 4 = 2594 test 5 = 2533 fin
10	True	False	True	0.5	0.1	prepared	2560	2561	1.000390625
start...waiting...done
warm
test 0 = 624 test 1 = 623 test 2 = 615 test 3 = 623 test 4 = 626 test 5 = 623 fin
start...waiting...done
warm
test 0 = 625 test 1 = 625 test 2 = 622 test 3 = 621 test 4 = 623 test 5 = 624 fin
10	True	False	True	0.5	0.01	prepared	623	622	0.9983948635634029
start...waiting...done
drop init alter update update2 index warm
test 0 = 6724 test 1 = 6603 test 2 = 6726 test 3 = 6760 test 4 = 6729 test 5 = 6652 fin
start...waiting...done
warm
test 0 = 6713 test 1 = 6729 test 2 = 6713 test 3 = 6726 test 4 = 6737 test 5 = 6736 fin
10	True	False	True	0.25	1.0	prepared	6726	6699	0.995985727029438
start...waiting...done
warm
test 0 = 5999 test 1 = 6008 test 2 = 5989 test 3 = 6007 test 4 = 6013 test 5 = 5893 fin
start...waiting...done
warm
test 0 = 5988 test 1 = 6002 test 2 = 5995 test 3 = 5985 test 4 = 6008 test 5 = 6014 fin
10	True	False	True	0.25	0.66	prepared	5999	5985	0.9976662777129521
start...waiting...done
warm
test 0 = 4590 test 1 = 4569 test 2 = 4563 test 3 = 4560 test 4 = 4582 test 5 = 4590 fin
start...waiting...done
warm
test 0 = 4536 test 1 = 4583 test 2 = 4574 test 3 = 4578 test 4 = 4569 test 5 = 4402 fin
10	True	False	True	0.25	0.33	prepared	4540	4576	1.0079295154185022
start...waiting...done
warm
test 0 = 2287 test 1 = 2281 test 2 = 2236 test 3 = 2237 test 4 = 2239 test 5 = 2235 fin
start...waiting...done
warm
test 0 = 2243 test 1 = 2217 test 2 = 2264 test 3 = 2250 test 4 = 2242 test 5 = 2240 fin
10	True	False	True	0.25	0.1	prepared	2243	2252	1.0040124832813198
start...waiting...done
warm
test 0 = 528 test 1 = 532 test 2 = 530 test 3 = 536 test 4 = 536 test 5 = 535 fin
start...waiting...done
warm
test 0 = 536 test 1 = 538 test 2 = 533 test 3 = 530 test 4 = 526 test 5 = 537 fin
10	True	False	True	0.25	0.01	prepared	533	533	1.0
start...waiting...done
drop init alter update update2 index warm
test 0 = 5863 test 1 = 5717 test 2 = 5924 test 3 = 5927 test 4 = 5906 test 5 = 5916 fin
start...waiting...done
warm
test 0 = 5947 test 1 = 5923 test 2 = 5888 test 3 = 5914 test 4 = 5925 test 5 = 5945 fin
10	True	False	True	0.1	1.0	prepared	5924	5876	0.9918973666441594
start...waiting...done
warm
test 0 = 5378 test 1 = 5411 test 2 = 5397 test 3 = 5457 test 4 = 5459 test 5 = 5448 fin
start...waiting...done
warm
test 0 = 5422 test 1 = 5418 test 2 = 5398 test 3 = 5463 test 4 = 5478 test 5 = 5461 fin
10	True	False	True	0.1	0.66	prepared	5440	5425	0.9972426470588235
start...waiting...done
warm
test 0 = 4294 test 1 = 4297 test 2 = 4272 test 3 = 4291 test 4 = 4289 test 5 = 4301 fin
start...waiting...done
warm
test 0 = 4227 test 1 = 4293 test 2 = 4293 test 3 = 4277 test 4 = 4279 test 5 = 4267 fin
10	True	False	True	0.1	0.33	prepared	4273	4291	1.0042124970746549
start...waiting...done
warm
test 0 = 2159 test 1 = 2133 test 2 = 2122 test 3 = 2122 test 4 = 2129 test 5 = 2157 fin
start...waiting...done
warm
test 0 = 2198 test 1 = 2204 test 2 = 2193 test 3 = 2179 test 4 = 2189 test 5 = 2191 fin
10	True	False	True	0.1	0.1	prepared	2192	2137	0.9749087591240876
start...waiting...done
warm
test 0 = 522 test 1 = 522 test 2 = 521 test 3 = 523 test 4 = 525 test 5 = 524 fin
start...waiting...done
warm
test 0 = 522 test 1 = 522 test 2 = 523 test 3 = 519 test 4 = 523 test 5 = 525 fin
10	True	False	True	0.1	0.01	prepared	522	523	1.0019157088122606
start...waiting...done
drop init alter update update2 index warm
test 0 = 5524 test 1 = 5406 test 2 = 5538 test 3 = 5519 test 4 = 5515 test 5 = 5527 fin
start...waiting...done
warm
test 0 = 5492 test 1 = 5513 test 2 = 5501 test 3 = 5545 test 4 = 5547 test 5 = 5535 fin
10	True	False	True	0.01	1.0	prepared	5522	5505	0.9969214052879392
start...waiting...done
warm
test 0 = 4855 test 1 = 4845 test 2 = 4828 test 3 = 4833 test 4 = 4859 test 5 = 4836 fin
start...waiting...done
warm
test 0 = 4848 test 1 = 4834 test 2 = 4834 test 3 = 4842 test 4 = 4847 test 5 = 4855 fin
10	True	False	True	0.01	0.66	prepared	4843	4843	1.0
start...waiting...done
warm
test 0 = 3641 test 1 = 3642 test 2 = 3615 test 3 = 3622 test 4 = 3622 test 5 = 3600 fin
start...waiting...done
warm
test 0 = 3627 test 1 = 3643 test 2 = 3620 test 3 = 3612 test 4 = 3630 test 5 = 3615 fin
10	True	False	True	0.01	0.33	prepared	3624	3624	1.0
start...waiting...done
warm
test 0 = 1798 test 1 = 1788 test 2 = 1789 test 3 = 1792 test 4 = 1795 test 5 = 1786 fin
start...waiting...done
warm
test 0 = 1809 test 1 = 1820 test 2 = 1809 test 3 = 1815 test 4 = 1806 test 5 = 1809 fin
10	True	False	True	0.01	0.1	prepared	1811	1791	0.9889563776918829
start...waiting...done
warm
test 0 = 464 test 1 = 460 test 2 = 465 test 3 = 465 test 4 = 463 test 5 = 465 fin
start...waiting...done
warm
test 0 = 465 test 1 = 464 test 2 = 459 test 3 = 462 test 4 = 462 test 5 = 465 fin
10	True	False	True	0.01	0.01	prepared	463	464	1.0021598272138228
start...waiting...done
drop init alter update update2 index warm
test 0 = 7038 test 1 = 7030 test 2 = 7028 test 3 = 7034 test 4 = 7017 test 5 = 7037 fin
start...waiting...done
warm
test 0 = 7043 test 1 = 7028 test 2 = 7035 test 3 = 7005 test 4 = 6974 test 5 = 6952 fin
100	True	False	True	1.0	1.0	prepared	7006	7031	1.0035683699685984
start...waiting...done
warm
test 0 = 6537 test 1 = 6499 test 2 = 6495 test 3 = 6548 test 4 = 6560 test 5 = 6550 fin
start...waiting...done
warm
test 0 = 6529 test 1 = 6549 test 2 = 6542 test 3 = 6522 test 4 = 6546 test 5 = 6537 fin
100	True	False	True	1.0	0.66	prepared	6537	6531	0.9990821477742083
start...waiting...done
warm
test 0 = 5472 test 1 = 5474 test 2 = 5452 test 3 = 5481 test 4 = 5479 test 5 = 5481 fin
start...waiting...done
warm
test 0 = 5415 test 1 = 5485 test 2 = 5457 test 3 = 5480 test 4 = 5452 test 5 = 5466 fin
100	True	False	True	1.0	0.33	prepared	5459	5473	1.0025645722659828
start...waiting...done
warm
test 0 = 3284 test 1 = 3265 test 2 = 3268 test 3 = 3269 test 4 = 3273 test 5 = 3271 fin
start...waiting...done
warm
test 0 = 3275 test 1 = 3282 test 2 = 3274 test 3 = 3287 test 4 = 3291 test 5 = 3274 fin
100	True	False	True	1.0	0.1	prepared	3281	3272	0.9972569338616275
start...waiting...done
warm
test 0 = 898 test 1 = 900 test 2 = 897 test 3 = 900 test 4 = 904 test 5 = 903 fin
start...waiting...done
warm
test 0 = 898 test 1 = 898 test 2 = 902 test 3 = 896 test 4 = 895 test 5 = 894 fin
100	True	False	True	1.0	0.01	prepared	897	900	1.0033444816053512
start...waiting...done
drop init alter update update2 index warm
test 0 = 6306 test 1 = 6306 test 2 = 6271 test 3 = 6304 test 4 = 6316 test 5 = 6323 fin
start...waiting...done
warm
test 0 = 6299 test 1 = 6299 test 2 = 6223 test 3 = 6228 test 4 = 6243 test 5 = 6278 fin
100	True	False	True	0.95	1.0	prepared	6262	6304	1.0067071223251358
start...waiting...done
warm
test 0 = 5751 test 1 = 5718 test 2 = 5734 test 3 = 5766 test 4 = 5736 test 5 = 5752 fin
start...waiting...done
warm
test 0 = 5731 test 1 = 5733 test 2 = 5685 test 3 = 5725 test 4 = 5730 test 5 = 5754 fin
100	True	False	True	0.95	0.66	prepared	5726	5743	1.00296891372686
start...waiting...done
warm
test 0 = 4625 test 1 = 4640 test 2 = 4622 test 3 = 4625 test 4 = 4629 test 5 = 4626 fin
start...waiting...done
warm
test 0 = 4634 test 1 = 4639 test 2 = 4628 test 3 = 4630 test 4 = 4622 test 5 = 4633 fin
100	True	False	True	0.95	0.33	prepared	4631	4628	0.9993521917512417
start...waiting...done
warm
test 0 = 2580 test 1 = 2575 test 2 = 2576 test 3 = 2554 test 4 = 2548 test 5 = 2560 fin
start...waiting...done
warm
test 0 = 2556 test 1 = 2553 test 2 = 2555 test 3 = 2577 test 4 = 2580 test 5 = 2589 fin
100	True	False	True	0.95	0.1	prepared	2568	2566	0.9992211838006231
start...waiting...done
warm
test 0 = 664 test 1 = 669 test 2 = 665 test 3 = 668 test 4 = 669 test 5 = 666 fin
start...waiting...done
warm
test 0 = 667 test 1 = 668 test 2 = 665 test 3 = 667 test 4 = 665 test 5 = 667 fin
100	True	False	True	0.95	0.01	prepared	666	667	1.0015015015015014
start...waiting...done
drop init alter update update2 index warm
test 0 = 5453 test 1 = 5426 test 2 = 5460 test 3 = 5446 test 4 = 5464 test 5 = 5453 fin
start...waiting...done
warm
test 0 = 5446 test 1 = 5441 test 2 = 5428 test 3 = 5417 test 4 = 5453 test 5 = 5444 fin
100	True	False	True	0.9	1.0	prepared	5438	5450	1.0022066936373666
start...waiting...done
warm
test 0 = 4793 test 1 = 4791 test 2 = 4763 test 3 = 4784 test 4 = 4789 test 5 = 4793 fin
start...waiting...done
warm
test 0 = 4755 test 1 = 4690 test 2 = 4723 test 3 = 4781 test 4 = 4720 test 5 = 4737 fin
100	True	False	True	0.9	0.66	prepared	4734	4785	1.0107731305449936
start...waiting...done
warm
test 0 = 3557 test 1 = 3559 test 2 = 3549 test 3 = 3549 test 4 = 3547 test 5 = 3533 fin
start...waiting...done
warm
test 0 = 3560 test 1 = 3561 test 2 = 3546 test 3 = 3553 test 4 = 3556 test 5 = 3555 fin
100	True	False	True	0.9	0.33	prepared	3555	3549	0.9983122362869198
start...waiting...done
warm
test 0 = 1698 test 1 = 1699 test 2 = 1693 test 3 = 1686 test 4 = 1685 test 5 = 1685 fin
start...waiting...done
warm
test 0 = 1695 test 1 = 1696 test 2 = 1698 test 3 = 1689 test 4 = 1687 test 5 = 1696 fin
100	True	False	True	0.9	0.1	prepared	1694	1691	0.9982290436835891
start...waiting...done
warm
test 0 = 397 test 1 = 397 test 2 = 397 test 3 = 397 test 4 = 397 test 5 = 398 fin
start...waiting...done
warm
test 0 = 396 test 1 = 396 test 2 = 395 test 3 = 395 test 4 = 395 test 5 = 394 fin
100	True	False	True	0.9	0.01	prepared	395	397	1.0050632911392405
start...waiting...done
drop init alter update update2 index warm
test 0 = 4758 test 1 = 4716 test 2 = 4769 test 3 = 4753 test 4 = 4765 test 5 = 4761 fin
start...waiting...done
warm
test 0 = 4759 test 1 = 4769 test 2 = 4754 test 3 = 4743 test 4 = 4754 test 5 = 4739 fin
100	True	False	True	0.85	1.0	prepared	4753	4754	1.0002103934357247
start...waiting...done
warm
test 0 = 3969 test 1 = 4011 test 2 = 4015 test 3 = 4035 test 4 = 4030 test 5 = 4011 fin
start...waiting...done
warm
test 0 = 4034 test 1 = 4053 test 2 = 4024 test 3 = 4035 test 4 = 4036 test 5 = 4037 fin
100	True	False	True	0.85	0.66	prepared	4036	4012	0.9940535183349851
start...waiting...done
warm
test 0 = 2794 test 1 = 2780 test 2 = 2774 test 3 = 2787 test 4 = 2804 test 5 = 2771 fin
start...waiting...done
warm
test 0 = 2788 test 1 = 2801 test 2 = 2787 test 3 = 2785 test 4 = 2770 test 5 = 2772 fin
100	True	False	True	0.85	0.33	prepared	2784	2785	1.0003591954022988
start...waiting...done
warm
test 0 = 1236 test 1 = 1235 test 2 = 1228 test 3 = 1236 test 4 = 1235 test 5 = 1232 fin
start...waiting...done
warm
test 0 = 1229 test 1 = 1231 test 2 = 1231 test 3 = 1220 test 4 = 1223 test 5 = 1232 fin
100	True	False	True	0.85	0.1	prepared	1228	1234	1.004885993485342
start...waiting...done
warm
test 0 = 269 test 1 = 271 test 2 = 269 test 3 = 270 test 4 = 270 test 5 = 268 fin
start...waiting...done
warm
test 0 = 268 test 1 = 268 test 2 = 267 test 3 = 268 test 4 = 269 test 5 = 267 fin
100	True	False	True	0.85	0.01	prepared	268	269	1.0037313432835822
start...waiting...done
drop init alter update update2 index warm
test 0 = 4217 test 1 = 4198 test 2 = 4140 test 3 = 4195 test 4 = 4205 test 5 = 4226 fin
start...waiting...done
warm
test 0 = 4197 test 1 = 4188 test 2 = 4187 test 3 = 4195 test 4 = 4169 test 5 = 4172 fin
100	True	False	True	0.8	1.0	prepared	4185	4197	1.0028673835125448
start...waiting...done
warm
test 0 = 3441 test 1 = 3457 test 2 = 3449 test 3 = 3441 test 4 = 3454 test 5 = 3461 fin
start...waiting...done
warm
test 0 = 3445 test 1 = 3440 test 2 = 3443 test 3 = 3383 test 4 = 3413 test 5 = 3368 fin
100	True	False	True	0.8	0.66	prepared	3415	3451	1.0105417276720352
start...waiting...done
warm
test 0 = 2278 test 1 = 2274 test 2 = 2273 test 3 = 2247 test 4 = 2246 test 5 = 2248 fin
start...waiting...done
warm
test 0 = 2232 test 1 = 2236 test 2 = 2238 test 3 = 2271 test 4 = 2241 test 5 = 2268 fin
100	True	False	True	0.8	0.33	prepared	2248	2261	1.0057829181494662
start...waiting...done
warm
test 0 = 953 test 1 = 941 test 2 = 942 test 3 = 942 test 4 = 944 test 5 = 942 fin
start...waiting...done
warm
test 0 = 938 test 1 = 936 test 2 = 929 test 3 = 940 test 4 = 945 test 5 = 936 fin
100	True	False	True	0.8	0.1	prepared	937	944	1.007470651013874
start...waiting...done
warm
test 0 = 196 test 1 = 199 test 2 = 196 test 3 = 198 test 4 = 199 test 5 = 198 fin
start...waiting...done
warm
test 0 = 197 test 1 = 196 test 2 = 196 test 3 = 193 test 4 = 195 test 5 = 195 fin
100	True	False	True	0.8	0.01	prepared	195	198	1.0153846153846153
start...waiting...done
drop init alter update update2 index warm
test 0 = 3722 test 1 = 3693 test 2 = 3732 test 3 = 3722 test 4 = 3738 test 5 = 3731 fin
start...waiting...done
warm
test 0 = 3738 test 1 = 3722 test 2 = 3713 test 3 = 3740 test 4 = 3699 test 5 = 3723 fin
100	True	False	True	0.75	1.0	prepared	3723	3723	1.0
start...waiting...done
warm
test 0 = 3016 test 1 = 3006 test 2 = 3012 test 3 = 2965 test 4 = 3011 test 5 = 2980 fin
start...waiting...done
warm
test 0 = 2984 test 1 = 2968 test 2 = 2974 test 3 = 2872 test 4 = 2946 test 5 = 2977 fin
100	True	False	True	0.75	0.66	prepared	2953	2998	1.015238740264138
start...waiting...done
warm
test 0 = 1870 test 1 = 1866 test 2 = 1861 test 3 = 1882 test 4 = 1881 test 5 = 1889 fin
start...waiting...done
warm
test 0 = 1861 test 1 = 1857 test 2 = 1862 test 3 = 1867 test 4 = 1885 test 5 = 1860 fin
100	True	False	True	0.75	0.33	prepared	1865	1875	1.0053619302949062
start...waiting...done
warm
test 0 = 761 test 1 = 758 test 2 = 760 test 3 = 759 test 4 = 760 test 5 = 751 fin
start...waiting...done
warm
test 0 = 761 test 1 = 759 test 2 = 753 test 3 = 758 test 4 = 760 test 5 = 759 fin
100	True	False	True	0.75	0.1	prepared	758	758	1.0
start...waiting...done
warm
test 0 = 155 test 1 = 156 test 2 = 155 test 3 = 156 test 4 = 155 test 5 = 156 fin
start...waiting...done
warm
test 0 = 155 test 1 = 155 test 2 = 156 test 3 = 155 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 = 2311 test 1 = 2368 test 2 = 2373 test 3 = 2369 test 4 = 2365 test 5 = 2367 fin
start...waiting...done
warm
test 0 = 2340 test 1 = 2348 test 2 = 2323 test 3 = 2354 test 4 = 2332 test 5 = 2340 fin
100	True	False	True	0.5	1.0	prepared	2339	2359	1.0085506626763574
start...waiting...done
warm
test 0 = 1749 test 1 = 1749 test 2 = 1736 test 3 = 1754 test 4 = 1764 test 5 = 1752 fin
start...waiting...done
warm
test 0 = 1745 test 1 = 1751 test 2 = 1744 test 3 = 1760 test 4 = 1767 test 5 = 1772 fin
100	True	False	True	0.5	0.66	prepared	1757	1751	0.9965850882185544
start...waiting...done
warm
test 0 = 1035 test 1 = 1036 test 2 = 1034 test 3 = 1029 test 4 = 1029 test 5 = 1032 fin
start...waiting...done
warm
test 0 = 1036 test 1 = 1032 test 2 = 1034 test 3 = 1029 test 4 = 1033 test 5 = 1031 fin
100	True	False	True	0.5	0.33	prepared	1033	1033	1.0
start...waiting...done
warm
test 0 = 373 test 1 = 375 test 2 = 377 test 3 = 375 test 4 = 375 test 5 = 375 fin
start...waiting...done
warm
test 0 = 376 test 1 = 376 test 2 = 375 test 3 = 374 test 4 = 375 test 5 = 377 fin
100	True	False	True	0.5	0.1	prepared	376	375	0.9973404255319149
start...waiting...done
warm
test 0 = 74 test 1 = 75 test 2 = 74 test 3 = 73 test 4 = 73 test 5 = 74 fin
start...waiting...done
warm
test 0 = 73 test 1 = 74 test 2 = 72 test 3 = 74 test 4 = 74 test 5 = 74 fin
100	True	False	True	0.5	0.01	prepared	73	74	1.0136986301369864
start...waiting...done
drop init alter update update2 index warm
test 0 = 1717 test 1 = 1711 test 2 = 1714 test 3 = 1726 test 4 = 1715 test 5 = 1698 fin
start...waiting...done
warm
test 0 = 1701 test 1 = 1699 test 2 = 1707 test 3 = 1703 test 4 = 1709 test 5 = 1706 fin
100	True	False	True	0.25	1.0	prepared	1704	1713	1.005281690140845
start...waiting...done
warm
test 0 = 1255 test 1 = 1255 test 2 = 1258 test 3 = 1262 test 4 = 1261 test 5 = 1256 fin
start...waiting...done
warm
test 0 = 1256 test 1 = 1251 test 2 = 1255 test 3 = 1256 test 4 = 1256 test 5 = 1258 fin
100	True	False	True	0.25	0.66	prepared	1255	1258	1.002390438247012
start...waiting...done
warm
test 0 = 709 test 1 = 710 test 2 = 708 test 3 = 706 test 4 = 706 test 5 = 704 fin
start...waiting...done
warm
test 0 = 705 test 1 = 705 test 2 = 703 test 3 = 707 test 4 = 708 test 5 = 706 fin
100	True	False	True	0.25	0.33	prepared	706	707	1.001416430594901
start...waiting...done
warm
test 0 = 248 test 1 = 248 test 2 = 247 test 3 = 248 test 4 = 249 test 5 = 249 fin
start...waiting...done
warm
test 0 = 247 test 1 = 248 test 2 = 246 test 3 = 249 test 4 = 246 test 5 = 248 fin
100	True	False	True	0.25	0.1	prepared	247	248	1.0040485829959513
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 = 1484 test 1 = 1488 test 2 = 1488 test 3 = 1486 test 4 = 1484 test 5 = 1481 fin
start...waiting...done
warm
test 0 = 1466 test 1 = 1477 test 2 = 1469 test 3 = 1471 test 4 = 1468 test 5 = 1463 fin
100	True	False	True	0.1	1.0	prepared	1469	1485	1.0108917631041525
start...waiting...done
warm
test 0 = 1080 test 1 = 1073 test 2 = 1075 test 3 = 1065 test 4 = 1079 test 5 = 1073 fin
start...waiting...done
warm
test 0 = 1068 test 1 = 1075 test 2 = 1071 test 3 = 1072 test 4 = 1072 test 5 = 1072 fin
100	True	False	True	0.1	0.66	prepared	1072	1074	1.001865671641791
start...waiting...done
warm
test 0 = 594 test 1 = 594 test 2 = 595 test 3 = 601 test 4 = 598 test 5 = 596 fin
start...waiting...done
warm
test 0 = 592 test 1 = 594 test 2 = 592 test 3 = 597 test 4 = 593 test 5 = 592 fin
100	True	False	True	0.1	0.33	prepared	593	596	1.0050590219224282
start...waiting...done
warm
test 0 = 207 test 1 = 208 test 2 = 208 test 3 = 207 test 4 = 206 test 5 = 205 fin
start...waiting...done
warm
test 0 = 206 test 1 = 206 test 2 = 206 test 3 = 206 test 4 = 206 test 5 = 206 fin
100	True	False	True	0.1	0.1	prepared	206	207	1.0048543689320388
start...waiting...done
warm
test 0 = 39 test 1 = 40 test 2 = 40 test 3 = 39 test 4 = 39 test 5 = 39 fin
start...waiting...done
warm
test 0 = 39 test 1 = 39 test 2 = 39 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 = 1390 test 1 = 1387 test 2 = 1377 test 3 = 1389 test 4 = 1399 test 5 = 1384 fin
start...waiting...done
warm
test 0 = 1374 test 1 = 1391 test 2 = 1378 test 3 = 1392 test 4 = 1391 test 5 = 1393 fin
100	True	False	True	0.01	1.0	prepared	1387	1388	1.0007209805335255
start...waiting...done
warm
test 0 = 1001 test 1 = 999 test 2 = 998 test 3 = 997 test 4 = 997 test 5 = 993 fin
start...waiting...done
warm
test 0 = 997 test 1 = 997 test 2 = 999 test 3 = 996 test 4 = 993 test 5 = 999 fin
100	True	False	True	0.01	0.66	prepared	997	998	1.0010030090270812
start...waiting...done
warm
test 0 = 547 test 1 = 542 test 2 = 545 test 3 = 546 test 4 = 546 test 5 = 547 fin
start...waiting...done
warm
test 0 = 545 test 1 = 547 test 2 = 547 test 3 = 542 test 4 = 545 test 5 = 545 fin
100	True	False	True	0.01	0.33	prepared	545	546	1.001834862385321
start...waiting...done
warm
test 0 = 189 test 1 = 188 test 2 = 188 test 3 = 189 test 4 = 189 test 5 = 187 fin
start...waiting...done
warm
test 0 = 188 test 1 = 189 test 2 = 189 test 3 = 188 test 4 = 187 test 5 = 188 fin
100	True	False	True	0.01	0.1	prepared	188	188	1.0
start...waiting...done
warm
test 0 = 36 test 1 = 35 test 2 = 35 test 3 = 36 test 4 = 36 test 5 = 36 fin
start...waiting...done
warm
test 0 = 35 test 1 = 36 test 2 = 36 test 3 = 35 test 4 = 35 test 5 = 36 fin
100	True	False	True	0.01	0.01	prepared	36	36	1.0
start...waiting...done

Process finished with exit code 0