Skip to content

Instantly share code, notes, and snippets.

@michail-nikolaev

michail-nikolaev/gist:5621e66b783abd07e349c96bbad6f9a9

Created September 24, 2018 07:59
Show Gist options
  • Save michail-nikolaev/5621e66b783abd07e349c96bbad6f9a9 to your computer and use it in GitHub Desktop.
Save michail-nikolaev/5621e66b783abd07e349c96bbad6f9a9 to your computer and use it in GitHub Desktop.
Download ZIP
O2 compare
Raw
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
drop init alter update update2 index done
10 True True True 1.0 1.0 simple 16084.824297 15388.997799 0.9567401865788625
10 True True True 1.0 0.75 simple 15370.750825000001 14833.028435 0.9650165176625326
10 True True True 1.0 0.5 simple 14791.773803 14404.691221000001 0.9738312262508035
10 True True True 1.0 0.25 simple 12808.263731 12850.738076000001 1.0033161672723214
10 True True True 1.0 0.1 simple 9411.683004 10041.923368 1.0669636199744663
10 True True True 1.0 0.01 simple 3116.8491840000006 4165.333495 1.3363923786823813
drop init alter update update2 index done
10 True True True 0.95 1.0 simple 15686.048263 15121.686254 0.9640214029985354
10 True True True 0.95 0.75 simple 15521.622495 14981.945773 0.9652306501994977
10 True True True 0.95 0.5 simple 14558.028136 14350.151215000002 0.9857208051078052
10 True True True 0.95 0.25 simple 12390.817909999998 12679.962578 1.0233353980423399
10 True True True 0.95 0.1 simple 8888.411530000001 9995.006569 1.1244986278217473
10 True True True 0.95 0.01 simple 2867.23931 4184.612235 1.4594569139748574
drop init alter update update2 index done
10 True True True 0.9 1.0 simple 15557.119738000001 14880.437369 0.9565033643504633
10 True True True 0.9 0.75 simple 15082.513271 14605.378003999998 0.9683650026738305
10 True True True 0.9 0.5 simple 14303.231083 14106.918405 0.9862749418742646
10 True True True 0.9 0.25 simple 12178.338947 12744.373964999999 1.0464788359449821
10 True True True 0.9 0.1 simple 8510.874616000001 9892.785452 1.1623700146401028
10 True True True 0.9 0.01 simple 2697.975965 4174.040315 1.5471006299346333
drop init alter update update2 index done
10 True True True 0.85 1.0 simple 15569.957091 14842.315319 0.9532662956135823
10 True True True 0.85 0.75 simple 15018.373483 14568.953726 0.9700753375517849
10 True True True 0.85 0.5 simple 13922.958132 13845.628108 0.9944458624907974
10 True True True 0.85 0.25 simple 11827.070628 12542.536257000002 1.0604939000961213
10 True True True 0.85 0.1 simple 8202.302264 9811.895423 1.1962367524621134
10 True True True 0.85 0.01 simple 2548.7943219999997 4189.275339 1.6436302069728168
drop init alter update update2 index done
10 True True True 0.8 1.0 simple 15387.060514 14642.158261 0.9515890476727347
10 True True True 0.8 0.75 simple 14724.380772999999 14283.532476 0.9700599771361266
10 True True True 0.8 0.5 simple 13788.151575 13781.255717 0.9994998707431891
10 True True True 0.8 0.25 simple 11518.789667000001 12393.091487000002 1.0759022297720024
10 True True True 0.8 0.1 simple 7974.965802000001 9801.605802 1.229046750212008
10 True True True 0.8 0.01 simple 2360.420846 4164.252163 1.7641990283456428
drop init alter update update2 index done
10 True True True 0.75 1.0 simple 15280.925534 14636.985245 0.9578598634246835
10 True True True 0.75 0.75 simple 14719.608067000001 14350.630587 0.9749329276757569
10 True True True 0.75 0.5 simple 13758.337107 13798.387093999998 1.0029109613093883
10 True True True 0.75 0.25 simple 11392.842059 12446.534717 1.092487252306602
10 True True True 0.75 0.1 simple 7633.388717 9726.633501 1.2742222178910165
10 True True True 0.75 0.01 simple 2285.642591 4181.552272000001 1.8294865034740688
drop init alter update update2 index done
10 True True True 0.5 1.0 simple 14533.848849000002 13883.420095000001 0.9552473153699577
10 True True True 0.5 0.75 simple 13821.268035000001 13586.870939 0.9830408400006114
10 True True True 0.5 0.5 simple 12710.277393 13123.525413 1.0325129033161455
10 True True True 0.5 0.25 simple 10228.795295 11840.162486000001 1.1575324507459508
10 True True True 0.5 0.1 simple 6584.555678000001 9401.323518000001 1.4277840415885994
10 True True True 0.5 0.01 simple 1882.6308700000002 4165.949008 2.2128336862977283
drop init alter update update2 index done
10 True True True 0.25 1.0 simple 13799.461963 13127.741914000002 0.9513227362921064
10 True True True 0.25 0.75 simple 13184.865113 12995.237637000002 0.9856177917350835
10 True True True 0.25 0.5 simple 11956.930143000001 12526.330076000002 1.0476209132436345
10 True True True 0.25 0.25 simple 9302.828306 11245.801825999999 1.2088583660892516
10 True True True 0.25 0.1 simple 6017.270292 8968.944789000001 1.4905338058229278
10 True True True 0.25 0.01 simple 1673.879446 4155.850472 2.482765698528089
drop init alter update update2 index done
10 True True True 0.1 1.0 simple 12722.977638 12122.742237 0.9528227260883283
10 True True True 0.1 0.75 simple 12225.371740999999 11863.229148999999 0.9703777848500517
10 True True True 0.1 0.5 simple 11466.05985 11483.603726 1.001530070157448
10 True True True 0.1 0.25 simple 9098.29345 10433.735478999999 1.1467793972945552
10 True True True 0.1 0.1 simple 5747.19453 8607.106069999998 1.497618712064023
10 True True True 0.1 0.01 simple 1594.253608 4177.1796300000005 2.620147515451005
drop init alter update update2 index done
10 True True True 0.01 1.0 simple 11879.087545 11408.838660000001 0.9604137200590015
10 True True True 0.01 0.75 simple 11172.652648 11188.736003 1.0014395287768012
10 True True True 0.01 0.5 simple 9960.317938 10904.863754999998 1.0948308902265484
10 True True True 0.01 0.25 simple 7620.275763000001 10091.948774 1.3243547986807942
10 True True True 0.01 0.1 simple 4809.831908 8396.359531 1.745665896771709
10 True True True 0.01 0.01 simple 1389.368936 4140.492346 2.9801244570218315
drop init alter update update2 index done
100 True True True 1.0 1.0 simple 13854.80693 13339.378968 0.9627978964554218
100 True True True 1.0 0.75 simple 13520.391104 13050.34338 0.9652341622084485
100 True True True 1.0 0.5 simple 12655.04848 12339.381696 0.9750560588923165
100 True True True 1.0 0.25 simple 10755.826272999999 10787.831118 1.0029755821810122
100 True True True 1.0 0.1 simple 7575.526748 7921.140697999999 1.045622431481909
100 True True True 1.0 0.01 simple 2400.0214659999997 2930.811887 1.2211606973185298
drop init alter update update2 index done
100 True True True 0.95 1.0 simple 12825.716807 12298.298422 0.958878057816453
100 True True True 0.95 0.75 simple 12263.643185 11883.244603 0.9689816006335477
100 True True True 0.95 0.5 simple 11353.901922000001 11173.236103 0.984087777026686
100 True True True 0.95 0.25 simple 9273.249956 9823.751444 1.059364461285098
100 True True True 0.95 0.1 simple 6176.11492 7207.04098 1.1669214503541006
100 True True True 0.95 0.01 simple 1826.218037 2788.406822 1.5268750858362043
drop init alter update update2 index done
100 True True True 0.9 1.0 simple 11475.806453000001 10957.131535 0.9548027478396162
100 True True True 0.9 0.75 simple 10745.145401 10677.760607 0.9937288150615693
100 True True True 0.9 0.5 simple 9472.747925 10137.15053 1.0701383178630293
100 True True True 0.9 0.25 simple 7072.171960000001 8893.614663 1.2575506807953805
100 True True True 0.9 0.1 simple 4291.520308 6714.904339 1.5646912648840248
100 True True True 0.9 0.01 simple 1091.9928380000001 2665.3164770000003 2.4407820127113324
drop init alter update update2 index done
100 True True True 0.85 1.0 simple 10327.722291 9843.241682 0.9530893070757531
100 True True True 0.85 0.75 simple 9441.542809999999 9538.652406000001 1.0102853525058584
100 True True True 0.85 0.5 simple 8016.24706 9103.497036 1.1356307967883417
100 True True True 0.85 0.25 simple 5650.355226 8043.272833000001 1.4234986140320944
100 True True True 0.85 0.1 simple 3100.166992 6143.863118 1.9817845728485843
100 True True True 0.85 0.01 simple 733.334071 2543.162773 3.467945747470937
drop init alter update update2 index done
100 True True True 0.8 1.0 simple 9314.639924 8871.064795999999 0.9523787144087997
100 True True True 0.8 0.75 simple 8293.833662000001 8659.044846 1.0440340617962105
100 True True True 0.8 0.5 simple 6886.7075970000005 8249.399432 1.1978727593420138
100 True True True 0.8 0.25 simple 4630.480577 7266.665401 1.5693112799336983
100 True True True 0.8 0.1 simple 2482.076266 5743.058413 2.3138122271541834
100 True True True 0.8 0.01 simple 547.313517 2417.605756 4.417222818196905
drop init alter update update2 index done
100 True True True 0.75 1.0 simple 8370.025367 7935.687986 0.9481079970542937
100 True True True 0.75 0.75 simple 7333.488115000001 7818.530363 1.066140728721969
100 True True True 0.75 0.5 simple 5914.6471409999995 7411.088197 1.2530059731926788
100 True True True 0.75 0.25 simple 3860.248504 6732.91931 1.7441673257624037
100 True True True 0.75 0.1 simple 1995.794585 5416.18772 2.7138001880088276
100 True True True 0.75 0.01 simple 426.494129 2342.383852 5.492183110450273
drop init alter update update2 index done
100 True True True 0.5 1.0 simple 5603.831872 5366.3587179999995 0.9576230765975414
100 True True True 0.5 0.75 simple 4724.749142000001 5272.825549 1.1160011654646276
100 True True True 0.5 0.5 simple 3610.6023160000004 5160.912173 1.429377073772419
100 True True True 0.5 0.25 simple 2129.999344 4810.356034 2.2583838100937936
100 True True True 0.5 0.1 simple 968.798213 4018.715048 4.148144571360806
100 True True True 0.5 0.01 simple 202.997683 2013.323452 9.91796271881586
drop init alter update update2 index done
100 True True True 0.25 1.0 simple 4240.564565 4089.85579 0.9644602097928441
100 True True True 0.25 0.75 simple 3499.745125 4065.866691 1.1617607985095773
100 True True True 0.25 0.5 simple 2582.491411 3983.749931 1.5425994890172356
100 True True True 0.25 0.25 simple 1454.624377 3784.354521 2.6016025723457266
100 True True True 0.25 0.1 simple 666.191871 3358.8885630000004 5.0419236697651035
100 True True True 0.25 0.01 simple 132.04862 1856.054643 14.055842787300616
drop init alter update update2 index done
100 True True True 0.1 1.0 simple 3734.209635 3596.1068700000005 0.9630168687623775
100 True True True 0.1 0.75 simple 3016.577429 3552.227539 1.1775688251362302
100 True True True 0.1 0.5 simple 2200.177028 3495.8567380000004 1.588897935716471
100 True True True 0.1 0.25 simple 1215.297979 3346.915341 2.7539874161182984
100 True True True 0.1 0.1 simple 555.555634 3046.135439 5.483043015994326
100 True True True 0.1 0.01 simple 109.056975 1795.0681989999998 16.45991188550755
drop init alter update update2 index done
100 True True True 0.01 1.0 simple 3476.168172 3381.3664819999995 0.9727281059749601
100 True True True 0.01 0.75 simple 2804.011513 3342.0763269999998 1.191891085862314
100 True True True 0.01 0.5 simple 2028.9317369999999 3323.049126 1.6378319020794143
100 True True True 0.01 0.25 simple 1081.190429 3111.510735 2.877856343843014
100 True True True 0.01 0.1 simple 506.5910819999999 2922.344859 5.7686464741201275
100 True True True 0.01 0.01 simple 97.73563900000002 1770.52779 18.11547771228057
Process finished with exit code 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment