Benchmarking run started at 2024-07-29T13:12:55, ended at 2024-07-30T06:38:51

Benchmark version
Instanceversion
pg-src-16--1PostgreSQL 16.3-REL_16_STABLE/6f6b0f193d 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 17beta2-REL_17_STABLE/1e020258e5 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.3-REL_16_STABLE/6f6b0f193d 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 17beta2-REL_17_STABLE/1e020258e5 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 17beta2-REL_17_STABLE/1e020258e5 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.3-REL_16_STABLE/6f6b0f193d 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--110536.51
pg-src-17--110660.13
pg-src-16--210481.51
pg-src-17--210594.45
pg-src-17--310693.34
pg-src-16--310553.12


Benchmark pgbench_reference
Instancelatency_​avgtps1tps2
pg-src-16--18.597450.587450.62
pg-src-17--18.297723.947723.98
pg-src-16--28.467568.247568.27
pg-src-17--28.347676.047676.07
pg-src-17--38.317700.717700.75
pg-src-16--38.477552.347552.37


Benchmark pg_tpch
Instancequery1query2query3query4query5query6query7query8query9query10query11query12query13query14query15query16query17query18query19query20query21query22
pg-src-16--19.621.463.000.680.891.472.914.540.952.450.772.202.810.863.221.018.6214.390.195.912.350.23
pg-src-17--19.061.442.840.690.891.372.794.460.902.380.782.122.640.853.021.008.1814.010.194.812.300.23
pg-src-16--29.661.463.040.700.921.472.944.470.872.490.782.232.810.873.241.008.6314.270.195.932.380.23
pg-src-17--29.051.462.850.690.861.352.774.350.902.370.762.102.760.863.040.988.2113.910.195.532.280.22
pg-src-17--39.041.442.860.690.881.362.804.440.912.370.762.132.580.863.040.998.1413.980.185.562.290.22
pg-src-16--39.551.463.030.690.901.472.924.570.852.480.762.222.860.883.230.998.6314.470.195.942.370.23


