Hello Thomas,

02.08.2024 12:00, Alexander Lakhin wrote:




I had payed attention to:
Best pg-src-17--.* worse than pg-src-16--.* by 57.9 percents (225.11 > 142.52): 
pg_tpcds.query15
Average pg-src-17--.* worse than pg-src-16--.* by 55.5 percents (230.57 > 
148.29): pg_tpcds.query15
in May, performed `git bisect` for this degradation, that led me to commit
b7b0f3f27 [1].

This time I bisected the following anomaly:
Best pg-src-17--.* worse than pg-src-16--.* by 23.6 percents (192.25 > 155.58): 
pg_tpcds.query21
Average pg-src-17--.* worse than pg-src-16--.* by 25.1 percents (196.19 > 
156.85): pg_tpcds.query21
and to my surprise I got "b7b0f3f27 is the first bad commit".

Moreover, bisecting of another anomaly:
Best pg-src-17--.* worse than pg-src-16--.* by 24.2 percents (24269.21 > 
19539.89): pg_tpcds.query72
Average pg-src-17--.* worse than pg-src-16--.* by 24.2 percents (24517.66 > 
19740.12): pg_tpcds.query72
pointed at the same commit again.

...

But beside that, I've found a separate regression. Bisecting for this 
degradation:
Best pg-src-17--.* worse than pg-src-16--.* by 105.0 percents (356.63 > 
173.96): s64da_tpcds.query95
Average pg-src-17--.* worse than pg-src-16--.* by 105.2 percents (357.79 > 
174.38): s64da_tpcds.query95
pointed at f7816aec2.


Meanwhile I've bisected another degradation:
Best pg-src-17--.* worse than pg-src-16--.* by 11.3 percents (7.17 > 6.44): 
job.query6f
and came to the commit b7b0f3f27 again.

Now that the unfairness in all-cached parallel seq scan eliminated (with
3ed3683618),  I've re-run the same performance tests and got new results
(please see attached). As we can see, the aforementioned pg_tpcds.query72
got better:
              2024-05-15  2024-07-30 2024-09-03
pg-src-16--1   20492.58    19669.34    19913.32
pg-src-17--1   25286.10    24269.21    20654.95
pg-src-16--2   20769.88    19539.89    20429.72
pg-src-17--2   25771.90    24530.51    21244.92
pg-src-17--3   25978.55    24753.25    20904.09
pg-src-16--3   20943.10    20011.13    20086.61

We can also see the improvement of pg_tpcds.query16, but not on all runs:
              2024-05-15  2024-07-30 2024-09-03
pg-src-16--1     105.36       94.31       97.74
pg-src-17--1     145.74      145.53      145.51
pg-src-16--2     101.82       98.36       96.63
pg-src-17--2     140.07      146.90       96.93
pg-src-17--3     154.89      148.11      106.18
pg-src-16--3     101.03      100.94       93.44

So it looks like now we see the same instability, that we observed before
([1]).

Unfortunately, the troublesome tpcds.query15 hasn't produced good numbers
this time too:
              2024-05-15  2024-07-30 2024-09-03
pg-src-16--1     153.41      142.52      142.54
pg-src-17--1     229.84      225.11      212.51
pg-src-16--2     153.47      150.13      149.37
pg-src-17--2     236.34      227.15      232.73
pg-src-17--3     236.43      239.46      233.77
pg-src-16--3     151.03      152.23      144.90

From a bird's eye view, new v17-vs-v16 comparison has only 87 "worse",
while the previous one had 115 (it requires deeper analysis, of course, but
still...).

[1] 
https://www.postgresql.org/message-id/d1fb5c09-dd03-2540-9ec2-86dbfdfa2c65%40gmail.com

Best regards,
Alexander
Title: Postgres benchmarking results

Benchmarking run started at 2024-09-02T09:38:29, ended at 2024-09-03T03:22:21

Benchmark version
Instanceversion
pg-src-16--1PostgreSQL 16.4-REL_16_STABLE/2015dd5c90 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
pg-src-17--1PostgreSQL 17beta3-REL_17_STABLE/3ed3683618 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
pg-src-16--2PostgreSQL 16.4-REL_16_STABLE/2015dd5c90 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
pg-src-17--2PostgreSQL 17beta3-REL_17_STABLE/3ed3683618 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
pg-src-17--3PostgreSQL 17beta3-REL_17_STABLE/3ed3683618 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
pg-src-16--3PostgreSQL 16.4-REL_16_STABLE/2015dd5c90 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit


Benchmark pgbench_native
Instancetps
pg-src-16--110555.04
pg-src-17--110713.05
pg-src-16--210539.33
pg-src-17--210689.77
pg-src-17--310713.91
pg-src-16--310562.90


Benchmark pgbench_reference
Instancelatency_​avgtps1tps2
pg-src-16--18.577471.287471.31
pg-src-17--18.317700.457700.49
pg-src-16--28.587463.047463.07
pg-src-17--28.317701.527701.55
pg-src-17--38.367655.437655.46
pg-src-16--38.577464.597464.63


Benchmark pg_tpch
Instancequery1query2query3query4query5query6query7query8query9query10query11query12query13query14query15query16query17query18query19query20query21query22
pg-src-16--19.631.452.970.700.901.442.894.630.842.450.772.182.860.853.160.988.6414.300.195.792.360.23
pg-src-17--19.301.482.820.690.881.352.794.550.952.330.782.122.760.862.990.998.2014.540.195.462.240.23
pg-src-16--29.731.433.170.700.901.452.884.440.942.410.762.172.840.853.160.988.7514.320.195.792.330.23
pg-src-17--29.151.463.060.690.881.352.784.480.932.360.772.102.820.863.000.968.5713.830.195.482.250.22
pg-src-17--39.061.482.820.690.881.352.794.610.942.320.782.082.800.852.991.008.2314.410.195.562.270.22
pg-src-16--39.631.463.000.680.881.442.874.490.932.410.782.162.780.873.160.988.6114.400.195.772.330.23


Benchmark pg_tpcds
Instanceload_​sizeindexes_​sizevacuum_​full_​sizevacuum_​freeze_​sizeload_​timeindexes_​timevacuum_​full_​timevacuum_​freeze_​timeanalyze_​timequery92query91query13query9query21query90query93query16query68query48query76query7query37query43query72query82query79query55query66query71query69query34query45query10query28query3query15query50query85query84query42query73query94query46query88query19query40query26query96query6query52
pg-src-16--15069452.007250172.006939848.006942520.0077.8972.5294.322.173.4780.1545.44639.111440.39156.46148.064.8997.74267.27776.70385.431191.358.05711.5619913.3210.04345.33276.69293.88237.71110.77245.37129.3231.24673.8028.70142.5476.02113.6615.49280.83200.4974.22491.491671.62305.7171.62578.10203.4722641.96279.38
pg-src-17--15069696.007250136.006939804.006942476.0077.2970.6291.972.073.3876.0042.77602.861379.45192.72137.825.30145.51248.11747.61375.891196.387.40687.3820654.958.95321.39273.67302.34222.26115.06228.31133.0332.03648.9330.22212.5177.60115.4614.82275.94186.7771.32483.361516.78300.4177.48580.21183.5417055.95272.62
pg-src-16--25069432.007250160.006939852.006942524.0077.8672.6195.602.173.4378.7444.00638.011445.93159.91146.344.5496.63268.90775.20382.701190.937.96706.8520429.729.60342.47280.45296.88235.95112.20243.51130.5431.02670.1528.73149.3755.97113.5314.95281.02200.2874.44729.021661.96311.5973.31575.33201.9522805.14281.19
pg-src-17--25069576.007250012.006939812.006942484.0078.2570.7291.842.063.3773.1843.18607.481351.40199.49136.084.9596.93251.86745.81381.361207.637.37688.8621244.928.68322.98268.75290.70223.16112.85227.21129.2931.40651.0529.03232.7380.41113.9514.50268.75181.1069.33483.301512.00299.2773.39578.25184.2416965.94268.77
pg-src-17--35069464.007249888.006939840.006942480.0077.6273.2391.893.033.4074.7743.56601.381355.91192.86134.395.02106.18250.13739.19370.711204.347.39690.7220904.098.75321.06275.54300.61221.62115.71226.541317.5031.17645.8530.15233.7756.32114.6114.45274.20183.0469.90479.301505.33310.8498.38578.89184.3616931.08272.48
pg-src-16--35069444.007250236.006939824.006942520.0079.8371.5495.132.213.4580.9546.05644.111444.63159.84148.254.8293.44271.00778.54386.461198.848.09712.9620086.6110.02344.74282.13310.14241.05112.59244.63132.1031.46676.0731.18144.9078.14115.9416.40291.00207.1776.39496.921660.93310.5272.97569.19202.7922667.43284.54


