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