Benchmark pg_tpcds
Instanceload_​sizeindexes_​sizevacuum_​full_​sizevacuum_​freeze_​sizeload_​timeindexes_​timevacuum_​full_​timevacuum_​freeze_​timeanalyze_​timequery92query91query13query9query21query90query93query16query68query48query76query7query37query43query72query82query79query55query66query71query69query34query45query10query28query3query15query50query85query84query42query73query94query46query88query19query40query26query96query6query52
pg-src-16--15069432.007250132.006939884.006942556.0077.7572.6094.562.203.4278.7742.93644.401429.52159.04144.444.6894.31268.20780.57381.671184.767.83714.9319669.349.83343.15278.35297.75238.64110.27244.09129.6231.64661.5229.47142.5257.43114.6815.71281.67203.4973.68501.041667.03311.2874.79570.61202.7922691.44289.46
pg-src-17--15069680.007250104.006939812.006942488.0078.4070.9891.092.073.4475.2043.55605.761324.73192.25138.754.99145.53255.18740.79372.101191.537.38685.2524269.219.12325.70274.86434.72223.85112.00228.09128.2731.31645.4228.98225.1155.82113.3014.39273.29181.8370.01478.451525.30296.5193.39987.16185.6116957.49277.99
pg-src-16--25069448.007250136.006939884.006942556.0076.8972.6094.502.213.4280.2843.61644.421433.55155.58144.774.8998.36268.23778.46381.051188.187.98712.8419539.8910.28344.44283.47299.61242.72113.93246.34133.1631.28671.5628.94150.1357.82176.0615.00315.71205.2874.29495.641656.23307.2174.08562.39202.4622620.88290.00
pg-src-17--25069696.007250100.006939808.006942480.0078.3770.8290.762.103.4573.8445.17607.121329.71198.92139.664.35146.90256.66746.00375.471195.4013.73695.3324530.519.02324.39313.40403.55220.67112.91227.54129.4431.03658.2529.09227.1556.90114.0914.80330.89188.7768.85480.761521.84298.54100.13983.71182.6316891.29296.43
pg-src-17--35069676.007250108.006939808.006942480.0078.3470.8691.132.073.4573.3244.27600.381327.04197.39139.115.23148.11250.23740.92373.971191.837.38682.4424753.259.07323.83270.96427.89225.96113.02227.44128.5930.93643.1529.20239.4655.23113.1014.56269.02180.9069.01480.521512.23297.7694.08942.11181.9016906.16268.10
pg-src-16--35069424.007250132.006939884.006942556.0077.3372.5293.862.223.4480.6648.37640.591431.27155.92143.094.71100.94265.52777.77376.501195.678.05719.6720011.1310.31344.36285.33299.88239.42113.18245.90131.2631.76663.6629.34152.2357.00114.3015.35280.46199.6874.51495.071667.67310.6174.61577.31201.9222604.77280.96


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.002277604.002277248.002277168.002279256.0042.7140.8141.4240.8743.106957.005181.005241.005215.003701.003342.004598.002931.002923.004460.003197.003039.009130.006794.006647.00143740.12193012.93190803.28191754.55270197.24299222.02217485.86341180.48342114.27224215.25312793.24329055.61109529.03147188.70150443.81
pg-src-17--12259492.002277304.002277084.002277140.002278584.0040.9740.0540.6040.2940.087342.005451.005678.004847.003933.003434.004620.002926.003005.004509.003099.003037.009206.008367.007250.00136202.67183452.58176118.35206313.18254258.84291205.59216450.22341763.50332778.70221778.66322684.74329272.31108624.81119517.15137931.03
pg-src-16--22259520.002277336.002276716.002277156.002279252.0041.4041.0042.3041.1441.036873.005172.005218.004987.003922.003247.004648.002969.002985.004532.003161.003088.008948.006583.006866.00145496.87193348.80191644.31200521.36254971.95307976.59215146.30336813.74335008.38220653.13316355.58323834.20111756.82151906.43145645.21
pg-src-17--22259488.002277320.002277100.002277148.002278336.0040.0140.2239.7240.3939.518011.005420.005765.004851.003946.003313.004625.002985.003007.004455.003048.003075.008952.009119.006912.00124828.36184501.85173460.54206143.06253421.19301841.23216216.22335008.38332557.37224466.89328083.99325203.25111706.88109661.15144675.93
pg-src-17--32259488.002277564.002277224.002277136.002278852.0043.3339.8639.6541.6741.897180.005466.005817.005679.003436.003326.004542.003028.002894.004395.003216.003148.0010750.008740.007029.00139275.77182949.14171909.92176087.34291036.09300661.46220167.33330250.99345542.50227531.29310945.27317662.0193023.26114416.48142267.75
pg-src-16--32259516.002277600.002277260.002277164.002278876.0043.1840.4540.3740.5440.747142.005144.005391.005269.003400.003319.004471.003024.002942.004398.003069.002983.0011093.006668.007172.00140016.80194401.24185494.34189789.33294117.65301295.57223663.61330687.83339904.83227376.08325839.04335232.9990146.94149970.01139431.12


Benchmark benchmarksql_tpcc
Instancetpm_​totalxactsdata_​size
pg-src-16--1207779.00623364.002780220.00
pg-src-17--1221078.00663290.002789132.00
pg-src-16--2205220.00615668.002784372.00
pg-src-17--2215190.00645588.002766848.00
pg-src-17--3209403.00628222.002746100.00
pg-src-16--3204791.00614393.002774228.00


Benchmark benchbase
Instanceauctionmark_​rpsepinions_​rpshyadapt_​rpsotmetrics_​rpsresourcestresser_​rpsseats_​rpssibench_​rpssmallbank_​rpstatp_​rpstpcc_​rpstpch_​rpstwitter_​rpsvoter_​rpsycsb_​rps
pg-src-16--1143.2479120.3614261.297217.731.149895.4448945.0436874.5298426.007221.290.2872820.2845764.64130881.26
pg-src-17--1158.4988936.3313864.167296.990.9810126.5750673.7835842.4899637.387045.500.2973249.9045375.98127977.64
pg-src-16--2160.7579926.1114151.737299.911.1410529.5248378.9038390.8297906.376999.910.3073095.7745408.17122285.97
pg-src-17--2148.5087418.5914822.207867.241.2110554.9251916.2935860.0298248.286428.540.2975172.4444539.07127709.62
pg-src-17--3161.2887809.9513908.177756.030.9310143.8448170.9036142.02101253.716478.260.2973921.4544989.33129261.41
pg-src-16--3162.7480739.1414730.267417.441.2210072.7048628.8636821.58100970.387314.670.3074283.0145695.20128327.21


