pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alexander Lakhin <exclusion@gmail.com>
To: Andres Freund <andres@anarazel.de>
To: Thomas Munro <thomas.munro@gmail.com>
To: Melanie Plageman <melanieplageman@gmail.com>
Cc: David Rowley <dgrowleyml@gmail.com>
Cc: Heikki Linnakangas <hlinnaka@iki.fi>
Cc: Pg Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Streaming read-ready sequential scan code
Date: Fri, 17 May 2024 16:00:00 +0300
Message-ID: <63a63690-dd92-c809-0b47-af05459e95d1@gmail.com> (raw)
In-Reply-To: <20240407221229.upgvhyf2gzflcawi@awork3.anarazel.de>
References: <CA+hUKG+wWKJ=mEXj0Xg06zQop6foV6dsirFYf2o7wMzbn_OKeA@mail.gmail.com>
	<CAAKRu_arLQjAknvDOa+DQkOPcZRtS257dETFLgrhEwAVdv+WBQ@mail.gmail.com>
	<CA+hUKG+q=sg+ifx5NRfBdX_EBAeoJC1fSuaYeQXLCYbN-7nKig@mail.gmail.com>
	<CA+hUKGKXZALJ=6aArUsXRJzBm=qvc4AWp7=iJNXJQqpbRLnD_w@mail.gmail.com>
	<CAAKRu_Z4hjfHvqomhjr0McYPYbtw7iW-5-gAyFCbLOfzTCOrbQ@mail.gmail.com>
	<CA+hUKGLT9s9KzU_EbYYOwKybP2YNLeoSLQZFWao7ut-Pi=CKjA@mail.gmail.com>
	<CAAKRu_b1BfikoH8GGGubDnY4-eXZE4PoVEkxwppMTmiW2_NrWQ@mail.gmail.com>
	<CA+hUKG+h8Whpv0YsJqjMVkjYX+80fTVc6oi-V+zxJvykLpLHYQ@mail.gmail.com>
	<CAAKRu_aU60EFTLnB86FY9NUT1KqjzjLC2u+DqBtBLWi_ZooFpQ@mail.gmail.com>
	<CA+hUKGJDdbmJGCm6CsnkuRKe24jGE1L22eBS3eAG=POXM7cxxA@mail.gmail.com>
	<20240407221229.upgvhyf2gzflcawi@awork3.anarazel.de>

Hello,

I decided to compare v17 vs v16 performance (as I did the last year [1])
and discovered that v17 loses to v16 in the pg_tpcds (s64da_tpcds)
benchmark, query15 (and several others, but I focused on this one):
Best pg-src-master--.* worse than pg-src-16--.* by 52.2 percents (229.84 > 151.03): pg_tpcds.query15
Average pg-src-master--.* worse than pg-src-16--.* by 53.4 percents (234.20 > 152.64): pg_tpcds.query15
Please look at the full html report attached in case you're interested.

(I used my pg-mark tool to measure/analyze performance, but I believe the
same results can be seen without it.)

`git bisect` for this performance degradation pointed at b7b0f3f27...

[1] https://www.postgresql.org/message-id/b32bed1b-0746-9b20-1472-4bdc9ca66d52%40gmail.com

Best regards,
Alexander

Attachments:

