resultcache_master_v8_vs_v9_big.txt

select col,tbl,target, sum(latency_master) as master, sum(latency_v8) v8, sum(latency_v9) v9, round(avg(latency_v8/latency_master)*100,1) as v8_vs_master, round(avg(latency_v9/latency_master)*100,1) as v9_vs_master, round(avg(latency_v8/latency_v9)*100,1) as v8_vs_v9 from resultcache_bench2 group by 1,2,3 order by 2,1,3;

   col    |    tbl    |   target   |   master   |     v8     |     v9     | v8_vs_master | v9_vs_master | v8_vs_v9
----------+-----------+------------+------------+------------+------------+--------------+--------------+----------
 hundred  | lookup1   | '*'        |   5750.325 |   4321.320 |   4548.600 |         75.1 |         79.1 |     95.0
 hundred  | lookup1   | count(*)   |   4495.967 |   3111.354 |   3301.798 |         69.2 |         73.4 |     94.2
 hundred  | lookup1   | count(l.a) |   4551.304 |   3231.036 |   3526.468 |         71.0 |         77.5 |     91.6
 one      | lookup1   | '*'        |   5724.242 |   4309.074 |   4479.229 |         75.3 |         78.3 |     96.2
 one      | lookup1   | count(*)   |   4467.683 |   2912.478 |   3214.049 |         65.2 |         71.9 |     90.6
 one      | lookup1   | count(l.a) |   4503.882 |   3145.432 |   3462.072 |         69.8 |         76.9 |     90.9
 ten      | lookup1   | '*'        |   5554.401 |   4128.838 |   4337.956 |         74.3 |         78.1 |     95.2
 ten      | lookup1   | count(*)   |   4377.590 |   2925.131 |   3159.214 |         66.8 |         72.2 |     92.6
 ten      | lookup1   | count(l.a) |   4444.535 |   3102.161 |   3382.259 |         69.8 |         76.1 |     91.7
 thousand | lookup1   | '*'        |   7869.671 |   4281.352 |   4492.678 |         54.4 |         57.1 |     95.3
 thousand | lookup1   | count(*)   |   6686.179 |   2950.660 |   3217.514 |         44.1 |         48.1 |     91.7
 thousand | lookup1   | count(l.a) |   6714.409 |   3152.067 |   3422.330 |         46.9 |         51.0 |     92.1
 hundred  | lookup100 | '*'        | 253973.453 | 153069.800 | 152742.719 |         60.3 |         60.1 |    100.2
 hundred  | lookup100 | count(*)   | 140918.236 |  51365.583 |  51559.118 |         36.5 |         36.6 |     99.6
 hundred  | lookup100 | count(l.a) | 143877.890 |  68809.635 |  65981.690 |         47.8 |         45.9 |    104.3
 one      | lookup100 | '*'        | 255409.805 | 154030.921 | 153737.083 |         60.3 |         60.2 |    100.2
 one      | lookup100 | count(*)   | 140432.641 |  51141.736 |  51354.441 |         36.4 |         36.6 |     99.6
 one      | lookup100 | count(l.a) | 143358.858 |  68678.546 |  65701.101 |         47.9 |         45.8 |    104.5
 ten      | lookup100 | '*'        | 231615.463 | 139033.321 | 139677.871 |         60.0 |         60.3 |     99.5
 ten      | lookup100 | count(*)   | 128410.287 |  46405.746 |  46593.886 |         36.1 |         36.3 |     99.6
 ten      | lookup100 | count(l.a) | 131145.929 |  62163.477 |  59541.391 |         47.4 |         45.4 |    104.4
 thousand | lookup100 | '*'        | 256937.399 | 156422.443 | 154745.273 |         60.9 |         60.2 |    101.1
 thousand | lookup100 | count(*)   | 140825.205 |  51658.594 |  51910.674 |         36.7 |         36.9 |     99.5
 thousand | lookup100 | count(l.a) | 143633.907 |  69384.230 |  66504.378 |         48.3 |         46.3 |    104.3
(24 rows)