{"action":"created","issue":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/647","repository_url":"https://api.github.com/repos/greenplum-db/gpdb","labels_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/647/labels{/name}","comments_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/647/comments","events_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/647/events","html_url":"https://github.com/greenplum-db/gpdb/pull/647","id":148522196,"number":647,"title":"Add new guc to speed up optimization time [#116333899]","user":{"login":"d","id":440892,"avatar_url":"https://avatars.githubusercontent.com/u/440892?v=3","gravatar_id":"","url":"https://api.github.com/users/d","html_url":"https://github.com/d","followers_url":"https://api.github.com/users/d/followers","following_url":"https://api.github.com/users/d/following{/other_user}","gists_url":"https://api.github.com/users/d/gists{/gist_id}","starred_url":"https://api.github.com/users/d/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/d/subscriptions","organizations_url":"https://api.github.com/users/d/orgs","repos_url":"https://api.github.com/users/d/repos","events_url":"https://api.github.com/users/d/events{/privacy}","received_events_url":"https://api.github.com/users/d/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":12,"created_at":"2016-04-15T00:41:19Z","updated_at":"2016-04-19T17:32:26Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/647","html_url":"https://github.com/greenplum-db/gpdb/pull/647","diff_url":"https://github.com/greenplum-db/gpdb/pull/647.diff","patch_url":"https://github.com/greenplum-db/gpdb/pull/647.patch"},"body":"`set optimizer_join_arity_for_associativity_commutativity=7` will hint\r\nat the optimizer to stop exploring join associativity and join\r\ncommutativity transformations when an n-ary join operator has more than\r\n7 children during optimization, pruning quite a bit of the search space.\r\n\r\nThis PR depends on greenplum-db/gporca#38"},"comment":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/comments/212029614","html_url":"https://github.com/greenplum-db/gpdb/pull/647#issuecomment-212029614","issue_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/647","id":212029614,"user":{"login":"andreasscherbaum","id":1191463,"avatar_url":"https://avatars.githubusercontent.com/u/1191463?v=3","gravatar_id":"","url":"https://api.github.com/users/andreasscherbaum","html_url":"https://github.com/andreasscherbaum","followers_url":"https://api.github.com/users/andreasscherbaum/followers","following_url":"https://api.github.com/users/andreasscherbaum/following{/other_user}","gists_url":"https://api.github.com/users/andreasscherbaum/gists{/gist_id}","starred_url":"https://api.github.com/users/andreasscherbaum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andreasscherbaum/subscriptions","organizations_url":"https://api.github.com/users/andreasscherbaum/orgs","repos_url":"https://api.github.com/users/andreasscherbaum/repos","events_url":"https://api.github.com/users/andreasscherbaum/events{/privacy}","received_events_url":"https://api.github.com/users/andreasscherbaum/received_events","type":"User","site_admin":false},"created_at":"2016-04-19T17:32:26Z","updated_at":"2016-04-19T17:32:26Z","body":"You know about short time temporary solutions, right? ;-)"}}