{"action":"created","issue":{"url":"https://api.github.com/repos/hyrise/hyrise/issues/1316","repository_url":"https://api.github.com/repos/hyrise/hyrise","labels_url":"https://api.github.com/repos/hyrise/hyrise/issues/1316/labels{/name}","comments_url":"https://api.github.com/repos/hyrise/hyrise/issues/1316/comments","events_url":"https://api.github.com/repos/hyrise/hyrise/issues/1316/events","html_url":"https://github.com/hyrise/hyrise/pull/1316","id":382766373,"node_id":"MDExOlB1bGxSZXF1ZXN0MjMyMzk3MDQ5","number":1316,"title":"Switch to gcc-8","user":{"login":"mrks","id":575106,"node_id":"MDQ6VXNlcjU3NTEwNg==","avatar_url":"https://avatars2.githubusercontent.com/u/575106?v=4","gravatar_id":"","url":"https://api.github.com/users/mrks","html_url":"https://github.com/mrks","followers_url":"https://api.github.com/users/mrks/followers","following_url":"https://api.github.com/users/mrks/following{/other_user}","gists_url":"https://api.github.com/users/mrks/gists{/gist_id}","starred_url":"https://api.github.com/users/mrks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mrks/subscriptions","organizations_url":"https://api.github.com/users/mrks/orgs","repos_url":"https://api.github.com/users/mrks/repos","events_url":"https://api.github.com/users/mrks/events{/privacy}","received_events_url":"https://api.github.com/users/mrks/received_events","type":"User","site_admin":false},"labels":[{"id":978421305,"node_id":"MDU6TGFiZWw5Nzg0MjEzMDU=","url":"https://api.github.com/repos/hyrise/hyrise/labels/FullCI","name":"FullCI","color":"02ef0e","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-11-20T17:14:17Z","updated_at":"2018-11-22T13:01:26Z","closed_at":null,"author_association":"MEMBER","pull_request":{"url":"https://api.github.com/repos/hyrise/hyrise/pulls/1316","html_url":"https://github.com/hyrise/hyrise/pull/1316","diff_url":"https://github.com/hyrise/hyrise/pull/1316.diff","patch_url":"https://github.com/hyrise/hyrise/pull/1316.patch"},"body":"I don't see the gcc bug (https://gcc.gnu.org/bugzilla/show_bug.cgi?id=86740) getting fixed any time soon, so we need to work around it. Surprisingly, this brings huge performance improvements:\r\n\r\n```\r\n+-----------+---------------+-------+---------------+-------+--------+---------------------------------+\r\n| Benchmark | prev. iter/s  | runs  | new iter/s    | runs  | change | p-value (significant if <0.001) |\r\n+-----------+---------------+-------+---------------+-------+--------+---------------------------------+\r\n| TPC-H 1   | 6.02758789062 | 362   | 6.12915992737 | 368   | +2%    |                          0.0000 |\r\n| TPC-H 2   | 126.775764465 | 7607  | 134.289871216 | 8058  | +6%    |     (run time too short) 0.0000 |\r\n| TPC-H 3   | 65.7526779175 | 3946  | 80.5141906738 | 4831  | +22%   |     (run time too short) 0.0000 |\r\n| TPC-H 4   | 23.2088012695 | 1393  | 24.3816776276 | 1463  | +5%    |     (run time too short) 0.0000 |\r\n| TPC-H 5   | 48.8845252991 | 2934  | 55.7888793945 | 3348  | +14%   |     (run time too short) 0.0000 |\r\n| TPC-H 6   | 190.609146118 | 10000 | 245.344909668 | 10000 | +29%   |     (run time too short) 0.0000 |\r\n| TPC-H 7   | 20.4334430695 | 1227  | 21.347858429  | 1281  | +4%    |     (run time too short) 0.0000 |\r\n| TPC-H 8   | 84.1673202515 | 5051  | 95.6332550049 | 5738  | +14%   |     (run time too short) 0.0000 |\r\n| TPC-H 9   | 25.3446292877 | 1521  | 28.0776557922 | 1685  | +11%   |     (run time too short) 0.0000 |\r\n| TPC-H 10  | 33.7987861633 | 2028  | 36.0571174622 | 2164  | +7%    |     (run time too short) 0.0000 |\r\n| TPC-H 11  | 207.932632446 | 10000 | 235.704620361 | 10000 | +13%   |     (run time too short) 0.0000 |\r\n| TPC-H 12  | 62.7930145264 | 3768  | 77.3840179443 | 4644  | +23%   |     (run time too short) 0.0000 |\r\n| TPC-H 13  | 27.9029312134 | 1675  | 28.837480545  | 1731  | +3%    |     (run time too short) 0.0000 |\r\n| TPC-H 14  | 187.36390686  | 10000 | 240.441680908 | 10000 | +28%   |     (run time too short) 0.0000 |\r\n| TPC-H 15  | 82.0679168701 | 4925  | 137.04725647  | 8223  | +67%   |     (run time too short) 0.0000 |\r\n| TPC-H 16  | 69.3347015381 | 4161  | 75.322807312  | 4520  | +9%    |     (run time too short) 0.0000 |\r\n| TPC-H 17  | 7.03549146652 | 423   | 6.58403491974 | 396   | -6%    |                          0.0000 |\r\n| TPC-H 18  | 19.1601352692 | 1150  | 19.5048866272 | 1171  | +2%    |     (run time too short) 0.0000 |\r\n| TPC-H 19  | 59.8257141113 | 3590  | 64.8801269531 | 3893  | +8%    |     (run time too short) 0.0000 |\r\n| TPC-H 20  | 3.94501423836 | 237   | 3.72373914719 | 224   | -6%    |                          0.0000 |\r\n| TPC-H 21  | 1.98768091202 | 120   | 1.85989546776 | 112   | -6%    |                          0.0000 |\r\n| TPC-H 22  | 122.6378479   | 7359  | 130.121963501 | 7808  | +6%    |     (run time too short) 0.0000 |\r\n| average   |               |       |               |       | +12%   |                                 |\r\n+-----------+---------------+-------+---------------+-------+--------+---------------------------------+\r\n```"},"comment":{"url":"https://api.github.com/repos/hyrise/hyrise/issues/comments/441023928","html_url":"https://github.com/hyrise/hyrise/pull/1316#issuecomment-441023928","issue_url":"https://api.github.com/repos/hyrise/hyrise/issues/1316","id":441023928,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MTAyMzkyOA==","user":{"login":"mrks","id":575106,"node_id":"MDQ6VXNlcjU3NTEwNg==","avatar_url":"https://avatars2.githubusercontent.com/u/575106?v=4","gravatar_id":"","url":"https://api.github.com/users/mrks","html_url":"https://github.com/mrks","followers_url":"https://api.github.com/users/mrks/followers","following_url":"https://api.github.com/users/mrks/following{/other_user}","gists_url":"https://api.github.com/users/mrks/gists{/gist_id}","starred_url":"https://api.github.com/users/mrks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mrks/subscriptions","organizations_url":"https://api.github.com/users/mrks/orgs","repos_url":"https://api.github.com/users/mrks/repos","events_url":"https://api.github.com/users/mrks/events{/privacy}","received_events_url":"https://api.github.com/users/mrks/received_events","type":"User","site_admin":false},"created_at":"2018-11-22T13:01:26Z","updated_at":"2018-11-22T13:01:26Z","author_association":"MEMBER","body":"Meh, it was just ccache being drunk."}}
{"actor":{"display_login":"mrks"}}