Benchmark gdprbench
Instanceload_​controller_​opsrun_​controller_​opsload_​customer_​opsrun_​customer_​opsload_​processor_​opsrun_​processor_​ops
pg-src-16--117123.291715.2719455.252057.6117241.381351.35
pg-src-17--117574.691776.2017361.112066.1216638.941310.62
pg-src-16--215479.881795.3317452.011992.0314858.841321.00
pg-src-17--216949.151792.1117182.132000.0019455.251367.99
pg-src-17--318518.521742.1617605.632004.0116474.461293.66
pg-src-16--316722.411838.2418382.352040.8216920.471298.70


Benchmark s64da_tpch
Instancetotalquery1query2query3query4query5query6query7query8query9query10query11query12query13query14query15query16query17query18query19query20query21query22
pg-src-16--168.469.161.382.930.891.671.381.921.044.722.270.722.492.840.881.551.024.3420.990.191.034.840.21
pg-src-17--166.158.711.402.840.881.531.271.801.074.602.160.712.382.800.881.441.014.1420.420.181.054.690.20
pg-src-16--269.119.201.362.930.901.691.371.931.104.672.280.702.472.900.881.561.014.3221.570.181.064.820.21
pg-src-17--265.348.691.382.810.881.521.261.801.063.882.160.732.402.790.861.410.964.1920.390.191.074.700.20
pg-src-17--365.858.631.352.750.901.561.261.791.094.662.150.672.372.760.861.421.014.1720.360.181.074.610.20
pg-src-16--368.319.111.352.930.891.691.371.931.133.962.280.702.492.890.871.541.034.2421.600.181.034.890.21


Benchmark s64da_tpcds
Instancetotalquery1query2query3query5query6query7query8query9query12query13query14aquery14bquery15query16query17query18query19query20query21query22query23aquery23bquery24aquery24bquery25query26query27query28query29query30query31query32query33query34query35query36query37query38query39aquery39bquery40query41query42query43query44query45query46query47query48query49query50query51query52query53query54query55query56query57query58query59query60query61query62query63query64query65query66query67query68query69query70query71query72query73query75query76query78query79query80query81query82query83query84query85query86query87query88query89query90query91query92query93query94query95query96query97query98query99
pg-src-16--12708.540.001.010.010.58209.841.120.062.550.050.6530.7468.120.140.090.890.690.230.070.124.716.976.920.010.010.630.560.961.960.4055.7117.070.050.330.252.280.820.012.184.254.290.081.190.310.010.001.260.502.170.770.160.082.600.300.500.110.221.051.090.121.602.230.010.220.490.591.460.291.920.230.141.130.1520.800.212.050.372.780.390.38249.350.010.100.020.170.272.211.690.360.150.040.070.090.08174.740.211.080.250.37
pg-src-17--13816.70934.830.940.010.56205.721.130.052.380.050.6131.0066.810.230.120.911.000.300.070.204.466.816.850.010.010.640.850.991.850.4154.9516.950.050.230.232.290.810.012.223.883.910.121.140.280.010.001.270.482.300.740.160.062.400.280.500.110.281.101.410.121.362.330.010.210.500.561.360.401.850.210.141.080.2425.640.191.850.393.290.370.39240.740.010.100.030.170.272.271.540.330.140.050.060.090.08358.200.191.050.240.71
pg-src-16--22708.090.000.980.010.58210.221.140.062.530.050.6531.0168.250.140.090.900.710.310.070.124.697.016.890.010.010.640.590.991.990.4155.7117.020.050.210.252.310.830.012.174.264.240.081.200.290.010.001.280.502.180.770.160.062.610.290.480.110.291.041.090.121.572.200.010.220.480.581.470.301.910.230.141.130.2520.520.212.030.382.820.390.53249.030.010.100.030.170.272.211.700.360.150.050.070.090.08173.960.211.070.160.38
pg-src-17--23820.14937.810.940.010.56206.021.140.072.370.050.6130.8167.060.230.120.901.010.240.070.204.467.016.810.010.010.650.830.981.830.4254.0216.840.060.250.232.310.810.012.233.853.890.121.140.330.010.001.270.492.290.760.160.062.430.320.490.110.221.061.410.121.352.280.010.210.510.581.360.391.840.210.141.070.1525.050.191.860.383.230.370.55244.130.010.110.030.170.262.251.570.340.140.050.060.090.08356.630.191.060.240.51
pg-src-17--33815.80933.600.950.010.56205.861.130.062.420.050.6130.9366.580.230.120.900.990.300.070.204.466.886.800.010.010.630.841.001.840.4154.2016.970.060.330.232.300.810.012.193.883.940.111.140.280.010.001.280.482.300.740.150.062.410.270.460.110.281.071.660.121.372.250.010.200.480.561.360.401.860.210.131.080.2325.210.191.840.373.040.370.54242.160.010.100.020.170.272.241.550.340.140.050.060.090.08358.540.191.050.240.51
pg-src-16--32706.730.000.980.010.59208.071.130.072.550.050.6530.5467.850.140.090.910.700.230.070.124.696.956.870.010.010.640.570.981.980.4155.8517.130.050.210.252.290.820.012.194.314.340.081.180.310.010.000.140.502.180.770.160.062.610.300.460.110.221.081.100.121.582.320.010.220.490.591.460.301.900.230.141.130.1521.410.212.030.382.830.390.54250.220.010.100.030.170.272.201.690.360.150.040.080.090.09174.450.211.060.160.38