Benchmark ycsb
Instanceload_​a_​sizeload_​b_​sizeload_​c_​sizeload_​d_​sizeload_​f_​sizeload_​a_​timeload_​b_​timeload_​c_​timeload_​d_​timeload_​f_​timeload_​a_​10_​runtimeload_​a_​25_​runtimeload_​a_​50_​runtimeload_​b_​10_​runtimeload_​b_​25_​runtimeload_​b_​50_​runtimeload_​c_​10_​runtimeload_​c_​25_​runtimeload_​c_​50_​runtimeload_​d_​10_​runtimeload_​d_​25_​runtimeload_​d_​50_​runtimeload_​f_​10_​runtimeload_​f_​25_​runtimeload_​f_​50_​runtimeload_​a_​10_​opsload_​a_​25_​opsload_​a_​50_​opsload_​b_​10_​opsload_​b_​25_​opsload_​b_​50_​opsload_​c_​10_​opsload_​c_​25_​opsload_​c_​50_​opsload_​d_​10_​opsload_​d_​25_​opsload_​d_​50_​opsload_​f_​10_​opsload_​f_​25_​opsload_​f_​50_​ops
pg-src-16--12259520.002277852.002277512.002277160.002277956.0041.1742.5741.8841.4441.599474.005122.005482.004890.003361.003372.004505.002969.003032.004483.003068.003141.009105.006606.006648.00105552.04195236.24182415.18204498.98297530.50296559.91221975.58336813.74329815.30223064.91325945.24318369.95109829.76151377.54150421.18
pg-src-17--12259492.002277576.002277476.002277148.002279224.0041.7640.7540.8940.5241.399859.005318.006029.005410.003295.003324.004608.003042.003017.004478.003064.002957.009167.006769.007037.00101430.17188040.62165864.99184842.88303490.14300842.36217013.89328731.10331455.09223313.98326370.76338180.59109086.94147732.31142106.01
pg-src-16--22259520.002277604.002277512.002277168.002277972.0041.2940.8142.4443.6143.369960.005266.005478.005509.003467.003430.004502.003012.003061.004490.003072.003117.009293.007031.006684.00100401.61189897.46182548.38181521.15288433.80291545.19222123.50332005.31326690.62222717.15325520.83320821.30107607.88142227.28149611.01
pg-src-17--22259488.002277584.002277228.002277148.002278592.0040.2841.6840.5440.0040.459453.005489.005785.005169.003322.003274.004455.002938.002996.004447.003153.003060.0010325.007248.007066.00105786.52182182.55172860.85193461.02301023.48305436.77224466.89340367.60333778.37224870.70317158.26326797.3996852.30137969.09141522.79
pg-src-17--32259488.002277840.002277484.002277156.002279112.0040.8241.6540.9240.4740.2510754.005422.005861.004864.003300.003191.004620.002978.002996.004497.003133.002988.009171.008964.006921.0092988.66184433.79170619.35205592.11303030.30313381.39216450.22335795.84333778.37222370.47319182.89334672.02109039.36111557.34144487.79
pg-src-16--32259520.002277604.002277248.002277168.002279132.0040.3141.6741.3840.6940.569679.005088.005373.005689.003326.003490.004678.003102.003000.004439.003101.003049.0010008.006589.006642.00103316.46196540.88186115.76175777.82300661.46286532.95213766.57322372.66333333.33225275.96322476.62327976.3999920.06151768.10150557.06


Benchmark benchmarksql_tpcc
Instancetpm_​totalxactsdata_​size
pg-src-16--1211328.00634002.002806768.00
pg-src-17--1213625.00640914.002762864.00
pg-src-16--2199387.00598174.002749036.00
pg-src-17--2213212.00639665.002766324.00
pg-src-17--3214646.00643956.002770352.00
pg-src-16--3205839.00617536.002773592.00


Benchmark benchbase
Instanceauctionmark_​rpsepinions_​rpshyadapt_​rpsotmetrics_​rpsresourcestresser_​rpsseats_​rpssibench_​rpssmallbank_​rpstatp_​rpstpcc_​rpstpch_​rpstwitter_​rpsvoter_​rpsycsb_​rps
pg-src-16--1154.3878243.5014336.087274.820.9210744.2951430.2036134.2597194.156939.040.2974403.0245462.27124689.01
pg-src-17--1162.0687788.3813956.057454.920.9510660.2673194.5534851.5598576.717019.190.2975914.1345944.85126591.48
pg-src-16--2156.9378554.1514178.057024.971.2110851.5552952.0436077.1195605.617067.590.2975978.1045845.00123972.37
pg-src-17--2165.0088362.5413864.507963.870.8310858.9969443.0534107.7396731.716984.120.2977016.3246236.50124870.76
pg-src-17--3151.3587351.9314294.037747.941.0210525.7264885.6634135.57100915.556508.560.2975961.5245795.22124918.29
pg-src-16--3162.3979741.8814220.146982.661.0010446.8352647.3734715.1797599.146933.270.2973328.2143990.38122215.06


Benchmark gdprbench
Instanceload_​controller_​opsrun_​controller_​opsload_​customer_​opsrun_​customer_​opsload_​processor_​opsrun_​processor_​ops
pg-src-16--119723.871733.1016666.672016.1317953.321295.34
pg-src-17--116920.471779.3617391.302016.1317636.681204.82
pg-src-16--216806.721821.4919801.981883.2418621.971293.66
pg-src-17--216863.411814.8817513.131980.2017123.291331.56
pg-src-17--317241.381805.0516750.421988.0717730.501344.09
pg-src-16--317211.701766.7817421.601923.0816863.411314.06


Benchmark s64da_tpch
Instancetotalquery1query2query3query4query5query6query7query8query9query10query11query12query13query14query15query16query17query18query19query20query21query22
pg-src-16--167.429.261.372.930.891.621.351.911.093.982.250.732.492.890.861.541.024.3120.670.181.054.810.21
pg-src-17--165.898.711.422.740.881.521.271.781.044.592.100.732.272.780.851.401.014.0920.660.181.074.580.20
pg-src-16--267.129.401.372.910.881.591.351.891.103.852.260.722.492.850.851.511.014.2920.610.181.054.750.21
pg-src-17--265.728.931.402.730.891.461.241.761.024.552.090.712.262.800.851.401.014.1220.490.181.074.560.20
pg-src-17--365.098.871.372.730.891.571.241.771.084.602.130.712.262.780.861.411.024.1819.470.181.054.710.20
pg-src-16--367.509.271.382.930.891.661.351.901.133.992.270.732.482.860.861.531.014.3720.540.191.064.890.21