benchmark-results.html (text/html, 48.4K) download <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Postgres benchmarking results</title></head><style type="text/css"> td { text-align: right } tr td:first-child { text-align: left } tr th { text-align: center } </style><body><h3>Benchmarking run started at 2024-05-14T12:04:26, ended at 2024-05-15T05:44:15</h3><div><table border="1" cellspacing="0"><caption>Benchmark version</caption><thead><tr><th>Instance</th><th>version</th></tr></thead><tbody><tr><td>pg-src-16--1</td><td>PostgreSQL 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</td></tr><tr><td>pg-src-master--1</td><td>PostgreSQL 17devel-master/2e810bdb7f on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit</td></tr><tr><td>pg-src-16--2</td><td>PostgreSQL 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</td></tr><tr><td>pg-src-master--2</td><td>PostgreSQL 17devel-master/2e810bdb7f on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit</td></tr><tr><td>pg-src-master--3</td><td>PostgreSQL 17devel-master/2e810bdb7f on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit</td></tr><tr><td>pg-src-16--3</td><td>PostgreSQL 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</td></tr></tbody></table><br></br><table border="1" cellspacing="0"><caption>Benchmark pgbench_native</caption><thead><tr><th>Instance</th><th>tps</th></tr></thead><tbody><tr><td>pg-src-16--1</td><td>10478.49</td></tr><tr><td>pg-src-master--1</td><td>10662.36</td></tr><tr><td>pg-src-16--2</td><td>10491.77</td></tr><tr><td>pg-src-master--2</td><td>10700.65</td></tr><tr><td>pg-src-master--3</td><td>10565.92</td></tr><tr><td>pg-src-16--3</td><td>10555.88</td></tr></tbody></table><br></br><table border="1" cellspacing="0"><caption>Benchmark pgbench_reference</caption><thead><tr><th>Instance</th><th>latency_​avg</th><th>tps1</th><th>tps2</th></tr></thead><tbody><tr><td>pg-src-16--1</td><td>8.59</td><td>7452.80</td><td>7452.84</td></tr><tr><td>pg-src-master--1</td><td>8.42</td><td>7597.85</td><td>7597.88</td></tr><tr><td>pg-src-16--2</td><td>8.52</td><td>7508.75</td><td>7508.79</td></tr><tr><td>pg-src-master--2</td><td>8.48</td><td>7545.73</td><td>7545.77</td></tr><tr><td>pg-src-master--3</td><td>8.37</td><td>7649.51</td><td>7649.55</td></tr><tr><td>pg-src-16--3</td><td>8.54</td><td>7498.92</td><td>7498.95</td></tr></tbody></table><br></br><table border="1" cellspacing="0"><caption>Benchmark pg_tpch</caption><thead><tr><th>Instance</th><th>query1</th><th>query2</th><th>query3</th><th>query4</th><th>query5</th><th>query6</th><th>query7</th><th>query8</th><th>query9</th><th>query10</th><th>query11</th><th>query12</th><th>query13</th><th>query14</th><th>query15</th><th>query16</th><th>query17</th><th>query18</th><th>query19</th><th>query20</th><th>query21</th><th>query22</th></tr></thead><tbody><tr><td>pg-src-16--1</td><td>9.59</td><td>1.47</td><td>3.00</td><td>0.70</td><td>0.90</td><td>1.47</td><td>2.97</td><td>4.56</td><td>0.94</td><td>2.47</td><td>0.77</td><td>2.23</td><td>2.87</td><td>0.88</td><td>3.20</td><td>0.97</td><td>8.70</td><td>14.41</td><td>0.19</td><td>5.84</td><td>2.36</td><td>0.23</td></tr><tr><td>pg-src-master--1</td><td>9.11</td><td>1.54</td><td>2.88</td><td>0.70</td><td>0.89</td><td>1.40</td><td>2.83</td><td>4.75</td><td>0.87</td><td>2.39</td><td>0.75</td><td>2.13</td><td>2.83</td><td>0.89</td><td>3.06</td><td>1.00</td><td>8.32</td><td>13.97</td><td>0.19</td><td>5.55</td><td>2.30</td><td>0.22</td></tr><tr><td>pg-src-16--2</td><td>9.61</td><td>1.49</td><td>3.04</td><td>0.71</td><td>0.93</td><td>1.47</td><td>2.96</td><td>4.69</td><td>0.86</td><td>2.50</td><td>0.78</td><td>2.21</td><td>2.88</td><td>0.88</td><td>3.20</td><td>1.00</td><td>8.82</td><td>14.20</td><td>0.20</td><td>5.85</td><td>2.36</td><td>0.23</td></tr><tr><td>pg-src-master--2</td><td>9.05</td><td>1.49</td><td>2.85</td><td>0.70</td><td>0.87</td><td>1.37</td><td>2.82</td><td>4.47</td><td>0.87</td><td>2.35</td><td>0.77</td><td>2.14</td><td>2.67</td><td>0.88</td><td>3.03</td><td>0.99</td><td>8.27</td><td>14.24</td><td>0.19</td><td>5.57</td><td>2.30</td><td>0.22</td></tr><tr><td>pg-src-master--3</td><td>10.12</td><td>1.48</td><td>2.88</td><td>0.69</td><td>0.88</td><td>1.39</td><td>2.84</td><td>4.73</td><td>0.88</td><td>2.40</td><td>0.78</td><td>2.14</td><td>2.80</td><td>0.88</td><td>3.08</td><td>1.00</td><td>8.28</td><td>14.18</td><td>0.19</td><td>5.56</td><td>2.33</td><td>0.22</td></tr><tr><td>pg-src-16--3</td><td>9.72</td><td>1.47</td><td>3.01</td><td>0.70</td><td>0.91</td><td>1.46</td><td>2.95</td><td>4.67</td><td>0.96</td><td>2.50</td><td>0.78</td><td>2.20</td><td>2.71</td><td>0.87</td><td>3.22</td><td>1.00</td><td>8.69</td><td>14.40</td><td>0.19</td><td>5.98</td><td>2.34</td><td>0.23</td></tr></tbody></table><br></br><table border="1" cellspacing="0"><caption>Benchmark pg_tpcds</caption><thead><tr><th>Instance</th><th>load_​size</th><th>indexes_​size</th><th>vacuum_​full_​size</th><th>vacuum_​freeze_​size</th><th>load_​time</th><th>indexes_​time</th><th>vacuum_​full_​time</th><th>vacuum_​freeze_​time</th><th>analyze_​time</th><th>query92</th><th>query91</th><th>query13</th><th>query9</th><th>query21</th><th>query90</th><th>query93</th><th>query16</th><th>query68</th><th>query48</th><th>query76</th><th>query7</th><th>query37</th><th>query43</th><th>query72</th><th>query82</th><th>query79</th><th>query55</th><th>query66</th><th>query71</th><th>query69</th><th>query34</th><th>query45</th><th>query10</th><th>query28</th><th>query3</th><th>query15</th><th>query50</th><th>query85</th><th>query84</th><th>query42</th><th>query73</th><th>query94</th><th>query46</th><th>query88</th><th>query19</th><th>query40</th><th>query26</th><th>query96</th><th>query6</th><th>query52</th></tr></thead><tbody><tr><td>pg-src-16--1</td><td>5069460.00</td><td>7250212.00</td><td>6939852.00</td><td>6942528.00</td><td>78.36</td><td>73.23</td><td>96.68</td><td>2.29</td><td>3.48</td><td>83.49</td><td>44.95</td><td>638.87</td><td>1466.98</td><td>157.23</td><td>149.80</td><td>4.96</td><td>105.36</td><td>278.76</td><td>774.01</td><td>380.49</td><td>1194.28</td><td>8.21</td><td>713.20</td><td>20492.58</td><td>10.40</td><td>346.13</td><td>297.64</td><td>302.20</td><td>241.78</td><td>115.87</td><td>246.68</td><td>133.86</td><td>31.62</td><td>667.38</td><td>30.43</td><td>153.41</td><td>78.77</td><td>182.25</td><td>15.65</td><td>294.41</td><td>205.36</td><td>77.62</td><td>498.71</td><td>1670.38</td><td>313.13</td><td>74.38</td><td>596.20</td><td>202.61</td><td>23918.69</td><td>311.14</td></tr><tr><td>pg-src-master--1</td><td>5069628.00</td><td>7250072.00</td><td>6939856.00</td><td>6942528.00</td><td>79.87</td><td>71.63</td><td>92.83</td><td>2.16</td><td>3.46</td><td>82.14</td><td>45.80</td><td>612.61</td><td>1355.02</td><td>201.37</td><td>137.85</td><td>4.95</td><td>145.74</td><td>253.06</td><td>752.50</td><td>376.79</td><td>1203.26</td><td>8.36</td><td>692.81</td><td>25286.10</td><td>9.13</td><td>325.84</td><td>271.36</td><td>412.45</td><td>252.12</td><td>114.83</td><td>228.80</td><td>132.14</td><td>31.34</td><td>653.31</td><td>29.11</td><td>229.84</td><td>77.31</td><td>184.56</td><td>14.86</td><td>268.99</td><td>182.63</td><td>69.12</td><td>479.66</td><td>1515.73</td><td>297.10</td><td>96.46</td><td>955.47</td><td>185.35</td><td>17137.62</td><td>274.60</td></tr><tr><td>pg-src-16--2</td><td>5069288.00</td><td>7249988.00</td><td>6939848.00</td><td>6942520.00</td><td>77.36</td><td>73.27</td><td>95.92</td><td>2.24</td><td>3.41</td><td>82.84</td><td>47.27</td><td>639.83</td><td>1450.85</td><td>158.35</td><td>154.49</td><td>4.76</td><td>101.82</td><td>277.17</td><td>779.26</td><td>387.13</td><td>1202.08</td><td>8.26</td><td>714.58</td><td>20769.88</td><td>10.32</td><td>348.23</td><td>288.74</td><td>304.59</td><td>243.07</td><td>114.51</td><td>249.44</td><td>137.42</td><td>32.46</td><td>662.65</td><td>29.54</td><td>153.47</td><td>80.16</td><td>119.14</td><td>16.45</td><td>295.05</td><td>207.38</td><td>77.66</td><td>506.87</td><td>1686.13</td><td>319.24</td><td>73.34</td><td>584.07</td><td>204.55</td><td>23798.14</td><td>291.23</td></tr><tr><td>pg-src-master--2</td><td>5069476.00</td><td>7249892.00</td><td>6939860.00</td><td>6942500.00</td><td>79.95</td><td>70.72</td><td>92.64</td><td>3.10</td><td>3.41</td><td>78.34</td><td>44.75</td><td>610.52</td><td>1362.95</td><td>195.95</td><td>141.65</td><td>5.19</td><td>140.07</td><td>253.17</td><td>754.75</td><td>385.32</td><td>1209.35</td><td>7.56</td><td>686.49</td><td>25771.90</td><td>9.17</td><td>329.43</td><td>290.55</td><td>415.04</td><td>224.55</td><td>119.17</td><td>229.24</td><td>135.60</td><td>31.45</td><td>657.64</td><td>29.96</td><td>236.34</td><td>81.87</td><td>182.69</td><td>15.04</td><td>277.01</td><td>184.94</td><td>70.63</td><td>494.84</td><td>1523.35</td><td>306.65</td><td>103.54</td><td>975.26</td><td>185.29</td><td>17169.69</td><td>278.12</td></tr><tr><td>pg-src-master--3</td><td>5069584.00</td><td>7249996.00</td><td>6939856.00</td><td>6942500.00</td><td>78.94</td><td>71.08</td><td>93.27</td><td>3.11</td><td>3.43</td><td>77.44</td><td>47.19</td><td>610.86</td><td>1386.95</td><td>193.86</td><td>140.13</td><td>4.83</td><td>154.89</td><td>257.04</td><td>756.67</td><td>378.82</td><td>1213.10</td><td>7.62</td><td>688.18</td><td>25978.55</td><td>9.44</td><td>328.20</td><td>278.73</td><td>417.64</td><td>226.57</td><td>119.25</td><td>231.79</td><td>135.54</td><td>31.99</td><td>654.80</td><td>30.82</td><td>236.43</td><td>56.91</td><td>117.99</td><td>14.63</td><td>281.26</td><td>183.65</td><td>71.78</td><td>479.82</td><td>1534.32</td><td>301.89</td><td>98.00</td><td>1002.00</td><td>184.58</td><td>17194.48</td><td>284.33</td></tr><tr><td>pg-src-16--3</td><td>5069352.00</td><td>7250108.00</td><td>6939852.00</td><td>6942524.00</td><td>78.62</td><td>73.41</td><td>96.99</td><td>2.26</td><td>3.42</td><td>80.12</td><td>46.32</td><td>640.69</td><td>1455.49</td><td>160.60</td><td>149.99</td><td>4.21</td><td>101.03</td><td>273.02</td><td>775.44</td><td>377.31</td><td>1200.69</td><td>8.19</td><td>719.68</td><td>20943.10</td><td>10.56</td><td>350.66</td><td>286.82</td><td>316.33</td><td>247.52</td><td>114.07</td><td>246.41</td><td>136.98</td><td>32.20</td><td>662.66</td><td>31.10</td><td>151.03</td><td>58.40</td><td>118.75</td><td>15.56</td><td>288.93</td><td>204.55</td><td>75.92</td><td>496.13</td><td>1668.00</td><td>309.48</td><td>74.48</td><td>597.69</td><td>204.43</td><td>24008.34</td><td>284.83</td></tr></tbody></table><br></br><table border="1" cellspacing="0"><caption>Benchmark ycsb</caption><thead><tr><th>Instance</th><th>load_​a_​size</th><th>load_​b_​size</th><th>load_​c_​size</th><th>load_​d_​size</th><th>load_​f_​size</th><th>load_​a_​time</th><th>load_​b_​time</th><th>load_​c_​time</th><th>load_​d_​time</th><th>load_​f_​time</th><th>load_​a_​10_​runtime</th><th>load_​a_​25_​runtime</th><th>load_​a_​50_​runtime</th><th>load_​b_​10_​runtime</th><th>load_​b_​25_​runtime</th><th>load_​b_​50_​runtime</th><th>load_​c_​10_​runtime</th><th>load_​c_​25_​runtime</th><th>load_​c_​50_​runtime</th><th>load_​d_​10_​runtime</th><th>load_​d_​25_​runtime</th><th>load_​d_​50_​runtime</th><th>load_​f_​10_​runtime</th><th>load_​f_​25_​runtime</th><th>load_​f_​50_​runtime</th><th>load_​a_​10_​ops</th><th>load_​a_​25_​ops</th><th>load_​a_​50_​ops</th><th>load_​b_​10_​ops</th><th>load_​b_​25_​ops</th><th>load_​b_​50_​ops</th><th>load_​c_​10_​ops</th><th>load_​c_​25_​ops</th><th>load_​c_​50_​ops</th><th>load_​d_​10_​ops</th><th>load_​d_​25_​ops</th><th>load_​d_​50_​ops</th><th>load_​f_​10_​ops</th><th>load_​f_​25_​ops</th><th>load_​f_​50_​ops</th></tr></thead><tbody><tr><td>pg-src-16--1</td><td>2259520.00</td><td>2277336.00</td><td>2276716.00</td><td>2277160.00</td><td>2279244.00</td><td>41.94</td><td>40.17</td><td>43.10</td><td>41.86</td><td>41.26</td><td>7366.00</td><td>5305.00</td><td>5350.00</td><td>4996.00</td><td>3869.00</td><td>3402.00</td><td>4833.00</td><td>3063.00</td><td>2965.00</td><td>4495.00</td><td>3202.00</td><td>3172.00</td><td>9529.00</td><td>6783.00</td><td>7001.00</td><td>135758.89</td><td>188501.41</td><td>186915.89</td><td>200160.13</td><td>258464.72</td><td>293944.74</td><td>206910.82</td><td>326477.31</td><td>337268.13</td><td>222469.41</td><td>312304.81</td><td>315258.51</td><td>104942.81</td><td>147427.39</td><td>142836.74</td></tr><tr><td>pg-src-master--1</td><td>2259484.00</td><td>2277312.00</td><td>2277100.00</td><td>2277144.00</td><td>2278592.00</td><td>40.38</td><td>40.02</td><td>40.88</td><td>40.06</td><td>40.26</td><td>7373.00</td><td>5476.00</td><td>5748.00</td><td>4875.00</td><td>3857.00</td><td>3546.00</td><td>4662.00</td><td>3057.00</td><td>3044.00</td><td>4540.00</td><td>3143.00</td><td>3124.00</td><td>11351.00</td><td>6673.00</td><td>7118.00</td><td>135630.00</td><td>182615.05</td><td>173973.56</td><td>205128.21</td><td>259268.86</td><td>282007.90</td><td>214500.21</td><td>327118.09</td><td>328515.11</td><td>220264.32</td><td>318167.36</td><td>320102.43</td><td>88097.96</td><td>149857.64</td><td>140488.90</td></tr><tr><td>pg-src-16--2</td><td>2259516.00</td><td>2277596.00</td><td>2277496.00</td><td>2277160.00</td><td>2277960.00</td><td>42.14</td><td>41.74</td><td>41.35</td><td>42.36</td><td>40.76</td><td>7756.00</td><td>5401.00</td><td>5390.00</td><td>5677.00</td><td>3500.00</td><td>3375.00</td><td>4539.00</td><td>3140.00</td><td>3102.00</td><td>4616.00</td><td>3137.00</td><td>3118.00</td><td>9125.00</td><td>6741.00</td><td>6680.00</td><td>128932.44</td><td>185150.90</td><td>185528.76</td><td>176149.37</td><td>285714.29</td><td>296296.30</td><td>220312.84</td><td>318471.34</td><td>322372.66</td><td>216637.78</td><td>318775.90</td><td>320718.41</td><td>109589.04</td><td>148345.94</td><td>149700.60</td></tr><tr><td>pg-src-master--2</td><td>2259488.00</td><td>2277572.00</td><td>2277480.00</td><td>2277148.00</td><td>2277948.00</td><td>42.25</td><td>41.53</td><td>42.64</td><td>41.02</td><td>42.85</td><td>7219.00</td><td>5504.00</td><td>5880.00</td><td>5672.00</td><td>3420.00</td><td>3310.00</td><td>4586.00</td><td>3081.00</td><td>3165.00</td><td>4484.00</td><td>3122.00</td><td>3082.00</td><td>9116.00</td><td>6910.00</td><td>7384.00</td><td>138523.34</td><td>181686.05</td><td>170068.03</td><td>176304.65</td><td>292397.66</td><td>302114.80</td><td>218054.95</td><td>324569.94</td><td>315955.77</td><td>223015.17</td><td>320307.50</td><td>324464.63</td><td>109697.24</td><td>144717.80</td><td>135427.95</td></tr><tr><td>pg-src-master--3</td><td>2259492.00</td><td>2277568.00</td><td>2277216.00</td><td>2277140.00</td><td>2279476.00</td><td>41.86</td><td>40.83</td><td>42.67</td><td>41.41</td><td>40.76</td><td>7401.00</td><td>5446.00</td><td>5812.00</td><td>5541.00</td><td>3447.00</td><td>3393.00</td><td>4635.00</td><td>3059.00</td><td>3069.00</td><td>4609.00</td><td>3150.00</td><td>3056.00</td><td>9011.00</td><td>6827.00</td><td>7057.00</td><td>135116.88</td><td>183621.01</td><td>172057.81</td><td>180472.84</td><td>290107.34</td><td>294724.43</td><td>215749.73</td><td>326904.22</td><td>325839.04</td><td>216966.80</td><td>317460.32</td><td>327225.13</td><td>110975.47</td><td>146477.22</td><td>141703.27</td></tr><tr><td>pg-src-16--3</td><td>2259512.00</td><td>2277344.00</td><td>2276732.00</td><td>2277164.00</td><td>2279500.00</td><td>40.10</td><td>41.73</td><td>42.44</td><td>42.34</td><td>40.73</td><td>7477.00</td><td>5357.00</td><td>5413.00</td><td>4903.00</td><td>3936.00</td><td>3453.00</td><td>4681.00</td><td>3085.00</td><td>3180.00</td><td>4521.00</td><td>3165.00</td><td>3097.00</td><td>9308.00</td><td>6835.00</td><td>6792.00</td><td>133743.48</td><td>186671.64</td><td>184740.44</td><td>203956.76</td><td>254065.04</td><td>289603.24</td><td>213629.57</td><td>324149.11</td><td>314465.41</td><td>221190.00</td><td>315955.77</td><td>322893.12</td><td>107434.46</td><td>146305.78</td><td>147232.04</td></tr></tbody></table><br></br><table border="1" cellspacing="0"><caption>Benchmark benchmarksql_tpcc</caption><thead><tr><th>Instance</th><th>tpm_​total</th><th>xacts</th><th>data_​size</th></tr></thead><tbody><tr><td>pg-src-16--1</td><td>205365.00</td><td>616142.00</td><td>2770484.00</td></tr><tr><td>pg-src-master--1</td><td>180032.00</td><td>540147.00</td><td>2662452.00</td></tr><tr><td>pg-src-16--2</td><td>193129.00</td><td>579412.00</td><td>2730544.00</td></tr><tr><td>pg-src-master--2</td><td>212485.00</td><td>637487.00</td><td>2759256.00</td></tr><tr><td>pg-src-master--3</td><td>198731.00</td><td>596240.00</td><td>2713388.00</td></tr><tr><td>pg-src-16--3</td><td>215657.00</td><td>646981.00</td><td>2808516.00</td></tr></tbody></table><br></br><table border="1" cellspacing="0"><caption>Benchmark benchbase</caption><thead><tr><th>Instance</th><th>auctionmark_​rps</th><th>epinions_​rps</th><th>hyadapt_​rps</th><th>otmetrics_​rps</th><th>resourcestresser_​rps</th><th>seats_​rps</th><th>sibench_​rps</th><th>smallbank_​rps</th><th>tatp_​rps</th><th>tpcc_​rps</th><th>tpch_​rps</th><th>twitter_​rps</th><th>voter_​rps</th><th>ycsb_​rps</th></tr></thead><tbody><tr><td>pg-src-16--1</td><td>155.13</td><td>79317.56</td><td>13920.48</td><td>7118.98</td><td>1.26</td><td>10926.70</td><td>54185.90</td><td>36860.46</td><td>97460.04</td><td>6959.84</td><td>0.29</td><td>73358.83</td><td>44008.30</td><td>123319.57</td></tr><tr><td>pg-src-master--1</td><td>142.97</td><td>85651.30</td><td>13785.14</td><td>7081.71</td><td>1.51</td><td>11051.04</td><td>54174.94</td><td>35307.73</td><td>99901.16</td><td>6405.83</td><td>0.29</td><td>75820.46</td><td>43766.91</td><td>127570.43</td></tr><tr><td>pg-src-16--2</td><td>161.67</td><td>82043.68</td><td>15250.94</td><td>6943.96</td><td>1.15</td><td>9698.12</td><td>78324.62</td><td>35008.89</td><td>96210.59</td><td>6962.83</td><td>0.29</td><td>75629.01</td><td>45061.72</td><td>125973.72</td></tr><tr><td>pg-src-master--2</td><td>145.55</td><td>86317.04</td><td>14594.67</td><td>7615.51</td><td>1.36</td><td>10106.41</td><td>62849.73</td><td>34462.66</td><td>99531.49</td><td>6221.76</td><td>0.30</td><td>74995.02</td><td>45214.80</td><td>127572.59</td></tr><tr><td>pg-src-master--3</td><td>158.90</td><td>86684.36</td><td>13765.86</td><td>7844.34</td><td>1.03</td><td>10552.68</td><td>53621.81</td><td>35164.37</td><td>97183.46</td><td>6897.16</td><td>0.29</td><td>75698.36</td><td>44001.27</td><td>125992.97</td></tr><tr><td>pg-src-16--3</td><td>170.17</td><td>81167.01</td><td>14691.79</td><td>7119.66</td><td>1.41</td><td>9676.44</td><td>65311.71</td><td>37311.84</td><td>100287.26</td><td>6853.22</td><td>0.29</td><td>73851.38</td><td>44620.00</td><td>124705.11</td></tr></tbody></table><br></br><table border="1" cellspacing="0"><caption>Benchmark gdprbench</caption><thead><tr><th>Instance</th><th>load_​controller_​ops</th><th>run_​controller_​ops</th><th>load_​customer_​ops</th><th>run_​customer_​ops</th><th>load_​processor_​ops</th><th>run_​processor_​ops</th></tr></thead><tbody><tr><td>pg-src-16--1</td><td>17094.02</td><td>1788.91</td><td>17123.29</td><td>2000.00</td><td>16977.93</td><td>1297.02</td></tr><tr><td>pg-src-master--1</td><td>16835.02</td><td>1798.56</td><td>18691.59</td><td>2028.40</td><td>19841.27</td><td>1333.33</td></tr><tr><td>pg-src-16--2</td><td>17605.63</td><td>1763.67</td><td>16835.02</td><td>1893.94</td><td>16949.15</td><td>1344.09</td></tr><tr><td>pg-src-master--2</td><td>17035.78</td><td>1872.66</td><td>17301.04</td><td>2012.07</td><td>16863.41</td><td>1338.69</td></tr><tr><td>pg-src-master--3</td><td>17182.13</td><td>1808.32</td><td>17182.13</td><td>2036.66</td><td>17391.30</td><td>1356.85</td></tr><tr><td>pg-src-16--3</td><td>19230.77</td><td>1779.36</td><td>16077.17</td><td>1934.24</td><td>17391.30</td><td>1293.66</td></tr></tbody></table><br></br><table border="1" cellspacing="0"><caption>Benchmark s64da_tpch</caption><thead><tr><th>Instance</th><th>total</th><th>query1</th><th>query2</th><th>query3</th><th>query4</th><th>query5</th><th>query6</th><th>query7</th><th>query8</th><th>query9</th><th>query10</th><th>query11</th><th>query12</th><th>query13</th><th>query14</th><th>query15</th><th>query16</th><th>query17</th><th>query18</th><th>query19</th><th>query20</th><th>query21</th><th>query22</th></tr></thead><tbody><tr><td>pg-src-16--1</td><td>68.09</td><td>9.24</td><td>1.42</td><td>2.90</td><td>0.90</td><td>1.60</td><td>1.36</td><td>1.91</td><td>1.13</td><td>4.70</td><td>2.23</td><td>0.71</td><td>2.50</td><td>2.89</td><td>0.86</td><td>1.53</td><td>1.03</td><td>4.31</td><td>20.66</td><td>0.18</td><td>1.03</td><td>4.79</td><td>0.21</td></tr><tr><td>pg-src-master--1</td><td>65.12</td><td>8.65</td><td>1.38</td><td>2.77</td><td>0.89</td><td>1.48</td><td>1.26</td><td>1.79</td><td>1.03</td><td>4.68</td><td>2.16</td><td>0.75</td><td>2.34</td><td>2.79</td><td>0.87</td><td>1.41</td><td>1.01</td><td>4.15</td><td>19.61</td><td>0.19</td><td>1.05</td><td>4.69</td><td>0.20</td></tr><tr><td>pg-src-16--2</td><td>67.31</td><td>9.23</td><td>1.37</td><td>2.89</td><td>0.89</td><td>1.61</td><td>1.36</td><td>1.91</td><td>1.10</td><td>3.92</td><td>2.24</td><td>0.73</td><td>2.52</td><td>2.84</td><td>0.86</td><td>1.54</td><td>1.02</td><td>4.38</td><td>20.65</td><td>0.19</td><td>1.06</td><td>4.79</td><td>0.21</td></tr><tr><td>pg-src-master--2</td><td>64.30</td><td>8.68</td><td>1.38</td><td>2.76</td><td>0.90</td><td>1.56</td><td>1.25</td><td>1.80</td><td>1.09</td><td>3.91</td><td>2.12</td><td>0.73</td><td>2.33</td><td>2.84</td><td>0.87</td><td>1.43</td><td>1.01</td><td>4.15</td><td>19.49</td><td>0.18</td><td>1.05</td><td>4.59</td><td>0.20</td></tr><tr><td>pg-src-master--3</td><td>64.90</td><td>8.69</td><td>1.40</td><td>2.75</td><td>0.89</td><td>1.58</td><td>1.29</td><td>1.81</td><td>1.06</td><td>4.01</td><td>2.16</td><td>0.74</td><td>2.34</td><td>2.84</td><td>0.87</td><td>1.47</td><td>1.02</td><td>4.24</td><td>19.58</td><td>0.18</td><td>1.15</td><td>4.63</td><td>0.20</td></tr><tr><td>pg-src-16--3</td><td>68.25</td><td>9.28</td><td>1.39</td><td>2.89</td><td>0.89</td><td>1.62</td><td>1.37</td><td>1.93</td><td>1.09</td><td>4.70</td><td>2.28</td><td>0.74</td><td>2.51</td><td>2.84</td><td>0.87</td><td>1.53</td><td>1.02</td><td>4.31</td><td>20.78</td><td>0.19</td><td>1.04</td><td>4.78</td><td>0.21</td></tr></tbody></table><br></br><table border="1" cellspacing="0"><caption>Benchmark s64da_tpcds</caption><thead><tr><th>Instance</th><th>total</th><th>query1</th><th>query2</th><th>query3</th><th>query5</th><th>query6</th><th>query7</th><th>query8</th><th>query9</th><th>query12</th><th>query13</th><th>query14a</th><th>query14b</th><th>query15</th><th>query16</th><th>query17</th><th>query18</th><th>query19</th><th>query20</th><th>query21</th><th>query22</th><th>query23a</th><th>query23b</th><th>query24a</th><th>query24b</th><th>query25</th><th>query26</th><th>query27</th><th>query28</th><th>query29</th><th>query30</th><th>query31</th><th>query32</th><th>query33</th><th>query34</th><th>query35</th><th>query36</th><th>query37</th><th>query38</th><th>query39a</th><th>query39b</th><th>query40</th><th>query41</th><th>query42</th><th>query43</th><th>query44</th><th>query45</th><th>query46</th><th>query47</th><th>query48</th><th>query49</th><th>query50</th><th>query51</th><th>query52</th><th>query53</th><th>query54</th><th>query55</th><th>query56</th><th>query57</th><th>query58</th><th>query59</th><th>query60</th><th>query61</th><th>query62</th><th>query63</th><th>query64</th><th>query65</th><th>query66</th><th>query67</th><th>query68</th><th>query69</th><th>query70</th><th>query71</th><th>query72</th><th>query73</th><th>query75</th><th>query76</th><th>query78</th><th>query79</th><th>query80</th><th>query81</th><th>query82</th><th>query83</th><th>query84</th><th>query85</th><th>query86</th><th>query87</th><th>query88</th><th>query89</th><th>query90</th><th>query91</th><th>query92</th><th>query93</th><th>query94</th><th>query95</th><th>query96</th><th>query97</th><th>query98</th><th>query99</th></tr></thead><tbody><tr><td>pg-src-16--1</td><td>2709.68</td><td>0.00</td><td>0.97</td><td>0.02</td><td>0.58</td><td>206.97</td><td>1.15</td><td>0.07</td><td>2.58</td><td>0.05</td><td>0.64</td><td>31.46</td><td>68.61</td><td>0.14</td><td>0.10</td><td>0.94</td><td>0.70</td><td>0.24</td><td>0.07</td><td>0.12</td><td>4.77</td><td>7.09</td><td>7.05</td><td>0.01</td><td>0.01</td><td>0.65</td><td>0.57</td><td>0.99</td><td>1.99</td><td>0.42</td><td>55.83</td><td>17.15</td><td>0.05</td><td>0.34</td><td>0.25</td><td>2.32</td><td>0.82</td><td>0.01</td><td>2.19</td><td>4.29</td><td>4.36</td><td>0.08</td><td>1.16</td><td>0.32</td><td>0.01</td><td>0.00</td><td>1.32</td><td>0.50</td><td>2.21</td><td>0.78</td><td>0.16</td><td>0.07</td><td>2.62</td><td>0.32</td><td>0.48</td><td>0.11</td><td>0.22</td><td>1.11</td><td>1.10</td><td>0.12</td><td>1.58</td><td>2.38</td><td>0.01</td><td>0.22</td><td>0.50</td><td>0.62</td><td>1.49</td><td>0.29</td><td>1.94</td><td>0.23</td><td>0.14</td><td>1.14</td><td>0.15</td><td>21.70</td><td>0.21</td><td>2.07</td><td>0.38</td><td>2.92</td><td>0.40</td><td>0.42</td><td>248.99</td><td>0.01</td><td>0.10</td><td>0.03</td><td>0.18</td><td>0.27</td><td>2.21</td><td>1.73</td><td>0.36</td><td>0.15</td><td>0.05</td><td>0.07</td><td>0.10</td><td>0.09</td><td>175.40</td><td>0.21</td><td>1.07</td><td>0.26</td><td>0.39</td></tr><tr><td>pg-src-master--1</td><td>3652.11</td><td>930.75</td><td>0.94</td><td>0.01</td><td>0.58</td><td>202.32</td><td>1.13</td><td>0.06</td><td>2.41</td><td>0.05</td><td>0.62</td><td>31.57</td><td>68.06</td><td>0.23</td><td>0.12</td><td>0.91</td><td>1.02</td><td>0.30</td><td>0.07</td><td>0.20</td><td>4.46</td><td>6.85</td><td>6.85</td><td>0.01</td><td>0.01</td><td>0.64</td><td>0.84</td><td>0.98</td><td>1.86</td><td>0.42</td><td>54.56</td><td>16.92</td><td>0.06</td><td>0.25</td><td>0.23</td><td>2.35</td><td>0.80</td><td>0.01</td><td>2.20</td><td>3.93</td><td>3.94</td><td>0.11</td><td>1.14</td><td>0.28</td><td>0.01</td><td>0.00</td><td>1.33</td><td>0.48</td><td>2.31</td><td>0.75</td><td>0.16</td><td>0.06</td><td>2.44</td><td>0.28</td><td>0.50</td><td>0.11</td><td>0.28</td><td>1.11</td><td>1.47</td><td>0.12</td><td>1.35</td><td>2.35</td><td>0.01</td><td>0.21</td><td>0.48</td><td>0.56</td><td>1.37</td><td>0.40</td><td>1.86</td><td>0.21</td><td>0.14</td><td>1.08</td><td>0.24</td><td>25.95</td><td>0.19</td><td>1.85</td><td>0.38</td><td>3.23</td><td>0.37</td><td>0.56</td><td>243.61</td><td>0.01</td><td>0.10</td><td>0.02</td><td>0.17</td><td>0.27</td><td>2.23</td><td>1.56</td><td>0.34</td><td>0.14</td><td>0.05</td><td>0.06</td><td>0.09</td><td>0.08</td><td>195.95</td><td>0.19</td><td>1.07</td><td>0.24</td><td>0.69</td></tr><tr><td>pg-src-16--2</td><td>2706.13</td><td>0.00</td><td>0.96</td><td>0.01</td><td>0.61</td><td>206.37</td><td>1.15</td><td>0.06</td><td>2.59</td><td>0.05</td><td>0.65</td><td>31.55</td><td>68.61</td><td>0.13</td><td>0.09</td><td>0.92</td><td>0.71</td><td>0.24</td><td>0.07</td><td>0.12</td><td>4.74</td><td>7.01</td><td>6.92</td><td>0.01</td><td>0.01</td><td>0.66</td><td>0.53</td><td>0.99</td><td>1.97</td><td>0.41</td><td>55.69</td><td>17.31</td><td>0.05</td><td>0.21</td><td>0.26</td><td>2.31</td><td>0.82</td><td>0.01</td><td>2.19</td><td>4.17</td><td>4.21</td><td>0.08</td><td>1.17</td><td>0.31</td><td>0.01</td><td>0.00</td><td>1.29</td><td>0.50</td><td>2.21</td><td>0.77</td><td>0.16</td><td>0.07</td><td>2.63</td><td>0.31</td><td>0.50</td><td>0.11</td><td>0.21</td><td>1.07</td><td>1.10</td><td>0.12</td><td>1.57</td><td>2.29</td><td>0.01</td><td>0.22</td><td>0.51</td><td>0.59</td><td>1.47</td><td>0.31</td><td>1.92</td><td>0.23</td><td>0.14</td><td>1.13</td><td>0.15</td><td>21.00</td><td>0.21</td><td>2.15</td><td>0.37</td><td>2.80</td><td>0.40</td><td>0.53</td><td>249.14</td><td>0.01</td><td>0.10</td><td>0.02</td><td>0.17</td><td>0.27</td><td>2.23</td><td>1.72</td><td>0.36</td><td>0.16</td><td>0.05</td><td>0.08</td><td>0.09</td><td>0.09</td><td>173.77</td><td>0.21</td><td>1.07</td><td>0.26</td><td>0.37</td></tr><tr><td>pg-src-master--2</td><td>3818.81</td><td>928.40</td><td>0.94</td><td>0.01</td><td>0.57</td><td>202.53</td><td>1.15</td><td>0.05</td><td>2.42</td><td>0.05</td><td>0.62</td><td>31.82</td><td>67.36</td><td>0.23</td><td>0.12</td><td>0.93</td><td>1.02</td><td>0.30</td><td>0.07</td><td>0.20</td><td>4.47</td><td>6.84</td><td>6.82</td><td>0.01</td><td>0.01</td><td>0.66</td><td>0.86</td><td>0.99</td><td>1.86</td><td>0.42</td><td>55.64</td><td>16.91</td><td>0.06</td><td>0.25</td><td>0.23</td><td>2.31</td><td>0.80</td><td>0.01</td><td>2.21</td><td>4.04</td><td>4.06</td><td>0.08</td><td>1.14</td><td>0.29</td><td>0.01</td><td>0.00</td><td>1.29</td><td>0.49</td><td>2.34</td><td>0.75</td><td>0.16</td><td>0.10</td><td>2.47</td><td>0.28</td><td>0.51</td><td>0.11</td><td>0.28</td><td>1.13</td><td>1.49</td><td>0.12</td><td>1.35</td><td>2.37</td><td>0.01</td><td>0.21</td><td>0.51</td><td>0.56</td><td>1.37</td><td>0.40</td><td>1.86</td><td>0.21</td><td>0.14</td><td>1.08</td><td>0.23</td><td>25.82</td><td>0.19</td><td>1.86</td><td>0.38</td><td>3.25</td><td>0.38</td><td>0.56</td><td>246.66</td><td>0.01</td><td>0.10</td><td>0.02</td><td>0.17</td><td>0.27</td><td>2.25</td><td>1.55</td><td>0.34</td><td>0.14</td><td>0.05</td><td>0.06</td><td>0.09</td><td>0.08</td><td>360.86</td><td>0.18</td><td>1.07</td><td>0.24</td><td>0.66</td></tr><tr><td>pg-src-master--3</td><td>3652.93</td><td>931.43</td><td>0.93</td><td>0.01</td><td>0.57</td><td>204.56</td><td>1.13</td><td>0.07</td><td>2.42</td><td>0.05</td><td>0.61</td><td>31.49</td><td>67.43</td><td>0.24</td><td>0.12</td><td>0.92</td><td>1.01</td><td>0.23</td><td>0.07</td><td>0.20</td><td>4.45</td><td>6.76</td><td>6.83</td><td>0.01</td><td>0.01</td><td>0.64</td><td>0.84</td><td>0.98</td><td>1.86</td><td>0.41</td><td>54.56</td><td>16.83</td><td>0.06</td><td>0.25</td><td>0.24</td><td>2.30</td><td>0.81</td><td>0.01</td><td>2.24</td><td>3.91</td><td>3.91</td><td>0.11</td><td>1.13</td><td>0.33</td><td>0.01</td><td>0.00</td><td>1.28</td><td>0.48</td><td>2.30</td><td>0.75</td><td>0.16</td><td>0.06</td><td>2.42</td><td>0.32</td><td>0.47</td><td>0.11</td><td>0.20</td><td>1.09</td><td>1.71</td><td>0.12</td><td>1.35</td><td>2.29</td><td>0.01</td><td>0.21</td><td>0.49</td><td>0.56</td><td>1.36</td><td>0.39</td><td>1.85</td><td>0.21</td><td>0.14</td><td>1.08</td><td>0.15</td><td>25.58</td><td>0.19</td><td>1.72</td><td>0.38</td><td>3.04</td><td>0.37</td><td>0.55</td><td>243.34</td><td>0.01</td><td>0.10</td><td>0.02</td><td>0.17</td><td>0.27</td><td>2.25</td><td>1.57</td><td>0.34</td><td>0.14</td><td>0.05</td><td>0.07</td><td>0.09</td><td>0.08</td><td>195.93</td><td>0.20</td><td>1.05</td><td>0.24</td><td>0.67</td></tr><tr><td>pg-src-16--3</td><td>2706.19</td><td>0.00</td><td>0.97</td><td>0.02</td><td>0.59</td><td>207.02</td><td>1.13</td><td>0.06</td><td>2.57</td><td>0.05</td><td>0.64</td><td>30.90</td><td>68.12</td><td>0.14</td><td>0.09</td><td>0.90</td><td>0.70</td><td>0.30</td><td>0.07</td><td>0.12</td><td>4.71</td><td>6.95</td><td>6.93</td><td>0.01</td><td>0.01</td><td>0.63</td><td>0.57</td><td>0.98</td><td>1.97</td><td>0.41</td><td>55.79</td><td>17.18</td><td>0.05</td><td>0.21</td><td>0.25</td><td>2.29</td><td>0.82</td><td>0.01</td><td>2.18</td><td>4.27</td><td>4.28</td><td>0.08</td><td>1.15</td><td>0.29</td><td>0.01</td><td>0.00</td><td>1.29</td><td>0.50</td><td>2.19</td><td>0.76</td><td>0.16</td><td>0.06</td><td>2.63</td><td>0.29</td><td>0.48</td><td>0.11</td><td>0.29</td><td>1.06</td><td>1.09</td><td>0.12</td><td>1.58</td><td>2.26</td><td>0.01</td><td>0.22</td><td>0.50</td><td>0.60</td><td>1.47</td><td>0.30</td><td>1.91</td><td>0.23</td><td>0.14</td><td>1.13</td><td>0.25</td><td>20.70</td><td>0.21</td><td>2.06</td><td>0.39</td><td>2.84</td><td>0.40</td><td>0.55</td><td>249.23</td><td>0.01</td><td>0.10</td><td>0.03</td><td>0.17</td><td>0.27</td><td>2.20</td><td>1.70</td><td>0.36</td><td>0.15</td><td>0.05</td><td>0.07</td><td>0.09</td><td>0.09</td><td>174.60</td><td>0.21</td><td>1.07</td><td>0.25</td><td>0.38</td></tr></tbody></table><br></br><table border="1" cellspacing="0"><caption>Benchmark s64da_ssb</caption><thead><tr><th>Instance</th><th>total</th><th>queryQ1.1</th><th>queryQ1.2</th><th>queryQ1.3</th><th>queryQ2.1</th><th>queryQ2.2</th><th>queryQ2.3</th><th>queryQ3.1</th><th>queryQ3.2</th><th>queryQ3.3</th><th>queryQ3.4</th><th>queryQ4.1</th><th>queryQ4.2</th><th>queryQ4.3</th></tr></thead><tbody><tr><td>pg-src-16--1</td><td>32.62</td><td>2.55</td><td>2.46</td><td>2.45</td><td>2.51</td><td>2.39</td><td>2.12</td><td>3.15</td><td>2.09</td><td>1.89</td><td>1.88</td><td>3.29</td><td>3.12</td><td>2.73</td></tr><tr><td>pg-src-master--1</td><td>31.01</td><td>2.39</td><td>2.37</td><td>2.30</td><td>2.38</td><td>2.27</td><td>1.98</td><td>3.33</td><td>1.94</td><td>1.76</td><td>1.75</td><td>3.03</td><td>2.91</td><td>2.60</td></tr><tr><td>pg-src-16--2</td><td>33.17</td><td>2.57</td><td>2.44</td><td>2.44</td><td>2.78</td><td>2.40</td><td>2.15</td><td>3.13</td><td>2.33</td><td>1.89</td><td>1.90</td><td>3.26</td><td>3.11</td><td>2.77</td></tr><tr><td>pg-src-master--2</td><td>31.34</td><td>2.41</td><td>2.32</td><td>2.28</td><td>2.64</td><td>2.29</td><td>2.01</td><td>3.34</td><td>1.96</td><td>1.75</td><td>1.74</td><td>3.08</td><td>2.96</td><td>2.56</td></tr><tr><td>pg-src-master--3</td><td>30.31</td><td>2.39</td><td>2.35</td><td>2.26</td><td>2.63</td><td>2.24</td><td>1.98</td><td>2.92</td><td>1.92</td><td>1.75</td><td>1.75</td><td>3.03</td><td>2.92</td><td>2.19</td></tr><tr><td>pg-src-16--3</td><td>33.38</td><td>2.54</td><td>2.45</td><td>2.43</td><td>2.79</td><td>2.39</td><td>2.18</td><td>3.51</td><td>2.11</td><td>1.89</td><td>1.89</td><td>3.37</td><td>3.10</td><td>2.73</td></tr></tbody></table><br></br><table border="1" cellspacing="0"><caption>Benchmark job</caption><thead><tr><th>Instance</th><th>query10a</th><th>query10b</th><th>query10c</th><th>query11a</th><th>query11b</th><th>query11c</th><th>query11d</th><th>query12a</th><th>query12b</th><th>query12c</th><th>query13a</th><th>query13b</th><th>query13c</th><th>query13d</th><th>query14a</th><th>query14b</th><th>query14c</th><th>query15a</th><th>query15b</th><th>query15c</th><th>query15d</th><th>query16a</th><th>query16b</th><th>query16c</th><th>query16d</th><th>query17a</th><th>query17b</th><th>query17c</th><th>query17d</th><th>query17e</th><th>query17f</th><th>query18a</th><th>query18b</th><th>query18c</th><th>query19a</th><th>query19b</th><th>query19c</th><th>query19d</th><th>query1a</th><th>query1b</th><th>query1c</th><th>query1d</th><th>query20a</th><th>query20b</th><th>query20c</th><th>query21a</th><th>query21b</th><th>query21c</th><th>query22a</th><th>query22b</th><th>query22c</th><th>query22d</th><th>query23a</th><th>query23b</th><th>query23c</th><th>query24a</th><th>query24b</th><th>query25a</th><th>query25b</th><th>query25c</th><th>query26a</th><th>query26b</th><th>query26c</th><th>query27a</th><th>query27b</th><th>query27c</th><th>query28a</th><th>query28b</th><th>query28c</th><th>query29a</th><th>query29b</th><th>query29c</th><th>query2a</th><th>query2b</th><th>query2c</th><th>query2d</th><th>query30a</th><th>query30b</th><th>query30c</th><th>query31a</th><th>query31b</th><th>query31c</th><th>query32a</th><th>query32b</th><th>query33a</th><th>query33b</th><th>query33c</th><th>query3a</th><th>query3b</th><th>query3c</th><th>query4a</th><th>query4b</th><th>query4c</th><th>query5a</th><th>query5b</th><th>query5c</th><th>query6a</th><th>query6b</th><th>query6c</th><th>query6d</th><th>query6e</th><th>query6f</th><th>query7a</th><th>query7b</th><th>query7c</th><th>query8a</th><th>query8b</th><th>query8c</th><th>query8d</th><th>query9a</th><th>query9b</th><th>query9c</th><th>query9d</th></tr></thead><tbody><tr><td>pg-src-16--1</td><td>0.57</td><td>0.39</td><td>3.31</td><td>0.44</td><td>0.10</td><td>1.12</td><td>4.63</td><td>0.40</td><td>0.06</td><td>1.05</td><td>1.26</td><td>0.66</td><td>0.62</td><td>4.37</td><td>0.67</td><td>0.17</td><td>0.97</td><td>0.32</td><td>0.04</td><td>0.86</td><td>0.96</td><td>0.22</td><td>17.33</td><td>1.66</td><td>1.29</td><td>9.71</td><td>7.86</td><td>7.64</td><td>7.65</td><td>11.55</td><td>10.06</td><td>0.40</td><td>0.57</td><td>6.44</td><td>3.97</td><td>0.22</td><td>6.64</td><td>7.21</td><td>0.08</td><td>0.06</td><td>0.06</td><td>0.06</td><td>2.56</td><td>1.16</td><td>0.82</td><td>0.35</td><td>0.26</td><td>0.49</td><td>0.63</td><td>0.47</td><td>2.18</td><td>1.40</td><td>0.58</td><td>0.07</td><td>0.37</td><td>1.94</td><td>0.07</td><td>4.09</td><td>0.65</td><td>11.70</td><td>0.77</td><td>0.17</td><td>0.77</td><td>0.34</td><td>0.22</td><td>0.74</td><td>0.52</td><td>0.57</td><td>2.37</td><td>0.11</td><td>0.08</td><td>0.21</td><td>0.50</td><td>0.49</td><td>0.46</td><td>0.60</td><td>12.30</td><td>0.71</td><td>11.66</td><td>3.21</td><td>0.68</td><td>3.25</td><td>0.01</td><td>1.22</td><td>14.79</td><td>0.86</td><td>0.91</td><td>0.17</td><td>0.12</td><td>0.24</td><td>0.09</td><td>0.12</td><td>0.10</td><td>0.17</td><td>0.16</td><td>0.23</td><td>0.07</td><td>1.21</td><td>0.03</td><td>6.44</td><td>0.08</td><td>6.62</td><td>0.27</td><td>0.20</td><td>13.16</td><td>2.35</td><td>0.19</td><td>5.05</td><td>3.19</td><td>2.68</td><td>1.45</td><td>2.47</td><td>4.51</td></tr><tr><td>pg-src-master--1</td><td>0.56</td><td>0.38</td><td>3.16</td><td>0.28</td><td>0.09</td><td>1.14</td><td>4.70</td><td>0.40</td><td>0.06</td><td>1.07</td><td>1.35</td><td>0.68</td><td>0.65</td><td>2.04</td><td>0.69</td><td>0.18</td><td>0.98</td><td>0.33</td><td>0.04</td><td>0.71</td><td>0.91</td><td>0.24</td><td>17.31</td><td>1.65</td><td>1.33</td><td>9.63</td><td>7.89</td><td>7.56</td><td>7.68</td><td>11.32</td><td>10.06</td><td>0.52</td><td>1.36</td><td>6.36</td><td>0.30</td><td>0.19</td><td>6.49</td><td>6.96</td><td>0.08</td><td>0.05</td><td>0.06</td><td>0.05</td><td>2.59</td><td>1.17</td><td>0.84</td><td>0.35</td><td>0.25</td><td>0.49</td><td>0.62</td><td>0.47</td><td>2.20</td><td>1.40</td><td>0.68</td><td>0.07</td><td>0.35</td><td>1.41</td><td>0.07</td><td>4.00</td><td>0.50</td><td>11.86</td><td>0.41</td><td>0.21</td><td>0.83</td><td>0.34</td><td>0.21</td><td>0.75</td><td>0.84</td><td>0.57</td><td>1.13</td><td>0.32</td><td>0.07</td><td>0.21</td><td>0.50</td><td>0.49</td><td>0.45</td><td>0.60</td><td>2.98</td><td>0.70</td><td>3.74</td><td>3.20</td><td>0.69</td><td>3.25</td><td>0.02</td><td>1.24</td><td>3.14</td><td>1.94</td><td>2.52</td><td>0.18</td><td>0.12</td><td>0.26</td><td>0.10</td><td>0.12</td><td>0.11</td><td>0.16</td><td>0.16</td><td>0.22</td><td>0.07</td><td>1.34</td><td>0.05</td><td>7.19</td><td>0.09</td><td>7.30</td><td>0.26</td><td>0.18</td><td>12.19</td><td>2.32</td><td>0.19</td><td>4.87</td><td>3.13</td><td>0.29</td><td>0.26</td><td>2.27</td><td>4.30</td></tr><tr><td>pg-src-16--2</td><td>0.57</td><td>0.39</td><td>3.32</td><td>0.28</td><td>0.09</td><td>1.13</td><td>4.73</td><td>0.40</td><td>0.06</td><td>1.07</td><td>1.28</td><td>0.66</td><td>0.63</td><td>1.99</td><td>0.66</td><td>0.17</td><td>0.96</td><td>0.34</td><td>0.04</td><td>0.85</td><td>0.95</td><td>0.23</td><td>17.18</td><td>1.64</td><td>1.32</td><td>9.61</td><td>7.80</td><td>7.56</td><td>7.65</td><td>11.32</td><td>9.95</td><td>0.40</td><td>1.35</td><td>6.35</td><td>3.95</td><td>0.21</td><td>6.58</td><td>7.14</td><td>0.08</td><td>0.06</td><td>0.06</td><td>0.06</td><td>2.61</td><td>1.16</td><td>0.81</td><td>0.36</td><td>0.25</td><td>0.49</td><td>0.62</td><td>0.44</td><td>2.14</td><td>1.37</td><td>0.59</td><td>0.07</td><td>0.37</td><td>1.75</td><td>0.08</td><td>3.93</td><td>0.50</td><td>12.29</td><td>0.38</td><td>0.21</td><td>0.74</td><td>0.34</td><td>0.21</td><td>0.74</td><td>0.87</td><td>0.42</td><td>2.24</td><td>0.11</td><td>0.07</td><td>0.22</td><td>0.50</td><td>0.48</td><td>0.45</td><td>0.62</td><td>11.58</td><td>0.68</td><td>5.64</td><td>3.22</td><td>0.67</td><td>3.20</td><td>0.02</td><td>1.23</td><td>2.55</td><td>22.09</td><td>2.52</td><td>0.17</td><td>0.12</td><td>0.26</td><td>0.10</td><td>0.12</td><td>0.11</td><td>0.17</td><td>0.16</td><td>0.22</td><td>0.06</td><td>1.22</td><td>0.04</td><td>6.37</td><td>0.08</td><td>6.46</td><td>0.28</td><td>0.20</td><td>12.20</td><td>2.33</td><td>0.19</td><td>4.83</td><td>3.17</td><td>2.68</td><td>0.31</td><td>2.46</td><td>4.56</td></tr><tr><td>pg-src-master--2</td><td>0.56</td><td>0.38</td><td>3.18</td><td>0.28</td><td>0.09</td><td>1.13</td><td>4.73</td><td>0.40</td><td>0.06</td><td>1.09</td><td>1.35</td><td>0.69</td><td>0.66</td><td>2.06</td><td>0.68</td><td>0.18</td><td>1.04</td><td>0.33</td><td>0.04</td><td>2.48</td><td>0.91</td><td>0.22</td><td>17.34</td><td>1.64</td><td>1.30</td><td>9.75</td><td>7.86</td><td>7.58</td><td>7.72</td><td>11.50</td><td>10.16</td><td>4.71</td><td>1.37</td><td>6.33</td><td>3.86</td><td>0.20</td><td>6.51</td><td>6.96</td><td>0.07</td><td>0.05</td><td>0.06</td><td>0.06</td><td>2.63</td><td>1.18</td><td>0.87</td><td>0.36</td><td>0.26</td><td>0.50</td><td>0.65</td><td>0.48</td><td>2.24</td><td>1.46</td><td>0.67</td><td>0.07</td><td>0.80</td><td>1.77</td><td>0.07</td><td>4.08</td><td>0.51</td><td>11.99</td><td>0.40</td><td>0.21</td><td>1.21</td><td>0.28</td><td>0.21</td><td>0.74</td><td>0.95</td><td>0.57</td><td>0.46</td><td>0.16</td><td>0.08</td><td>0.22</td><td>0.51</td><td>0.48</td><td>0.45</td><td>0.60</td><td>5.40</td><td>0.70</td><td>11.38</td><td>3.23</td><td>0.68</td><td>3.26</td><td>0.01</td><td>1.24</td><td>2.75</td><td>0.89</td><td>2.51</td><td>0.19</td><td>0.12</td><td>0.26</td><td>0.10</td><td>0.12</td><td>0.11</td><td>0.17</td><td>0.15</td><td>0.23</td><td>0.07</td><td>1.35</td><td>0.05</td><td>7.21</td><td>0.08</td><td>7.31</td><td>0.26</td><td>0.18</td><td>12.29</td><td>2.32</td><td>0.20</td><td>4.96</td><td>3.11</td><td>2.44</td><td>1.46</td><td>2.28</td><td>4.29</td></tr><tr><td>pg-src-master--3</td><td>0.57</td><td>0.39</td><td>3.16</td><td>0.28</td><td>0.09</td><td>1.14</td><td>4.73</td><td>0.42</td><td>0.06</td><td>1.10</td><td>1.36</td><td>0.70</td><td>0.66</td><td>4.62</td><td>0.67</td><td>0.18</td><td>0.97</td><td>0.34</td><td>0.04</td><td>0.72</td><td>0.91</td><td>0.22</td><td>17.84</td><td>1.68</td><td>1.32</td><td>9.81</td><td>8.00</td><td>7.76</td><td>7.91</td><td>11.59</td><td>10.23</td><td>0.40</td><td>1.41</td><td>6.44</td><td>3.96</td><td>0.20</td><td>6.66</td><td>7.01</td><td>0.08</td><td>0.05</td><td>0.06</td><td>0.05</td><td>2.66</td><td>1.18</td><td>0.75</td><td>0.36</td><td>0.26</td><td>0.49</td><td>0.64</td><td>0.48</td><td>2.20</td><td>1.40</td><td>0.56</td><td>0.08</td><td>0.35</td><td>1.92</td><td>0.08</td><td>4.00</td><td>0.50</td><td>11.72</td><td>0.82</td><td>0.22</td><td>2.28</td><td>0.37</td><td>0.21</td><td>0.76</td><td>0.67</td><td>0.43</td><td>2.42</td><td>0.25</td><td>0.07</td><td>0.17</td><td>0.50</td><td>0.50</td><td>0.47</td><td>0.61</td><td>2.16</td><td>0.68</td><td>11.69</td><td>3.24</td><td>0.69</td><td>3.26</td><td>0.02</td><td>1.25</td><td>1.08</td><td>0.78</td><td>2.54</td><td>0.18</td><td>0.12</td><td>0.27</td><td>0.10</td><td>0.12</td><td>0.11</td><td>0.16</td><td>0.16</td><td>0.22</td><td>0.07</td><td>1.41</td><td>0.05</td><td>7.39</td><td>0.09</td><td>7.54</td><td>0.27</td><td>0.19</td><td>12.56</td><td>2.40</td><td>0.20</td><td>5.00</td><td>3.12</td><td>2.46</td><td>1.50</td><td>2.31</td><td>4.35</td></tr><tr><td>pg-src-16--3</td><td>0.58</td><td>0.39</td><td>3.30</td><td>0.28</td><td>0.09</td><td>1.13</td><td>4.63</td><td>0.40</td><td>0.06</td><td>1.07</td><td>1.28</td><td>0.67</td><td>0.62</td><td>1.99</td><td>0.67</td><td>0.17</td><td>0.95</td><td>0.34</td><td>0.04</td><td>0.86</td><td>0.96</td><td>0.24</td><td>17.02</td><td>1.64</td><td>1.30</td><td>9.72</td><td>7.81</td><td>7.61</td><td>7.64</td><td>11.23</td><td>10.00</td><td>0.38</td><td>1.36</td><td>6.47</td><td>3.96</td><td>0.20</td><td>6.61</td><td>7.16</td><td>0.08</td><td>0.06</td><td>0.06</td><td>0.06</td><td>2.62</td><td>1.17</td><td>0.65</td><td>0.34</td><td>0.26</td><td>0.48</td><td>0.60</td><td>0.44</td><td>2.15</td><td>1.39</td><td>0.58</td><td>0.07</td><td>0.36</td><td>1.77</td><td>0.08</td><td>3.98</td><td>0.50</td><td>11.68</td><td>0.74</td><td>0.20</td><td>2.06</td><td>0.34</td><td>0.32</td><td>0.76</td><td>0.93</td><td>0.56</td><td>2.27</td><td>0.15</td><td>0.45</td><td>0.23</td><td>0.50</td><td>0.48</td><td>0.44</td><td>0.59</td><td>5.42</td><td>0.71</td><td>3.75</td><td>3.17</td><td>0.67</td><td>3.19</td><td>0.02</td><td>1.21</td><td>2.20</td><td>0.80</td><td>2.50</td><td>0.19</td><td>0.12</td><td>0.27</td><td>0.10</td><td>0.12</td><td>0.11</td><td>0.17</td><td>0.17</td><td>0.21</td><td>0.07</td><td>1.29</td><td>0.04</td><td>6.47</td><td>0.08</td><td>6.59</td><td>0.27</td><td>0.20</td><td>12.02</td><td>2.33</td><td>0.20</td><td>5.04</td><td>3.20</td><td>2.64</td><td>0.29</td><td>2.46</td><td>4.49</td></tr></tbody></table><br></br><table border="1" cellspacing="0"><caption>Benchmark sysbench</caption><thead><tr><th>Instance</th><th>load_​bulk_​insert_​tps</th><th>load_​oltp_​delete_​tps</th><th>load_​oltp_​insert_​tps</th><th>load_​oltp_​point_​select_​tps</th><th>load_​oltp_​read_​only_​tps</th><th>load_​oltp_​read_​write_​tps</th><th>load_​oltp_​update_​index_​tps</th><th>load_​oltp_​update_​non_​index_​tps</th><th>load_​oltp_​write_​only_​tps</th><th>load_​select_​random_​points_​tps</th><th>load_​select_​random_​ranges_​tps</th><th>load_​bulk_​insert_​ops</th><th>load_​oltp_​delete_​ops</th><th>load_​oltp_​insert_​ops</th><th>load_​oltp_​point_​select_​ops</th><th>load_​oltp_​read_​only_​ops</th><th>load_​oltp_​read_​write_​ops</th><th>load_​oltp_​update_​index_​ops</th><th>load_​oltp_​update_​non_​index_​ops</th><th>load_​oltp_​write_​only_​ops</th><th>load_​select_​random_​points_​ops</th><th>load_​select_​random_​ranges_​ops</th></tr></thead><tbody><tr><td>pg-src-16--1</td><td>2239310.80</td><td>357117.05</td><td>127288.29</td><td>346271.04</td><td>14671.85</td><td>8812.62</td><td>151218.93</td><td>176010.69</td><td>25207.98</td><td>214379.86</td><td>144092.43</td><td>78.54</td><td>357117.05</td><td>127288.29</td><td>346271.04</td><td>234749.59</td><td>176329.50</td><td>151218.93</td><td>176010.69</td><td>151504.88</td><td>214379.86</td><td>144092.43</td></tr><tr><td>pg-src-master--1</td><td>2412944.91</td><td>366778.22</td><td>130358.55</td><td>353037.52</td><td>14972.68</td><td>9127.93</td><td>150506.38</td><td>180389.11</td><td>29556.30</td><td>259400.37</td><td>147098.78</td><td>85.12</td><td>366778.22</td><td>130358.55</td><td>353037.52</td><td>239562.80</td><td>182645.81</td><td>150506.38</td><td>180389.11</td><td>177648.26</td><td>259400.37</td><td>147098.78</td></tr><tr><td>pg-src-16--2</td><td>2294793.78</td><td>368366.64</td><td>128020.20</td><td>353459.52</td><td>14812.03</td><td>8949.93</td><td>151231.72</td><td>179670.40</td><td>29632.32</td><td>218079.77</td><td>146280.25</td><td>80.66</td><td>368366.64</td><td>128020.20</td><td>353459.52</td><td>236992.56</td><td>179080.25</td><td>151231.72</td><td>179670.40</td><td>178106.37</td><td>218079.77</td><td>146280.25</td></tr><tr><td>pg-src-master--2</td><td>2414900.66</td><td>362718.87</td><td>129802.73</td><td>349019.47</td><td>14932.07</td><td>9294.81</td><td>148078.97</td><td>175166.77</td><td>28153.47</td><td>255868.12</td><td>143556.88</td><td>85.22</td><td>362718.87</td><td>129802.73</td><td>349019.47</td><td>238913.13</td><td>185988.55</td><td>148078.97</td><td>175166.77</td><td>169203.11</td><td>255868.12</td><td>143556.88</td></tr><tr><td>pg-src-master--3</td><td>2359194.37</td><td>367318.02</td><td>128577.22</td><td>354433.95</td><td>14759.47</td><td>8948.13</td><td>148556.96</td><td>178381.96</td><td>27852.43</td><td>259281.03</td><td>145294.32</td><td>83.09</td><td>367318.02</td><td>128577.22</td><td>354433.95</td><td>236151.49</td><td>179039.02</td><td>148556.96</td><td>178381.96</td><td>167395.10</td><td>259281.03</td><td>145294.32</td></tr><tr><td>pg-src-16--3</td><td>2265793.45</td><td>353323.64</td><td>123067.01</td><td>343356.05</td><td>14549.85</td><td>8659.81</td><td>146659.80</td><td>170040.76</td><td>27223.09</td><td>213049.76</td><td>139908.73</td><td>79.55</td><td>353323.64</td><td>123067.01</td><td>343356.05</td><td>232797.57</td><td>173282.06</td><td>146659.80</td><td>170040.76</td><td>163622.61</td><td>213049.76</td><td>139908.73</td></tr></tbody></table><br></br><table border="1" cellspacing="0"><caption>Benchmark insert-1m</caption><thead><tr><th>Instance</th><th>time</th></tr></thead><tbody><tr><td>pg-src-16--1</td><td>36.99</td></tr><tr><td>pg-src-master--1</td><td>37.75</td></tr><tr><td>pg-src-16--2</td><td>37.79</td></tr><tr><td>pg-src-master--2</td><td>35.41</td></tr><tr><td>pg-src-master--3</td><td>35.72</td></tr><tr><td>pg-src-16--3</td><td>36.48</td></tr></tbody></table><br></br></div></body></html>

view thread (52+ messages)  latest in thread

Message-ID: <63a63690-dd92-c809-0b47-af05459e95d1@gmail.com>
Permalink:  ../63a63690-dd92-c809-0b47-af05459e95d1@gmail.com/
Also on:    postgresql.org/message-id/63a63690-dd92-c809-0b47-af05459e95d1@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: exclusion@gmail.com, andres@anarazel.de, thomas.munro@gmail.com, melanieplageman@gmail.com, dgrowleyml@gmail.com, hlinnaka@iki.fi
  Subject: Re: Streaming read-ready sequential scan code
  In-Reply-To: <63a63690-dd92-c809-0b47-af05459e95d1@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox