Benchmarking run started at 2024-05-14T12:04:26, ended at 2024-05-15T05:44:15

Benchmark version
Instanceversion
pg-src-16--1PostgreSQL 16.3-REL_16_STABLE/c1664c8eef on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
pg-src-master--1PostgreSQL 17devel-master/2e810bdb7f 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/c1664c8eef on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
pg-src-master--2PostgreSQL 17devel-master/2e810bdb7f on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
pg-src-master--3PostgreSQL 17devel-master/2e810bdb7f 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/c1664c8eef 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--110478.49
pg-src-master--110662.36
pg-src-16--210491.77
pg-src-master--210700.65
pg-src-master--310565.92
pg-src-16--310555.88


Benchmark pgbench_reference
Instancelatency_​avgtps1tps2
pg-src-16--18.597452.807452.84
pg-src-master--18.427597.857597.88
pg-src-16--28.527508.757508.79
pg-src-master--28.487545.737545.77
pg-src-master--38.377649.517649.55
pg-src-16--38.547498.927498.95


Benchmark pg_tpch
Instancequery1query2query3query4query5query6query7query8query9query10query11query12query13query14query15query16query17query18query19query20query21query22
pg-src-16--19.591.473.000.700.901.472.974.560.942.470.772.232.870.883.200.978.7014.410.195.842.360.23
pg-src-master--19.111.542.880.700.891.402.834.750.872.390.752.132.830.893.061.008.3213.970.195.552.300.22
pg-src-16--29.611.493.040.710.931.472.964.690.862.500.782.212.880.883.201.008.8214.200.205.852.360.23
pg-src-master--29.051.492.850.700.871.372.824.470.872.350.772.142.670.883.030.998.2714.240.195.572.300.22
pg-src-master--310.121.482.880.690.881.392.844.730.882.400.782.142.800.883.081.008.2814.180.195.562.330.22
pg-src-16--39.721.473.010.700.911.462.954.670.962.500.782.202.710.873.221.008.6914.400.195.982.340.23