Benchmark s64da_tpcds
Instancetotalquery1query2query3query5query6query7query8query9query12query13query14aquery14bquery15query16query17query18query19query20query21query22query23aquery23bquery24aquery24bquery25query26query27query28query29query30query31query32query33query34query35query36query37query38query39aquery39bquery40query41query42query43query44query45query46query47query48query49query50query51query52query53query54query55query56query57query58query59query60query61query62query63query64query65query66query67query68query69query70query71query72query73query75query76query78query79query80query81query82query83query84query85query86query87query88query89query90query91query92query93query94query95query96query97query98query99
pg-src-16--12714.290.000.980.020.58205.221.160.062.550.050.6430.6367.840.140.090.920.690.310.070.124.677.016.890.010.010.640.570.991.940.4155.7517.290.050.210.252.320.830.012.174.314.210.081.160.300.010.001.270.502.130.770.160.082.660.290.500.110.291.051.070.121.582.270.010.220.490.581.480.302.100.230.141.130.2520.520.202.060.372.770.390.53259.110.010.100.030.170.272.201.670.350.150.050.070.100.09175.360.221.060.160.38
pg-src-17--13800.07934.270.940.020.57195.181.130.052.380.050.6131.3967.010.140.090.920.750.300.070.124.526.896.860.010.010.650.730.991.820.4254.2816.640.050.220.232.300.800.011.923.883.940.111.100.280.010.001.280.482.300.740.160.082.410.280.490.110.281.101.180.121.352.340.010.210.500.561.350.291.870.210.141.070.2321.580.191.860.382.770.370.54241.630.010.100.030.170.271.961.530.330.140.050.060.090.08357.940.201.040.240.67
pg-src-16--22734.450.000.980.010.58204.121.160.062.560.050.6530.6868.440.140.090.920.710.230.070.124.747.026.970.010.010.630.581.001.950.4056.1417.090.050.210.252.330.820.012.184.214.180.081.140.310.010.000.140.502.150.770.160.082.610.300.490.110.211.041.110.121.602.340.010.220.490.591.470.301.920.230.141.130.1521.360.212.060.382.890.390.54252.180.010.100.030.170.272.201.690.360.150.050.080.090.09202.930.221.070.250.38
pg-src-17--23685.00977.370.930.010.56197.091.140.062.380.050.6130.9866.770.150.090.900.750.360.070.124.506.906.850.010.010.640.710.991.820.4156.3716.660.050.210.242.310.810.011.923.923.940.111.110.320.010.001.300.482.340.730.160.062.430.330.490.110.221.061.240.121.352.270.010.210.490.551.350.281.860.210.141.070.1520.620.191.840.372.750.370.53242.690.010.100.030.170.271.951.550.340.140.050.060.090.08196.510.211.040.230.55
pg-src-17--33805.86934.800.940.010.57195.711.130.062.390.050.6131.2866.890.140.120.910.750.240.070.124.506.866.820.010.010.650.720.981.820.4254.2416.670.050.210.232.340.810.012.153.954.210.121.100.310.010.001.310.482.320.740.160.062.460.320.500.110.221.111.180.121.342.350.010.210.510.561.380.301.850.210.141.070.1521.630.191.830.382.790.370.53241.650.010.100.030.170.272.191.550.340.140.050.060.090.08362.160.211.040.240.60
pg-src-16--32702.450.000.970.010.58205.351.140.072.550.050.6430.7168.000.140.090.910.690.230.070.124.677.066.920.010.010.640.570.991.940.4155.3517.180.050.200.252.300.840.012.164.204.170.081.140.310.010.000.140.502.140.770.150.082.600.300.500.110.211.041.080.121.582.220.010.220.490.591.470.301.900.230.141.130.1520.670.212.070.382.850.390.53248.870.010.100.030.170.272.171.680.350.150.050.070.090.08175.520.211.060.160.37


Benchmark s64da_ssb
InstancetotalqueryQ1.1queryQ1.2queryQ1.3queryQ2.1queryQ2.2queryQ2.3queryQ3.1queryQ3.2queryQ3.3queryQ3.4queryQ4.1queryQ4.2queryQ4.3
pg-src-16--133.092.532.442.452.792.382.123.492.121.871.873.243.072.71
pg-src-17--130.602.382.292.272.622.231.962.921.931.751.743.072.902.55
pg-src-16--232.572.542.432.412.492.372.113.492.321.861.873.273.082.33
pg-src-17--231.032.362.322.252.612.261.973.311.911.751.753.082.902.57
pg-src-17--330.932.372.292.252.612.231.953.311.931.741.743.042.912.55
pg-src-16--333.122.532.442.422.512.392.153.492.301.871.873.313.122.73


Benchmark job
Instancequery10aquery10bquery10cquery11aquery11bquery11cquery11dquery12aquery12bquery12cquery13aquery13bquery13cquery13dquery14aquery14bquery14cquery15aquery15bquery15cquery15dquery16aquery16bquery16cquery16dquery17aquery17bquery17cquery17dquery17equery17fquery18aquery18bquery18cquery19aquery19bquery19cquery19dquery1aquery1bquery1cquery1dquery20aquery20bquery20cquery21aquery21bquery21cquery22aquery22bquery22cquery22dquery23aquery23bquery23cquery24aquery24bquery25aquery25bquery25cquery26aquery26bquery26cquery27aquery27bquery27cquery28aquery28bquery28cquery29aquery29bquery29cquery2aquery2bquery2cquery2dquery30aquery30bquery30cquery31aquery31bquery31cquery32aquery32bquery33aquery33bquery33cquery3aquery3bquery3cquery4aquery4bquery4cquery5aquery5bquery5cquery6aquery6bquery6cquery6dquery6equery6fquery7aquery7bquery7cquery8aquery8bquery8cquery8dquery9aquery9bquery9cquery9d
pg-src-16--10.550.383.270.260.091.124.540.380.061.061.290.650.631.960.650.170.950.320.040.850.950.2116.671.591.269.347.677.457.6111.0710.024.881.336.280.300.196.637.130.070.060.060.062.591.140.640.340.250.480.590.442.161.350.590.070.361.750.229.080.4812.200.670.171.860.340.210.730.930.742.320.220.120.220.500.460.440.592.720.686.453.120.683.150.001.220.860.980.900.170.120.260.100.120.100.170.160.220.071.220.036.440.076.470.220.2026.402.260.194.773.130.280.272.423.95
pg-src-17--10.550.383.150.280.091.134.650.400.061.081.340.690.642.030.700.170.970.330.040.720.910.2517.411.661.369.987.887.577.6611.5610.150.361.396.433.900.186.617.080.060.050.060.052.631.170.730.350.260.510.610.452.151.390.560.070.351.750.084.000.4911.730.820.422.240.340.210.740.970.772.370.190.073.220.510.480.470.611.670.695.453.220.663.240.001.240.770.812.530.190.120.270.100.120.110.160.150.210.071.400.047.410.077.520.240.1915.162.360.194.602.942.461.472.274.27
pg-src-16--20.550.393.310.280.091.134.590.400.061.091.310.660.642.010.660.170.950.330.040.860.970.2317.101.631.299.657.787.567.6111.4610.040.391.346.350.300.206.647.170.070.060.060.062.611.150.680.330.250.480.590.442.161.390.560.070.821.800.063.990.4812.360.360.162.050.530.150.740.941.420.460.080.070.850.520.470.450.605.350.673.473.190.653.220.001.210.845.362.540.320.120.260.100.120.100.170.160.220.061.270.036.630.076.790.260.2017.832.280.204.793.130.290.272.434.45
pg-src-17--20.560.383.170.290.091.404.690.400.061.061.340.690.652.020.680.170.950.330.040.720.910.2417.371.631.289.497.907.517.5511.2410.010.511.346.263.810.186.396.990.060.050.060.052.611.150.670.330.250.480.590.442.141.370.550.070.790.850.063.940.4811.510.800.162.160.340.200.740.830.602.370.080.100.210.510.470.450.615.340.663.503.190.673.250.001.210.802.032.510.180.120.260.100.120.100.160.150.210.061.360.047.220.077.360.240.1826.522.290.194.712.972.441.442.284.26
pg-src-17--30.580.383.170.280.091.445.130.400.061.111.330.680.652.040.720.181.010.330.040.720.910.2417.811.681.319.587.757.497.6211.4410.064.811.366.313.820.186.476.990.060.050.060.052.591.170.700.340.250.490.590.432.161.360.550.070.341.750.083.950.4911.480.800.212.160.340.230.745.850.692.380.080.070.210.500.470.440.6010.820.705.193.220.653.220.001.250.840.812.510.170.120.260.100.120.100.160.150.210.061.350.047.150.077.200.250.1820.042.290.194.652.992.441.442.264.32
pg-src-16--30.600.393.280.270.111.134.570.410.061.091.310.690.642.000.670.171.040.330.070.860.960.2317.271.621.299.397.607.327.4411.249.870.381.396.540.300.206.777.120.060.060.060.062.591.150.680.330.240.470.640.472.241.440.570.070.820.840.063.980.4811.710.370.210.750.340.150.510.940.672.4017.641.050.510.500.460.450.5911.430.653.633.120.643.180.001.221.021.712.500.170.120.260.100.120.100.170.160.220.071.220.036.590.076.640.270.2022.532.370.204.863.160.280.272.454.53


