resultcache_v8_vs_v9.txt

text/plain

Filename: resultcache_v8_vs_v9.txt
Type: text/plain
Part: 2
Message: Re: Hybrid Hash/Nested Loop joins and caching results from subplans
   col    |    tbl    |   target   |    v8    |    v9    | v8_vs_v9
----------+-----------+------------+----------+----------+----------
 hundred  | lookup1   | '*'        |   42.484 |   44.511 |     95.4
 hundred  | lookup1   | count(*)   |   30.513 |   33.016 |     92.4
 hundred  | lookup1   | count(l.a) |   32.651 |   35.471 |     92.0
 one      | lookup1   | '*'        |   42.084 |   43.668 |     96.4
 one      | lookup1   | count(*)   |   29.255 |   32.162 |     91.0
 one      | lookup1   | count(l.a) |   31.772 |   35.139 |     90.4
 ten      | lookup1   | '*'        |   40.286 |   42.439 |     94.9
 ten      | lookup1   | count(*)   |   29.286 |   32.009 |     91.5
 ten      | lookup1   | count(l.a) |   31.392 |   34.053 |     92.2
 thousand | lookup1   | '*'        |   43.771 |   45.711 |     95.8
 thousand | lookup1   | count(*)   |   31.531 |   33.845 |     93.2
 thousand | lookup1   | count(l.a) |   33.339 |   35.903 |     92.9
 hundred  | lookup100 | '*'        | 1494.440 | 1471.999 |    101.5
 hundred  | lookup100 | count(*)   |  266.988 |  265.659 |    100.5
 hundred  | lookup100 | count(l.a) |  268.414 |  273.851 |     98.0
 one      | lookup100 | '*'        | 1503.697 | 1553.174 |     96.8
 one      | lookup100 | count(*)   |  952.287 |  967.910 |     98.4
 one      | lookup100 | count(l.a) |  970.547 |  990.562 |     98.0
 ten      | lookup100 | '*'        | 1354.550 | 1407.461 |     96.2
 ten      | lookup100 | count(*)   |  944.390 |  929.513 |    101.6
 ten      | lookup100 | count(l.a) |  958.143 |  944.583 |    101.4
 thousand | lookup100 | '*'        | 1528.326 | 1507.617 |    101.4
 thousand | lookup100 | count(*)   |  203.801 |  203.707 |    100.0
 thousand | lookup100 | count(l.a) |  204.645 |  209.883 |     97.5