Benchmark pg_tpcds
Instanceload_​sizeindexes_​sizevacuum_​full_​sizevacuum_​freeze_​sizeload_​timeindexes_​timevacuum_​full_​timevacuum_​freeze_​timeanalyze_​timequery92query91query13query9query21query90query93query16query68query48query76query7query37query43query72query82query79query55query66query71query69query34query45query10query28query3query15query50query85query84query42query73query94query46query88query19query40query26query96query6query52
pg-src-16--15069460.007250212.006939852.006942528.0078.3673.2396.682.293.4883.4944.95638.871466.98157.23149.804.96105.36278.76774.01380.491194.288.21713.2020492.5810.40346.13297.64302.20241.78115.87246.68133.8631.62667.3830.43153.4178.77182.2515.65294.41205.3677.62498.711670.38313.1374.38596.20202.6123918.69311.14
pg-src-master--15069628.007250072.006939856.006942528.0079.8771.6392.832.163.4682.1445.80612.611355.02201.37137.854.95145.74253.06752.50376.791203.268.36692.8125286.109.13325.84271.36412.45252.12114.83228.80132.1431.34653.3129.11229.8477.31184.5614.86268.99182.6369.12479.661515.73297.1096.46955.47185.3517137.62274.60
pg-src-16--25069288.007249988.006939848.006942520.0077.3673.2795.922.243.4182.8447.27639.831450.85158.35154.494.76101.82277.17779.26387.131202.088.26714.5820769.8810.32348.23288.74304.59243.07114.51249.44137.4232.46662.6529.54153.4780.16119.1416.45295.05207.3877.66506.871686.13319.2473.34584.07204.5523798.14291.23
pg-src-master--25069476.007249892.006939860.006942500.0079.9570.7292.643.103.4178.3444.75610.521362.95195.95141.655.19140.07253.17754.75385.321209.357.56686.4925771.909.17329.43290.55415.04224.55119.17229.24135.6031.45657.6429.96236.3481.87182.6915.04277.01184.9470.63494.841523.35306.65103.54975.26185.2917169.69278.12
pg-src-master--35069584.007249996.006939856.006942500.0078.9471.0893.273.113.4377.4447.19610.861386.95193.86140.134.83154.89257.04756.67378.821213.107.62688.1825978.559.44328.20278.73417.64226.57119.25231.79135.5431.99654.8030.82236.4356.91117.9914.63281.26183.6571.78479.821534.32301.8998.001002.00184.5817194.48284.33
pg-src-16--35069352.007250108.006939852.006942524.0078.6273.4196.992.263.4280.1246.32640.691455.49160.60149.994.21101.03273.02775.44377.311200.698.19719.6820943.1010.56350.66286.82316.33247.52114.07246.41136.9832.20662.6631.10151.0358.40118.7515.56288.93204.5575.92496.131668.00309.4874.48597.69204.4324008.34284.83


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.002277336.002276716.002277160.002279244.0041.9440.1743.1041.8641.267366.005305.005350.004996.003869.003402.004833.003063.002965.004495.003202.003172.009529.006783.007001.00135758.89188501.41186915.89200160.13258464.72293944.74206910.82326477.31337268.13222469.41312304.81315258.51104942.81147427.39142836.74
pg-src-master--12259484.002277312.002277100.002277144.002278592.0040.3840.0240.8840.0640.267373.005476.005748.004875.003857.003546.004662.003057.003044.004540.003143.003124.0011351.006673.007118.00135630.00182615.05173973.56205128.21259268.86282007.90214500.21327118.09328515.11220264.32318167.36320102.4388097.96149857.64140488.90
pg-src-16--22259516.002277596.002277496.002277160.002277960.0042.1441.7441.3542.3640.767756.005401.005390.005677.003500.003375.004539.003140.003102.004616.003137.003118.009125.006741.006680.00128932.44185150.90185528.76176149.37285714.29296296.30220312.84318471.34322372.66216637.78318775.90320718.41109589.04148345.94149700.60
pg-src-master--22259488.002277572.002277480.002277148.002277948.0042.2541.5342.6441.0242.857219.005504.005880.005672.003420.003310.004586.003081.003165.004484.003122.003082.009116.006910.007384.00138523.34181686.05170068.03176304.65292397.66302114.80218054.95324569.94315955.77223015.17320307.50324464.63109697.24144717.80135427.95
pg-src-master--32259492.002277568.002277216.002277140.002279476.0041.8640.8342.6741.4140.767401.005446.005812.005541.003447.003393.004635.003059.003069.004609.003150.003056.009011.006827.007057.00135116.88183621.01172057.81180472.84290107.34294724.43215749.73326904.22325839.04216966.80317460.32327225.13110975.47146477.22141703.27
pg-src-16--32259512.002277344.002276732.002277164.002279500.0040.1041.7342.4442.3440.737477.005357.005413.004903.003936.003453.004681.003085.003180.004521.003165.003097.009308.006835.006792.00133743.48186671.64184740.44203956.76254065.04289603.24213629.57324149.11314465.41221190.00315955.77322893.12107434.46146305.78147232.04


Benchmark benchmarksql_tpcc
Instancetpm_​totalxactsdata_​size
pg-src-16--1205365.00616142.002770484.00
pg-src-master--1180032.00540147.002662452.00
pg-src-16--2193129.00579412.002730544.00
pg-src-master--2212485.00637487.002759256.00
pg-src-master--3198731.00596240.002713388.00
pg-src-16--3215657.00646981.002808516.00


Benchmark benchbase
Instanceauctionmark_​rpsepinions_​rpshyadapt_​rpsotmetrics_​rpsresourcestresser_​rpsseats_​rpssibench_​rpssmallbank_​rpstatp_​rpstpcc_​rpstpch_​rpstwitter_​rpsvoter_​rpsycsb_​rps
pg-src-16--1155.1379317.5613920.487118.981.2610926.7054185.9036860.4697460.046959.840.2973358.8344008.30123319.57
pg-src-master--1142.9785651.3013785.147081.711.5111051.0454174.9435307.7399901.166405.830.2975820.4643766.91127570.43
pg-src-16--2161.6782043.6815250.946943.961.159698.1278324.6235008.8996210.596962.830.2975629.0145061.72125973.72
pg-src-master--2145.5586317.0414594.677615.511.3610106.4162849.7334462.6699531.496221.760.3074995.0245214.80127572.59
pg-src-master--3158.9086684.3613765.867844.341.0310552.6853621.8135164.3797183.466897.160.2975698.3644001.27125992.97
pg-src-16--3170.1781167.0114691.797119.661.419676.4465311.7137311.84100287.266853.220.2973851.3844620.00124705.11


Benchmark gdprbench
Instanceload_​controller_​opsrun_​controller_​opsload_​customer_​opsrun_​customer_​opsload_​processor_​opsrun_​processor_​ops
pg-src-16--117094.021788.9117123.292000.0016977.931297.02
pg-src-master--116835.021798.5618691.592028.4019841.271333.33
pg-src-16--217605.631763.6716835.021893.9416949.151344.09
pg-src-master--217035.781872.6617301.042012.0716863.411338.69
pg-src-master--317182.131808.3217182.132036.6617391.301356.85
pg-src-16--319230.771779.3616077.171934.2417391.301293.66


Benchmark s64da_tpch
Instancetotalquery1query2query3query4query5query6query7query8query9query10query11query12query13query14query15query16query17query18query19query20query21query22
pg-src-16--168.099.241.422.900.901.601.361.911.134.702.230.712.502.890.861.531.034.3120.660.181.034.790.21
pg-src-master--165.128.651.382.770.891.481.261.791.034.682.160.752.342.790.871.411.014.1519.610.191.054.690.20
pg-src-16--267.319.231.372.890.891.611.361.911.103.922.240.732.522.840.861.541.024.3820.650.191.064.790.21
pg-src-master--264.308.681.382.760.901.561.251.801.093.912.120.732.332.840.871.431.014.1519.490.181.054.590.20
pg-src-master--364.908.691.402.750.891.581.291.811.064.012.160.742.342.840.871.471.024.2419.580.181.154.630.20
pg-src-16--368.259.281.392.890.891.621.371.931.094.702.280.742.512.840.871.531.024.3120.780.191.044.780.21


Benchmark s64da_tpcds
Instancetotalquery1query2query3query5query6query7query8query9query12query13query14aquery14bquery15query16query17query18query19query20query21query22query23aquery23bquery24aquery24bquery25query26query27query28query29query30query31query32query33query34query35query36query37query38query39aquery39bquery40query41query42query43query44query45query46query47query48query49query50query51query52query53query54query55query56query57query58query59query60query61query62query63query64query65query66query67query68query69query70query71query72query73query75query76query78query79query80query81query82query83query84query85query86query87query88query89query90query91query92query93query94query95query96query97query98query99
pg-src-16--12709.680.000.970.020.58206.971.150.072.580.050.6431.4668.610.140.100.940.700.240.070.124.777.097.050.010.010.650.570.991.990.4255.8317.150.050.340.252.320.820.012.194.294.360.081.160.320.010.001.320.502.210.780.160.072.620.320.480.110.221.111.100.121.582.380.010.220.500.621.490.291.940.230.141.140.1521.700.212.070.382.920.400.42248.990.010.100.030.180.272.211.730.360.150.050.070.100.09175.400.211.070.260.39
pg-src-master--13652.11930.750.940.010.58202.321.130.062.410.050.6231.5768.060.230.120.911.020.300.070.204.466.856.850.010.010.640.840.981.860.4254.5616.920.060.250.232.350.800.012.203.933.940.111.140.280.010.001.330.482.310.750.160.062.440.280.500.110.281.111.470.121.352.350.010.210.480.561.370.401.860.210.141.080.2425.950.191.850.383.230.370.56243.610.010.100.020.170.272.231.560.340.140.050.060.090.08195.950.191.070.240.69
pg-src-16--22706.130.000.960.010.61206.371.150.062.590.050.6531.5568.610.130.090.920.710.240.070.124.747.016.920.010.010.660.530.991.970.4155.6917.310.050.210.262.310.820.012.194.174.210.081.170.310.010.001.290.502.210.770.160.072.630.310.500.110.211.071.100.121.572.290.010.220.510.591.470.311.920.230.141.130.1521.000.212.150.372.800.400.53249.140.010.100.020.170.272.231.720.360.160.050.080.090.09173.770.211.070.260.37
pg-src-master--23818.81928.400.940.010.57202.531.150.052.420.050.6231.8267.360.230.120.931.020.300.070.204.476.846.820.010.010.660.860.991.860.4255.6416.910.060.250.232.310.800.012.214.044.060.081.140.290.010.001.290.492.340.750.160.102.470.280.510.110.281.131.490.121.352.370.010.210.510.561.370.401.860.210.141.080.2325.820.191.860.383.250.380.56246.660.010.100.020.170.272.251.550.340.140.050.060.090.08360.860.181.070.240.66
pg-src-master--33652.93931.430.930.010.57204.561.130.072.420.050.6131.4967.430.240.120.921.010.230.070.204.456.766.830.010.010.640.840.981.860.4154.5616.830.060.250.242.300.810.012.243.913.910.111.130.330.010.001.280.482.300.750.160.062.420.320.470.110.201.091.710.121.352.290.010.210.490.561.360.391.850.210.141.080.1525.580.191.720.383.040.370.55243.340.010.100.020.170.272.251.570.340.140.050.070.090.08195.930.201.050.240.67
pg-src-16--32706.190.000.970.020.59207.021.130.062.570.050.6430.9068.120.140.090.900.700.300.070.124.716.956.930.010.010.630.570.981.970.4155.7917.180.050.210.252.290.820.012.184.274.280.081.150.290.010.001.290.502.190.760.160.062.630.290.480.110.291.061.090.121.582.260.010.220.500.601.470.301.910.230.141.130.2520.700.212.060.392.840.400.55249.230.010.100.030.170.272.201.700.360.150.050.070.090.09174.600.211.070.250.38