Benchmark s64da_ssb
InstancetotalqueryQ1.1queryQ1.2queryQ1.3queryQ2.1queryQ2.2queryQ2.3queryQ3.1queryQ3.2queryQ3.3queryQ3.4queryQ4.1queryQ4.2queryQ4.3
pg-src-16--132.842.552.462.472.822.432.123.122.101.861.863.253.072.72
pg-src-17--130.632.412.312.302.312.211.942.952.151.751.733.082.912.56
pg-src-16--232.622.552.492.462.792.402.143.422.101.861.863.203.062.28
pg-src-17--230.932.412.322.312.602.251.952.962.151.741.713.052.922.56
pg-src-17--330.772.402.322.292.612.231.943.341.941.741.753.122.932.17
pg-src-16--333.152.552.502.452.782.382.143.442.091.861.863.283.092.73


Benchmark job
Instancequery10aquery10bquery10cquery11aquery11bquery11cquery11dquery12aquery12bquery12cquery13aquery13bquery13cquery13dquery14aquery14bquery14cquery15aquery15bquery15cquery15dquery16aquery16bquery16cquery16dquery17aquery17bquery17cquery17dquery17equery17fquery18aquery18bquery18cquery19aquery19bquery19cquery19dquery1aquery1bquery1cquery1dquery20aquery20bquery20cquery21aquery21bquery21cquery22aquery22bquery22cquery22dquery23aquery23bquery23cquery24aquery24bquery25aquery25bquery25cquery26aquery26bquery26cquery27aquery27bquery27cquery28aquery28bquery28cquery29aquery29bquery29cquery2aquery2bquery2cquery2dquery30aquery30bquery30cquery31aquery31bquery31cquery32aquery32bquery33aquery33bquery33cquery3aquery3bquery3cquery4aquery4bquery4cquery5aquery5bquery5cquery6aquery6bquery6cquery6dquery6equery6fquery7aquery7bquery7cquery8aquery8bquery8cquery8dquery9aquery9bquery9cquery9d
pg-src-16--10.550.393.340.260.091.134.930.380.061.061.280.650.621.960.650.170.940.330.040.860.950.2117.041.631.299.717.827.527.5411.199.964.671.346.243.960.206.597.090.060.060.060.062.541.120.650.340.250.480.600.432.131.360.560.070.361.270.063.870.4711.310.760.341.880.350.210.420.830.562.230.250.070.830.490.470.440.591.620.665.443.100.653.210.001.201.061.941.390.170.120.260.100.120.100.170.180.220.061.200.036.330.076.440.270.2011.992.260.204.803.142.591.432.434.42
pg-src-17--10.560.393.150.270.091.414.680.390.061.091.360.680.672.070.680.181.000.320.040.720.890.2317.001.621.299.547.727.487.5811.389.964.821.406.550.280.186.677.050.060.050.060.062.621.170.740.340.260.490.620.452.211.390.560.070.361.760.113.990.4911.770.840.212.250.340.190.741.330.580.420.180.070.240.510.500.470.601.380.693.643.160.673.240.001.241.060.242.520.180.130.270.100.120.110.160.150.210.071.390.047.370.077.470.370.1912.142.400.194.673.010.270.262.334.35
pg-src-16--20.550.393.370.260.091.114.730.380.071.061.280.640.621.960.630.170.930.340.042.000.950.2116.711.631.309.487.807.497.6011.039.774.791.346.363.970.206.577.120.070.060.060.062.541.130.640.330.250.480.600.442.131.350.560.070.811.760.113.910.4711.430.760.162.030.340.230.481.020.562.340.080.080.440.480.470.430.584.530.6612.223.110.643.220.001.221.030.762.480.170.120.260.100.120.100.170.160.220.061.270.036.420.076.520.270.2011.952.300.204.823.152.640.282.424.42
pg-src-17--20.540.383.110.270.091.124.640.390.061.081.320.670.662.060.670.181.050.320.040.720.890.2217.401.651.299.557.827.517.6711.319.980.501.356.363.820.176.467.020.060.050.060.052.571.150.690.350.250.490.600.442.291.450.560.080.351.780.064.000.4811.690.380.212.150.340.240.730.950.580.430.120.071.590.510.470.440.6011.470.6811.513.200.663.290.001.2619.430.921.020.180.120.260.100.120.110.160.150.210.061.350.047.080.077.170.250.1911.952.320.194.782.992.520.262.314.51
pg-src-17--30.560.393.100.260.091.124.650.390.061.091.360.680.672.080.660.170.990.310.040.720.890.2317.291.621.299.547.757.617.7411.4510.204.801.536.560.270.196.677.140.060.050.060.052.641.170.860.340.260.490.610.452.201.400.560.070.811.760.064.020.4911.820.430.211.240.340.140.741.140.591.180.180.070.210.510.480.450.623.000.6612.033.190.673.260.001.260.262.892.520.180.120.270.100.120.110.160.150.210.061.390.047.400.077.540.370.1912.472.390.194.763.030.260.252.314.36
pg-src-16--30.560.403.410.260.241.114.670.390.061.091.310.670.642.010.650.171.010.330.040.860.950.2317.411.631.309.727.817.457.5911.3210.074.781.386.454.040.206.777.110.070.060.060.062.581.140.660.340.250.480.640.482.231.430.580.070.831.790.063.960.4812.330.790.162.120.340.210.730.960.852.360.090.080.210.490.480.460.613.250.683.333.130.653.210.001.232.563.932.520.170.120.260.100.120.100.170.160.220.061.320.036.660.076.760.270.2012.282.380.204.843.152.601.622.444.45


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--12301055.49363083.34129529.90350186.4014790.429114.07151996.60181013.8526731.41219017.92145669.3280.88363083.34129529.90350186.40236646.68182366.31151996.60181013.85160669.21219017.92145669.32
pg-src-17--12446620.01375621.33132038.12361167.1914863.408700.89148284.22176604.4824211.98258105.58145816.0386.44375621.33132038.12361167.19237814.40174104.19148284.22176604.48145515.11258105.58145816.03
pg-src-16--22279280.70355192.93128063.25345159.4414526.728749.06151061.36176716.2228854.06214867.22143813.3080.05355192.93128063.25345159.44232427.49175060.96151061.36176716.22173423.74214867.22143813.30
pg-src-17--22404438.19363141.20131567.56354956.0115170.489329.29152016.58182651.3526587.73262444.51147997.2784.84363141.20131567.56354956.01242727.63186677.78152016.58182651.35159806.80262444.51147997.27
pg-src-17--32437419.33374866.77131954.54359678.7015146.249557.85152596.39182232.1627710.46262210.36149833.1386.10374866.77131954.54359678.70242339.84191256.66152596.39182232.16166553.32262210.36149833.13
pg-src-16--32327793.41361423.06130645.37342774.0914829.449058.74151516.42175200.2628415.96217407.97143831.9581.91361423.06130645.37342774.09237270.97181260.56151516.42175200.26170793.22217407.97143831.95


Benchmark insert-1m
Instancetime
pg-src-16--137.15
pg-src-17--135.22
pg-src-16--234.47
pg-src-17--234.70
pg-src-17--333.38
pg-src-16--338.38