Benchmark sysbench
Instanceload_​bulk_​insert_​tpsload_​oltp_​delete_​tpsload_​oltp_​insert_​tpsload_​oltp_​point_​select_​tpsload_​oltp_​read_​only_​tpsload_​oltp_​read_​write_​tpsload_​oltp_​update_​index_​tpsload_​oltp_​update_​non_​index_​tpsload_​oltp_​write_​only_​tpsload_​select_​random_​points_​tpsload_​select_​random_​ranges_​tpsload_​bulk_​insert_​opsload_​oltp_​delete_​opsload_​oltp_​insert_​opsload_​oltp_​point_​select_​opsload_​oltp_​read_​only_​opsload_​oltp_​read_​write_​opsload_​oltp_​update_​index_​opsload_​oltp_​update_​non_​index_​opsload_​oltp_​write_​only_​opsload_​select_​random_​points_​opsload_​select_​random_​ranges_​ops
pg-src-16--12121442.62367043.92127736.19356984.1915044.889301.14154214.33181749.4229968.05221029.48147619.6574.02367043.92127736.19356984.19240718.14186106.27154214.33181749.42180117.54221029.48147619.65
pg-src-17--12223417.57364937.72130976.71355356.2914958.788947.69151461.57182404.0325055.27260191.45148597.1577.92364937.72130976.71355356.29239340.54179039.43151461.57182404.03150592.32260191.45148597.15
pg-src-16--22166684.64364913.57127671.80351179.4314852.258934.82153759.63180060.0426420.27218552.77143672.7375.77364913.57127671.80351179.43237635.93178784.64153759.63180060.04158791.37218552.77143672.73
pg-src-17--22255472.85371336.90128456.03361004.7115040.888997.72149289.12182014.7329327.65264282.82147883.9579.15371336.90128456.03361004.71240654.14180036.51149289.12182014.73176267.01264282.82147883.95
pg-src-17--32279598.26370515.75130290.53356668.4515010.629393.94152135.93184423.2927282.70264570.35148655.9480.09370515.75130290.53356668.45240169.95187978.70152135.93184423.29163984.94264570.35148655.94
pg-src-16--32174533.66362506.75126130.59352806.9414923.848883.89152955.32179857.6026151.47219180.57145376.4476.06362506.75126130.59352806.94238781.38177763.58152955.32179857.60157177.05219180.57145376.44


Benchmark insert-1m
Instancetime
pg-src-16--134.90
pg-src-17--135.02
pg-src-16--235.15
pg-src-17--233.63
pg-src-17--334.89
pg-src-16--334.28