Benchmark s64da_ssb
InstancetotalqueryQ1.1queryQ1.2queryQ1.3queryQ2.1queryQ2.2queryQ2.3queryQ3.1queryQ3.2queryQ3.3queryQ3.4queryQ4.1queryQ4.2queryQ4.3
pg-src-16--132.622.552.462.452.512.392.123.152.091.891.883.293.122.73
pg-src-master--131.012.392.372.302.382.271.983.331.941.761.753.032.912.60
pg-src-16--233.172.572.442.442.782.402.153.132.331.891.903.263.112.77
pg-src-master--231.342.412.322.282.642.292.013.341.961.751.743.082.962.56
pg-src-master--330.312.392.352.262.632.241.982.921.921.751.753.032.922.19
pg-src-16--333.382.542.452.432.792.392.183.512.111.891.893.373.102.73


Benchmark job
Instancequery10aquery10bquery10cquery11aquery11bquery11cquery11dquery12aquery12bquery12cquery13aquery13bquery13cquery13dquery14aquery14bquery14cquery15aquery15bquery15cquery15dquery16aquery16bquery16cquery16dquery17aquery17bquery17cquery17dquery17equery17fquery18aquery18bquery18cquery19aquery19bquery19cquery19dquery1aquery1bquery1cquery1dquery20aquery20bquery20cquery21aquery21bquery21cquery22aquery22bquery22cquery22dquery23aquery23bquery23cquery24aquery24bquery25aquery25bquery25cquery26aquery26bquery26cquery27aquery27bquery27cquery28aquery28bquery28cquery29aquery29bquery29cquery2aquery2bquery2cquery2dquery30aquery30bquery30cquery31aquery31bquery31cquery32aquery32bquery33aquery33bquery33cquery3aquery3bquery3cquery4aquery4bquery4cquery5aquery5bquery5cquery6aquery6bquery6cquery6dquery6equery6fquery7aquery7bquery7cquery8aquery8bquery8cquery8dquery9aquery9bquery9cquery9d
pg-src-16--10.570.393.310.440.101.124.630.400.061.051.260.660.624.370.670.170.970.320.040.860.960.2217.331.661.299.717.867.647.6511.5510.060.400.576.443.970.226.647.210.080.060.060.062.561.160.820.350.260.490.630.472.181.400.580.070.371.940.074.090.6511.700.770.170.770.340.220.740.520.572.370.110.080.210.500.490.460.6012.300.7111.663.210.683.250.011.2214.790.860.910.170.120.240.090.120.100.170.160.230.071.210.036.440.086.620.270.2013.162.350.195.053.192.681.452.474.51
pg-src-master--10.560.383.160.280.091.144.700.400.061.071.350.680.652.040.690.180.980.330.040.710.910.2417.311.651.339.637.897.567.6811.3210.060.521.366.360.300.196.496.960.080.050.060.052.591.170.840.350.250.490.620.472.201.400.680.070.351.410.074.000.5011.860.410.210.830.340.210.750.840.571.130.320.070.210.500.490.450.602.980.703.743.200.693.250.021.243.141.942.520.180.120.260.100.120.110.160.160.220.071.340.057.190.097.300.260.1812.192.320.194.873.130.290.262.274.30
pg-src-16--20.570.393.320.280.091.134.730.400.061.071.280.660.631.990.660.170.960.340.040.850.950.2317.181.641.329.617.807.567.6511.329.950.401.356.353.950.216.587.140.080.060.060.062.611.160.810.360.250.490.620.442.141.370.590.070.371.750.083.930.5012.290.380.210.740.340.210.740.870.422.240.110.070.220.500.480.450.6211.580.685.643.220.673.200.021.232.5522.092.520.170.120.260.100.120.110.170.160.220.061.220.046.370.086.460.280.2012.202.330.194.833.172.680.312.464.56
pg-src-master--20.560.383.180.280.091.134.730.400.061.091.350.690.662.060.680.181.040.330.042.480.910.2217.341.641.309.757.867.587.7211.5010.164.711.376.333.860.206.516.960.070.050.060.062.631.180.870.360.260.500.650.482.241.460.670.070.801.770.074.080.5111.990.400.211.210.280.210.740.950.570.460.160.080.220.510.480.450.605.400.7011.383.230.683.260.011.242.750.892.510.190.120.260.100.120.110.170.150.230.071.350.057.210.087.310.260.1812.292.320.204.963.112.441.462.284.29
pg-src-master--30.570.393.160.280.091.144.730.420.061.101.360.700.664.620.670.180.970.340.040.720.910.2217.841.681.329.818.007.767.9111.5910.230.401.416.443.960.206.667.010.080.050.060.052.661.180.750.360.260.490.640.482.201.400.560.080.351.920.084.000.5011.720.820.222.280.370.210.760.670.432.420.250.070.170.500.500.470.612.160.6811.693.240.693.260.021.251.080.782.540.180.120.270.100.120.110.160.160.220.071.410.057.390.097.540.270.1912.562.400.205.003.122.461.502.314.35
pg-src-16--30.580.393.300.280.091.134.630.400.061.071.280.670.621.990.670.170.950.340.040.860.960.2417.021.641.309.727.817.617.6411.2310.000.381.366.473.960.206.617.160.080.060.060.062.621.170.650.340.260.480.600.442.151.390.580.070.361.770.083.980.5011.680.740.202.060.340.320.760.930.562.270.150.450.230.500.480.440.595.420.713.753.170.673.190.021.212.200.802.500.190.120.270.100.120.110.170.170.210.071.290.046.470.086.590.270.2012.022.330.205.043.202.640.292.464.49


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--12239310.80357117.05127288.29346271.0414671.858812.62151218.93176010.6925207.98214379.86144092.4378.54357117.05127288.29346271.04234749.59176329.50151218.93176010.69151504.88214379.86144092.43
pg-src-master--12412944.91366778.22130358.55353037.5214972.689127.93150506.38180389.1129556.30259400.37147098.7885.12366778.22130358.55353037.52239562.80182645.81150506.38180389.11177648.26259400.37147098.78
pg-src-16--22294793.78368366.64128020.20353459.5214812.038949.93151231.72179670.4029632.32218079.77146280.2580.66368366.64128020.20353459.52236992.56179080.25151231.72179670.40178106.37218079.77146280.25
pg-src-master--22414900.66362718.87129802.73349019.4714932.079294.81148078.97175166.7728153.47255868.12143556.8885.22362718.87129802.73349019.47238913.13185988.55148078.97175166.77169203.11255868.12143556.88
pg-src-master--32359194.37367318.02128577.22354433.9514759.478948.13148556.96178381.9627852.43259281.03145294.3283.09367318.02128577.22354433.95236151.49179039.02148556.96178381.96167395.10259281.03145294.32
pg-src-16--32265793.45353323.64123067.01343356.0514549.858659.81146659.80170040.7627223.09213049.76139908.7379.55353323.64123067.01343356.05232797.57173282.06146659.80170040.76163622.61213049.76139908.73


Benchmark insert-1m
Instancetime
pg-src-16--136.99
pg-src-master--137.75
pg-src-16--237.79
pg-src-master--235.41
pg-src-master--335.72
pg-src-16--336.48