./analyze-benchmarks.py -i 'pg-src-17--.*'  'pg-src-16--.*'
Best pg-src-17--.* better than pg-src-16--.* by 5.9 percents (9.06 < 9.63): 
pg_tpch.query1
Average pg-src-17--.* better than pg-src-16--.* by 5.1 percents (9.17 < 9.66): 
pg_tpch.query1
Best pg-src-17--.* better than pg-src-16--.* by 5.1 percents (2.82 < 2.97): 
pg_tpch.query3
Best pg-src-17--.* better than pg-src-16--.* by 6.2 percents (1.35 < 1.44): 
pg_tpch.query6
Average pg-src-17--.* better than pg-src-16--.* by 6.5 percents (1.35 < 1.44): 
pg_tpch.query6
Best pg-src-17--.* worse than pg-src-16--.* by 10.7 percents (0.93 > 0.84): 
pg_tpch.query9
Best pg-src-17--.* better than pg-src-16--.* by 5.4 percents (2.99 < 3.16): 
pg_tpch.query15
Average pg-src-17--.* better than pg-src-16--.* by 5.3 percents (2.99 < 3.16): 
pg_tpch.query15
Best pg-src-17--.* better than pg-src-16--.* by 5.4 percents (5.46 < 5.77): 
pg_tpch.query20
Best pg-src-17--.* better than pg-src-16--.* by 5.1 percents (2.06 < 2.17): 
pg_tpcds.vacuum_freeze_time
Average pg-src-17--.* worse than pg-src-16--.* by 9.3 percents (2.39 > 2.18): 
pg_tpcds.vacuum_freeze_time
Best pg-src-17--.* better than pg-src-16--.* by 7.1 percents (73.18 < 78.73): 
pg_tpcds.query92
Average pg-src-17--.* better than pg-src-16--.* by 6.6 percents (74.65 < 
79.94): pg_tpcds.query92
Best pg-src-17--.* better than pg-src-16--.* by 5.7 percents (601.38 < 638.01): 
pg_tpcds.query13
Average pg-src-17--.* better than pg-src-16--.* by 5.7 percents (603.90 < 
640.41): pg_tpcds.query13
Best pg-src-17--.* better than pg-src-16--.* by 6.2 percents (1351.40 < 
1440.39): pg_tpcds.query9
Average pg-src-17--.* better than pg-src-16--.* by 5.6 percents (1362.25 < 
1443.65): pg_tpcds.query9
Best pg-src-17--.* worse than pg-src-16--.* by 23.2 percents (192.72 > 156.46): 
pg_tpcds.query21
Average pg-src-17--.* worse than pg-src-16--.* by 22.9 percents (195.02 > 
158.73): pg_tpcds.query21
Best pg-src-17--.* better than pg-src-16--.* by 8.2 percents (134.39 < 146.34): 
pg_tpcds.query90
Average pg-src-17--.* better than pg-src-16--.* by 7.8 percents (136.10 < 
147.55): pg_tpcds.query90
Best pg-src-17--.* worse than pg-src-16--.* by 9.1 percents (4.95 > 4.54): 
pg_tpcds.query93
Average pg-src-17--.* worse than pg-src-16--.* by 7.1 percents (5.09 > 4.75): 
pg_tpcds.query93
Average pg-src-17--.* worse than pg-src-16--.* by 21.1 percents (116.21 > 
95.94): pg_tpcds.query16
Best pg-src-17--.* better than pg-src-16--.* by 7.2 percents (248.11 < 267.27): 
pg_tpcds.query68
Average pg-src-17--.* better than pg-src-16--.* by 7.1 percents (250.03 < 
269.06): pg_tpcds.query68
Best pg-src-17--.* better than pg-src-16--.* by 7.4 percents (7.37 < 7.96): 
pg_tpcds.query37
Average pg-src-17--.* better than pg-src-16--.* by 8.0 percents (7.39 < 8.03): 
pg_tpcds.query37
Best pg-src-17--.* better than pg-src-16--.* by 9.6 percents (8.68 < 9.60): 
pg_tpcds.query82
Average pg-src-17--.* better than pg-src-16--.* by 11.1 percents (8.79 < 9.88): 
pg_tpcds.query82
Best pg-src-17--.* better than pg-src-16--.* by 6.3 percents (321.06 < 342.47): 
pg_tpcds.query79
Average pg-src-17--.* better than pg-src-16--.* by 6.5 percents (321.81 < 
344.18): pg_tpcds.query79
Best pg-src-17--.* better than pg-src-16--.* by 6.1 percents (221.62 < 235.94): 
pg_tpcds.query71
Average pg-src-17--.* better than pg-src-16--.* by 6.7 percents (222.34 < 
238.23): pg_tpcds.query71
Best pg-src-17--.* better than pg-src-16--.* by 7.0 percents (226.54 < 243.51): 
pg_tpcds.query34
Average pg-src-17--.* better than pg-src-16--.* by 7.0 percents (227.35 < 
244.50): pg_tpcds.query34
Average pg-src-17--.* worse than pg-src-16--.* by 303.0 percents (526.61 > 
130.66): pg_tpcds.query45
Best pg-src-17--.* worse than pg-src-16--.* by 49.1 percents (212.51 > 142.54): 
pg_tpcds.query15
Average pg-src-17--.* worse than pg-src-16--.* by 55.5 percents (226.34 > 
145.60): pg_tpcds.query15
Average pg-src-17--.* better than pg-src-16--.* by 6.6 percents (14.59 < 
15.61): pg_tpcds.query84
Best pg-src-17--.* better than pg-src-16--.* by 9.6 percents (181.10 < 200.28): 
pg_tpcds.query73
Average pg-src-17--.* better than pg-src-16--.* by 9.4 percents (183.64 < 
202.65): pg_tpcds.query73
Best pg-src-17--.* better than pg-src-16--.* by 6.6 percents (69.33 < 74.22): 
pg_tpcds.query94
Average pg-src-17--.* better than pg-src-16--.* by 6.4 percents (70.18 < 
75.02): pg_tpcds.query94
Average pg-src-17--.* better than pg-src-16--.* by 15.8 percents (481.98 < 
572.48): pg_tpcds.query46
Best pg-src-17--.* better than pg-src-16--.* by 9.4 percents (1505.33 < 
1660.93): pg_tpcds.query88
Average pg-src-17--.* better than pg-src-16--.* by 9.2 percents (1511.37 < 
1664.83): pg_tpcds.query88
Average pg-src-17--.* worse than pg-src-16--.* by 14.4 percents (83.08 > 
72.63): pg_tpcds.query40
Best pg-src-17--.* better than pg-src-16--.* by 9.1 percents (183.54 < 201.95): 
pg_tpcds.query96
Average pg-src-17--.* better than pg-src-16--.* by 9.2 percents (184.05 < 
202.74): pg_tpcds.query96
Best pg-src-17--.* better than pg-src-16--.* by 25.2 percents (16931.08 < 
22641.96): pg_tpcds.query6
Average pg-src-17--.* better than pg-src-16--.* by 25.2 percents (16984.32 < 
22704.84): pg_tpcds.query6
Best pg-src-17--.* worse than pg-src-16--.* by 7.7 percents (5785.00 > 
5373.00): ycsb.load_a_50_runtime
Average pg-src-17--.* worse than pg-src-16--.* by 8.2 percents (5891.67 > 
5444.33): ycsb.load_a_50_runtime
Best pg-src-17--.* better than pg-src-16--.* by 5.4 percents (3191.00 < 
3372.00): ycsb.load_b_50_runtime
Average pg-src-17--.* worse than pg-src-16--.* by 13.6 percents (7660.33 > 
6742.00): ycsb.load_f_25_runtime
Average pg-src-17--.* worse than pg-src-16--.* by 5.3 percents (7008.00 > 
6658.00): ycsb.load_f_50_runtime
Best pg-src-17--.* worse than pg-src-16--.* by 7.1 percents (172860.85 < 
186115.76): ycsb.load_a_50_ops
Average pg-src-17--.* worse than pg-src-16--.* by 7.6 percents (169781.73 < 
183693.11): ycsb.load_a_50_ops
Best pg-src-17--.* better than pg-src-16--.* by 5.7 percents (313381.39 > 
296559.91): ycsb.load_b_50_ops
Average pg-src-17--.* better than pg-src-16--.* by 5.1 percents (306553.51 > 
291546.02): ycsb.load_b_50_ops
Average pg-src-17--.* worse than pg-src-16--.* by 10.8 percents (132419.58 < 
148457.64): ycsb.load_f_25_ops
Best pg-src-17--.* better than pg-src-16--.* by 10.8 percents (88362.54 > 
79741.88): benchbase.epinions_rps
Average pg-src-17--.* better than pg-src-16--.* by 11.4 percents (87834.28 > 
78846.51): benchbase.epinions_rps
Best pg-src-17--.* better than pg-src-16--.* by 9.5 percents (7963.87 > 
7274.82): benchbase.otmetrics_rps
Average pg-src-17--.* better than pg-src-16--.* by 8.9 percents (7722.24 > 
7094.15): benchbase.otmetrics_rps
Best pg-src-17--.* worse than pg-src-16--.* by 15.6 percents (1.02 < 1.21): 
benchbase.resourcestresser_rps
Average pg-src-17--.* worse than pg-src-16--.* by 10.3 percents (0.94 < 1.04): 
benchbase.resourcestresser_rps
Best pg-src-17--.* better than pg-src-16--.* by 38.2 percents (73194.55 > 
52952.04): benchbase.sibench_rps
Average pg-src-17--.* better than pg-src-16--.* by 32.2 percents (69174.42 > 
52343.20): benchbase.sibench_rps
Best pg-src-17--.* worse than pg-src-16--.* by 12.6 percents (17241.38 < 
19723.87): gdprbench.load_controller_ops
Average pg-src-17--.* worse than pg-src-16--.* by 5.1 percents (17008.42 < 
17914.10): gdprbench.load_controller_ops
Best pg-src-17--.* worse than pg-src-16--.* by 11.6 percents (17513.13 < 
19801.98): gdprbench.load_customer_ops
Best pg-src-17--.* better than pg-src-16--.* by 5.9 percents (8.71 < 9.26): 
s64da_tpch.query1
Average pg-src-17--.* better than pg-src-16--.* by 5.1 percents (8.84 < 9.31): 
s64da_tpch.query1
Best pg-src-17--.* better than pg-src-16--.* by 6.2 percents (2.73 < 2.91): 
s64da_tpch.query3
Average pg-src-17--.* better than pg-src-16--.* by 6.5 percents (2.73 < 2.92): 
s64da_tpch.query3
Best pg-src-17--.* better than pg-src-16--.* by 8.2 percents (1.46 < 1.59): 
s64da_tpch.query5
Average pg-src-17--.* better than pg-src-16--.* by 6.6 percents (1.52 < 1.62): 
s64da_tpch.query5
Best pg-src-17--.* better than pg-src-16--.* by 8.1 percents (1.24 < 1.35): 
s64da_tpch.query6
Average pg-src-17--.* better than pg-src-16--.* by 7.4 percents (1.25 < 1.35): 
s64da_tpch.query6
Best pg-src-17--.* better than pg-src-16--.* by 6.9 percents (1.76 < 1.89): 
s64da_tpch.query7
Average pg-src-17--.* better than pg-src-16--.* by 6.8 percents (1.77 < 1.90): 
s64da_tpch.query7
Best pg-src-17--.* better than pg-src-16--.* by 6.4 percents (1.02 < 1.09): 
s64da_tpch.query8
Average pg-src-17--.* better than pg-src-16--.* by 5.4 percents (1.05 < 1.11): 
s64da_tpch.query8
Best pg-src-17--.* worse than pg-src-16--.* by 18.2 percents (4.55 > 3.85): 
s64da_tpch.query9
Average pg-src-17--.* worse than pg-src-16--.* by 16.2 percents (4.58 > 3.94): 
s64da_tpch.query9
Best pg-src-17--.* better than pg-src-16--.* by 7.1 percents (2.09 < 2.25): 
s64da_tpch.query10
Average pg-src-17--.* better than pg-src-16--.* by 6.8 percents (2.11 < 2.26): 
s64da_tpch.query10
Best pg-src-17--.* better than pg-src-16--.* by 8.9 percents (2.26 < 2.48): 
s64da_tpch.query12
Average pg-src-17--.* better than pg-src-16--.* by 9.0 percents (2.26 < 2.49): 
s64da_tpch.query12
Best pg-src-17--.* better than pg-src-16--.* by 7.3 percents (1.40 < 1.51): 
s64da_tpch.query15
Average pg-src-17--.* better than pg-src-16--.* by 8.1 percents (1.40 < 1.53): 
s64da_tpch.query15
Best pg-src-17--.* better than pg-src-16--.* by 5.2 percents (19.47 < 20.54): 
s64da_tpch.query18
Best pg-src-17--.* worse than pg-src-16--.* by 36.4 percents (3685.00 > 
2702.45): s64da_tpcds.total
Average pg-src-17--.* worse than pg-src-16--.* by 38.5 percents (3763.64 > 
2717.06): s64da_tpcds.total
Best pg-src-17--.* better than pg-src-16--.* by 16.7 percents (0.05 < 0.06): 
s64da_tpcds.query8
Average pg-src-17--.* better than pg-src-16--.* by 10.5 percents (0.06 < 0.06): 
s64da_tpcds.query8
Best pg-src-17--.* better than pg-src-16--.* by 6.7 percents (2.38 < 2.55): 
s64da_tpcds.query9
Average pg-src-17--.* better than pg-src-16--.* by 6.7 percents (2.38 < 2.55): 
s64da_tpcds.query9
Average pg-src-17--.* better than pg-src-16--.* by 5.2 percents (0.61 < 0.64): 
s64da_tpcds.query13
Average pg-src-17--.* worse than pg-src-16--.* by 11.1 percents (0.10 > 0.09): 
s64da_tpcds.query16
Best pg-src-17--.* worse than pg-src-16--.* by 8.7 percents (0.75 > 0.69): 
s64da_tpcds.query18
Average pg-src-17--.* worse than pg-src-16--.* by 7.7 percents (0.75 > 0.70): 
s64da_tpcds.query18
Average pg-src-17--.* worse than pg-src-16--.* by 16.9 percents (0.30 > 0.26): 
s64da_tpcds.query19
Best pg-src-17--.* worse than pg-src-16--.* by 24.6 percents (0.71 > 0.57): 
s64da_tpcds.query26
Average pg-src-17--.* worse than pg-src-16--.* by 25.6 percents (0.72 > 0.57): 
s64da_tpcds.query26
Best pg-src-17--.* better than pg-src-16--.* by 6.2 percents (1.82 < 1.94): 
s64da_tpcds.query28
Average pg-src-17--.* better than pg-src-16--.* by 6.3 percents (1.82 < 1.94): 
s64da_tpcds.query28
Best pg-src-17--.* better than pg-src-16--.* by 8.0 percents (0.23 < 0.25): 
s64da_tpcds.query34
Average pg-src-17--.* better than pg-src-16--.* by 6.7 percents (0.23 < 0.25): 
s64da_tpcds.query34
Best pg-src-17--.* better than pg-src-16--.* by 11.1 percents (1.92 < 2.16): 
s64da_tpcds.query38
Average pg-src-17--.* better than pg-src-16--.* by 8.0 percents (2.00 < 2.17): 
s64da_tpcds.query38
Best pg-src-17--.* better than pg-src-16--.* by 7.6 percents (3.88 < 4.20): 
s64da_tpcds.query39a
Average pg-src-17--.* better than pg-src-16--.* by 7.6 percents (3.92 < 4.24): 
s64da_tpcds.query39a
Best pg-src-17--.* better than pg-src-16--.* by 5.5 percents (3.94 < 4.17): 
s64da_tpcds.query39b
Best pg-src-17--.* worse than pg-src-16--.* by 37.5 percents (0.11 > 0.08): 
s64da_tpcds.query40
Average pg-src-17--.* worse than pg-src-16--.* by 41.7 percents (0.11 > 0.08): 
s64da_tpcds.query40
Best pg-src-17--.* better than pg-src-16--.* by 6.7 percents (0.28 < 0.30): 
s64da_tpcds.query42
Best pg-src-17--.* worse than pg-src-16--.* by 814.3 percents (1.28 > 0.14): 
s64da_tpcds.query45
Average pg-src-17--.* worse than pg-src-16--.* by 151.0 percents (1.30 > 0.52): 
s64da_tpcds.query45
Best pg-src-17--.* worse than pg-src-16--.* by 8.0 percents (2.30 > 2.13): 
s64da_tpcds.query47
Average pg-src-17--.* worse than pg-src-16--.* by 8.4 percents (2.32 > 2.14): 
s64da_tpcds.query47
Best pg-src-17--.* better than pg-src-16--.* by 5.2 percents (0.73 < 0.77): 
s64da_tpcds.query48
Best pg-src-17--.* worse than pg-src-16--.* by 6.7 percents (0.16 > 0.15): 
s64da_tpcds.query49
Best pg-src-17--.* better than pg-src-16--.* by 25.0 percents (0.06 < 0.08): 
s64da_tpcds.query50
Average pg-src-17--.* better than pg-src-16--.* by 16.7 percents (0.07 < 0.08): 
s64da_tpcds.query50
Best pg-src-17--.* better than pg-src-16--.* by 7.3 percents (2.41 < 2.60): 
s64da_tpcds.query51
Average pg-src-17--.* better than pg-src-16--.* by 7.2 percents (2.43 < 2.62): 
s64da_tpcds.query51
Best pg-src-17--.* worse than pg-src-16--.* by 10.3 percents (1.18 > 1.07): 
s64da_tpcds.query57
Average pg-src-17--.* worse than pg-src-16--.* by 10.4 percents (1.20 > 1.09): 
s64da_tpcds.query57
Best pg-src-17--.* better than pg-src-16--.* by 15.2 percents (1.34 < 1.58): 
s64da_tpcds.query59
Average pg-src-17--.* better than pg-src-16--.* by 15.1 percents (1.35 < 1.59): 
s64da_tpcds.query59
Best pg-src-17--.* better than pg-src-16--.* by 5.2 percents (0.55 < 0.58): 
s64da_tpcds.query64
Average pg-src-17--.* better than pg-src-16--.* by 5.1 percents (0.56 < 0.59): 
s64da_tpcds.query64
Best pg-src-17--.* better than pg-src-16--.* by 8.2 percents (1.35 < 1.47): 
s64da_tpcds.query65
Average pg-src-17--.* better than pg-src-16--.* by 7.7 percents (1.36 < 1.47): 
s64da_tpcds.query65
Best pg-src-17--.* better than pg-src-16--.* by 6.7 percents (0.28 < 0.30): 
s64da_tpcds.query66
Average pg-src-17--.* better than pg-src-16--.* by 5.7 percents (1.86 < 1.97): 
s64da_tpcds.query67
Best pg-src-17--.* better than pg-src-16--.* by 8.7 percents (0.21 < 0.23): 
s64da_tpcds.query68
Average pg-src-17--.* better than pg-src-16--.* by 8.7 percents (0.21 < 0.23): 
s64da_tpcds.query68
Best pg-src-17--.* better than pg-src-16--.* by 5.3 percents (1.07 < 1.13): 
s64da_tpcds.query70
Average pg-src-17--.* better than pg-src-16--.* by 5.3 percents (1.07 < 1.13): 
s64da_tpcds.query70
Best pg-src-17--.* better than pg-src-16--.* by 5.0 percents (0.19 < 0.20): 
s64da_tpcds.query73
Average pg-src-17--.* better than pg-src-16--.* by 8.1 percents (0.19 < 0.21): 
s64da_tpcds.query73
Best pg-src-17--.* better than pg-src-16--.* by 11.2 percents (1.83 < 2.06): 
s64da_tpcds.query75
Average pg-src-17--.* better than pg-src-16--.* by 10.7 percents (1.84 < 2.06): 
s64da_tpcds.query75
Best pg-src-17--.* better than pg-src-16--.* by 5.1 percents (0.37 < 0.39): 
s64da_tpcds.query79
Average pg-src-17--.* better than pg-src-16--.* by 5.1 percents (0.37 < 0.39): 
s64da_tpcds.query79
Best pg-src-17--.* better than pg-src-16--.* by 10.1 percents (1.95 < 2.17): 
s64da_tpcds.query87
Average pg-src-17--.* better than pg-src-16--.* by 7.2 percents (2.03 < 2.19): 
s64da_tpcds.query87
Best pg-src-17--.* better than pg-src-16--.* by 8.4 percents (1.53 < 1.67): 
s64da_tpcds.query88
Average pg-src-17--.* better than pg-src-16--.* by 8.1 percents (1.54 < 1.68): 
s64da_tpcds.query88
Best pg-src-17--.* better than pg-src-16--.* by 5.7 percents (0.33 < 0.35): 
s64da_tpcds.query89
Best pg-src-17--.* better than pg-src-16--.* by 6.7 percents (0.14 < 0.15): 
s64da_tpcds.query90
Average pg-src-17--.* better than pg-src-16--.* by 6.7 percents (0.14 < 0.15): 
s64da_tpcds.query90
Best pg-src-17--.* better than pg-src-16--.* by 14.3 percents (0.06 < 0.07): 
s64da_tpcds.query92
Average pg-src-17--.* better than pg-src-16--.* by 18.2 percents (0.06 < 0.07): 
s64da_tpcds.query92
Average pg-src-17--.* better than pg-src-16--.* by 7.7 percents (0.08 < 0.09): 
s64da_tpcds.query94
Best pg-src-17--.* worse than pg-src-16--.* by 12.1 percents (196.51 > 175.36): 
s64da_tpcds.query95
Average pg-src-17--.* worse than pg-src-16--.* by 65.5 percents (305.54 > 
184.60): s64da_tpcds.query95
Best pg-src-17--.* worse than pg-src-16--.* by 43.8 percents (0.23 > 0.16): 
s64da_tpcds.query98
Average pg-src-17--.* worse than pg-src-16--.* by 24.6 percents (0.24 > 0.19): 
s64da_tpcds.query98
Best pg-src-17--.* worse than pg-src-16--.* by 48.6 percents (0.55 > 0.37): 
s64da_tpcds.query99
Average pg-src-17--.* worse than pg-src-16--.* by 61.1 percents (0.61 > 0.38): 
s64da_tpcds.query99
Best pg-src-17--.* better than pg-src-16--.* by 6.0 percents (30.60 < 32.57): 
s64da_ssb.total
Average pg-src-17--.* better than pg-src-16--.* by 6.3 percents (30.85 < 
32.93): s64da_ssb.total
Best pg-src-17--.* better than pg-src-16--.* by 6.7 percents (2.36 < 2.53): 
s64da_ssb.queryQ1.1
Average pg-src-17--.* better than pg-src-16--.* by 6.4 percents (2.37 < 2.53): 
s64da_ssb.queryQ1.1
Best pg-src-17--.* better than pg-src-16--.* by 5.8 percents (2.29 < 2.43): 
s64da_ssb.queryQ1.2
Average pg-src-17--.* better than pg-src-16--.* by 5.6 percents (2.30 < 2.44): 
s64da_ssb.queryQ1.2
Best pg-src-17--.* better than pg-src-16--.* by 6.6 percents (2.25 < 2.41): 
s64da_ssb.queryQ1.3
Average pg-src-17--.* better than pg-src-16--.* by 7.0 percents (2.26 < 2.43): 
s64da_ssb.queryQ1.3
Best pg-src-17--.* better than pg-src-16--.* by 5.9 percents (2.23 < 2.37): 
s64da_ssb.queryQ2.2
Average pg-src-17--.* better than pg-src-16--.* by 5.9 percents (2.24 < 2.38): 
s64da_ssb.queryQ2.2
Best pg-src-17--.* better than pg-src-16--.* by 7.6 percents (1.95 < 2.11): 
s64da_ssb.queryQ2.3
Average pg-src-17--.* better than pg-src-16--.* by 7.8 percents (1.96 < 2.13): 
s64da_ssb.queryQ2.3
Best pg-src-17--.* better than pg-src-16--.* by 16.3 percents (2.92 < 3.49): 
s64da_ssb.queryQ3.1
Average pg-src-17--.* better than pg-src-16--.* by 8.9 percents (3.18 < 3.49): 
s64da_ssb.queryQ3.1
Best pg-src-17--.* better than pg-src-16--.* by 9.9 percents (1.91 < 2.12): 
s64da_ssb.queryQ3.2
Average pg-src-17--.* better than pg-src-16--.* by 14.4 percents (1.92 < 2.25): 
s64da_ssb.queryQ3.2
Best pg-src-17--.* better than pg-src-16--.* by 6.5 percents (1.74 < 1.86): 
s64da_ssb.queryQ3.3
Average pg-src-17--.* better than pg-src-16--.* by 6.4 percents (1.75 < 1.87): 
s64da_ssb.queryQ3.3
Best pg-src-17--.* better than pg-src-16--.* by 7.0 percents (1.74 < 1.87): 
s64da_ssb.queryQ3.4
Average pg-src-17--.* better than pg-src-16--.* by 6.8 percents (1.74 < 1.87): 
s64da_ssb.queryQ3.4
Best pg-src-17--.* better than pg-src-16--.* by 6.2 percents (3.04 < 3.24): 
s64da_ssb.queryQ4.1
Average pg-src-17--.* better than pg-src-16--.* by 6.4 percents (3.06 < 3.27): 
s64da_ssb.queryQ4.1
Best pg-src-17--.* better than pg-src-16--.* by 5.5 percents (2.90 < 3.07): 
s64da_ssb.queryQ4.2
Average pg-src-17--.* better than pg-src-16--.* by 6.0 percents (2.90 < 3.09): 
s64da_ssb.queryQ4.2
Best pg-src-17--.* worse than pg-src-16--.* by 9.4 percents (2.55 > 2.33): 
s64da_ssb.queryQ4.3
Best pg-src-17--.* worse than pg-src-16--.* by 7.7 percents (0.28 > 0.26): 
job.query11a
Average pg-src-17--.* better than pg-src-16--.* by 6.9 percents (0.09 < 0.10): 
job.query11b
Average pg-src-17--.* worse than pg-src-16--.* by 17.5 percents (1.32 > 1.13): 
job.query11c
Average pg-src-17--.* worse than pg-src-16--.* by 5.6 percents (4.82 > 4.57): 
job.query11d
Best pg-src-17--.* worse than pg-src-16--.* by 5.3 percents (0.40 > 0.38): 
job.query12a
Average pg-src-17--.* worse than pg-src-16--.* by 6.1 percents (0.70 > 0.66): 
job.query14a
Average pg-src-17--.* better than pg-src-16--.* by 20.0 percents (0.04 < 0.05): 
job.query15b
Best pg-src-17--.* better than pg-src-16--.* by 15.3 percents (0.72 < 0.85): 
job.query15c
Average pg-src-17--.* better than pg-src-16--.* by 16.0 percents (0.72 < 0.86): 
job.query15c
Average pg-src-17--.* better than pg-src-16--.* by 5.2 percents (0.91 < 0.96): 
job.query15d
Best pg-src-17--.* worse than pg-src-16--.* by 14.3 percents (0.24 > 0.21): 
job.query16a
Average pg-src-17--.* worse than pg-src-16--.* by 9.0 percents (0.24 > 0.22): 
job.query16a
Best pg-src-17--.* better than pg-src-16--.* by 5.3 percents (0.36 < 0.38): 
job.query18a
Best pg-src-17--.* worse than pg-src-16--.* by 1170.0 percents (3.81 > 0.30): 
job.query19a
Average pg-src-17--.* worse than pg-src-16--.* by 1181.1 percents (3.84 > 
0.30): job.query19a
Best pg-src-17--.* better than pg-src-16--.* by 5.3 percents (0.18 < 0.19): 
job.query19b
Average pg-src-17--.* better than pg-src-16--.* by 8.5 percents (0.18 < 0.20): 
job.query19b
Average pg-src-17--.* better than pg-src-16--.* by 10.0 percents (0.06 < 0.07): 
job.query1a
Best pg-src-17--.* better than pg-src-16--.* by 16.7 percents (0.05 < 0.06): 
job.query1b
Average pg-src-17--.* better than pg-src-16--.* by 16.7 percents (0.05 < 0.06): 
job.query1b
Best pg-src-17--.* better than pg-src-16--.* by 16.7 percents (0.05 < 0.06): 
job.query1d
Average pg-src-17--.* better than pg-src-16--.* by 16.7 percents (0.05 < 0.06): 
job.query1d
Best pg-src-17--.* better than pg-src-16--.* by 5.6 percents (0.34 < 0.36): 
job.query23c
Average pg-src-17--.* better than pg-src-16--.* by 26.0 percents (0.49 < 0.67): 
job.query23c
Average pg-src-17--.* better than pg-src-16--.* by 35.3 percents (0.07 < 0.11): 
job.query24b
Average pg-src-17--.* better than pg-src-16--.* by 30.3 percents (3.96 < 5.68): 
job.query25a
Best pg-src-17--.* worse than pg-src-16--.* by 122.2 percents (0.80 > 0.36): 
job.query26a
Average pg-src-17--.* worse than pg-src-16--.* by 72.9 percents (0.81 > 0.47): 
job.query26a
Average pg-src-17--.* worse than pg-src-16--.* by 46.3 percents (0.26 > 0.18): 
job.query26b
Best pg-src-17--.* worse than pg-src-16--.* by 188.0 percents (2.16 > 0.75): 
job.query26c
Average pg-src-17--.* worse than pg-src-16--.* by 40.8 percents (2.19 > 1.55): 
job.query26c
Average pg-src-17--.* better than pg-src-16--.* by 15.7 percents (0.34 < 0.40): 
job.query27a
Best pg-src-17--.* worse than pg-src-16--.* by 33.3 percents (0.20 > 0.15): 
job.query27b
Average pg-src-17--.* worse than pg-src-16--.* by 25.5 percents (0.21 > 0.17): 
job.query27b
Best pg-src-17--.* worse than pg-src-16--.* by 45.1 percents (0.74 > 0.51): 
job.query27c
Average pg-src-17--.* worse than pg-src-16--.* by 12.1 percents (0.74 > 0.66): 
job.query27c
Best pg-src-17--.* better than pg-src-16--.* by 10.8 percents (0.83 < 0.93): 
job.query28a
Average pg-src-17--.* worse than pg-src-16--.* by 172.2 percents (2.55 > 0.94): 
job.query28a
Best pg-src-17--.* better than pg-src-16--.* by 10.4 percents (0.60 < 0.67): 
job.query28b
Average pg-src-17--.* better than pg-src-16--.* by 27.2 percents (0.69 < 0.94): 
job.query28b
Best pg-src-17--.* worse than pg-src-16--.* by 415.2 percents (2.37 > 0.46): 
job.query28c
Average pg-src-17--.* worse than pg-src-16--.* by 37.5 percents (2.37 > 1.73): 
job.query28c
Average pg-src-17--.* better than pg-src-16--.* by 98.0 percents (0.12 < 5.98): 
job.query29a
Average pg-src-17--.* better than pg-src-16--.* by 80.6 percents (0.08 < 0.41): 
job.query29b
Average pg-src-17--.* worse than pg-src-16--.* by 130.4 percents (1.21 > 0.53): 
job.query29c
Best pg-src-17--.* better than pg-src-16--.* by 38.6 percents (1.67 < 2.72): 
job.query30a
Average pg-src-17--.* better than pg-src-16--.* by 8.6 percents (5.94 < 6.50): 
job.query30a
Best pg-src-17--.* better than pg-src-16--.* by 8.3 percents (0.77 < 0.84): 
job.query33a
Average pg-src-17--.* better than pg-src-16--.* by 11.4 percents (0.80 < 0.91): 
job.query33a
Best pg-src-17--.* better than pg-src-16--.* by 17.3 percents (0.81 < 0.98): 
job.query33b
Average pg-src-17--.* better than pg-src-16--.* by 54.7 percents (1.22 < 2.68): 
job.query33b
Best pg-src-17--.* worse than pg-src-16--.* by 178.9 percents (2.51 > 0.90): 
job.query33c
Average pg-src-17--.* worse than pg-src-16--.* by 27.1 percents (2.52 > 1.98): 
job.query33c
Average pg-src-17--.* better than pg-src-16--.* by 18.2 percents (0.18 < 0.22): 
job.query3a
Best pg-src-17--.* better than pg-src-16--.* by 5.9 percents (0.16 < 0.17): 
job.query5a
Average pg-src-17--.* better than pg-src-16--.* by 5.9 percents (0.16 < 0.17): 
job.query5a
Best pg-src-17--.* better than pg-src-16--.* by 6.3 percents (0.15 < 0.16): 
job.query5b
Average pg-src-17--.* better than pg-src-16--.* by 6.3 percents (0.15 < 0.16): 
job.query5b
Best pg-src-17--.* worse than pg-src-16--.* by 10.7 percents (1.35 > 1.22): 
job.query6b
Average pg-src-17--.* worse than pg-src-16--.* by 10.8 percents (1.37 > 1.24): 
job.query6b
Best pg-src-17--.* worse than pg-src-16--.* by 33.3 percents (0.04 > 0.03): 
job.query6c
Average pg-src-17--.* worse than pg-src-16--.* by 33.3 percents (0.04 > 0.03): 
job.query6c
Best pg-src-17--.* worse than pg-src-16--.* by 11.0 percents (7.15 > 6.44): 
job.query6d
Average pg-src-17--.* worse than pg-src-16--.* by 10.8 percents (7.26 > 6.55): 
job.query6d
Best pg-src-17--.* worse than pg-src-16--.* by 11.3 percents (7.20 > 6.47): 
job.query6f
Average pg-src-17--.* worse than pg-src-16--.* by 11.0 percents (7.36 > 6.63): 
job.query6f
Best pg-src-17--.* worse than pg-src-16--.* by 9.1 percents (0.24 > 0.22): 
job.query7a
Best pg-src-17--.* better than pg-src-16--.* by 10.0 percents (0.18 < 0.20): 
job.query7b
Average pg-src-17--.* better than pg-src-16--.* by 8.3 percents (0.18 < 0.20): 
job.query7b
Best pg-src-17--.* better than pg-src-16--.* by 15.0 percents (15.16 < 17.83): 
job.query7c
Average pg-src-17--.* better than pg-src-16--.* by 7.5 percents (20.57 < 
22.25): job.query7c
Best pg-src-17--.* better than pg-src-16--.* by 6.1 percents (2.94 < 3.13): 
job.query8d
Average pg-src-17--.* better than pg-src-16--.* by 5.5 percents (2.97 < 3.14): 
job.query8d
Best pg-src-17--.* worse than pg-src-16--.* by 771.4 percents (2.44 > 0.28): 
job.query9a
Average pg-src-17--.* worse than pg-src-16--.* by 763.5 percents (2.45 > 0.28): 
job.query9a
Best pg-src-17--.* worse than pg-src-16--.* by 433.3 percents (1.44 > 0.27): 
job.query9b
Average pg-src-17--.* worse than pg-src-16--.* by 437.0 percents (1.45 > 0.27): 
job.query9b
Best pg-src-17--.* better than pg-src-16--.* by 6.6 percents (2.26 < 2.42): 
job.query9c
Average pg-src-17--.* better than pg-src-16--.* by 6.7 percents (2.27 < 2.43): 
job.query9c
Best pg-src-17--.* worse than pg-src-16--.* by 7.8 percents (4.26 > 3.95): 
job.query9d
Best pg-src-17--.* better than pg-src-16--.* by 19.7 percents (264570.35 > 
221029.48): sysbench.load_select_random_points_tps
Average pg-src-17--.* better than pg-src-16--.* by 19.8 percents (263014.87 > 
219587.61): sysbench.load_select_random_points_tps
Best pg-src-17--.* better than pg-src-16--.* by 5.3 percents (80.09 > 76.06): 
sysbench.load_bulk_insert_ops
Average pg-src-17--.* better than pg-src-16--.* by 5.0 percents (79.05 > 
75.28): sysbench.load_bulk_insert_ops
Best pg-src-17--.* better than pg-src-16--.* by 19.7 percents (264570.35 > 
221029.48): sysbench.load_select_random_points_ops
Average pg-src-17--.* better than pg-src-16--.* by 19.8 percents (263014.87 > 
219587.61): sysbench.load_select_random_points_ops

Reply via email to