{"action":"closed","number":647,"pull_request":{"url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/647","id":66575550,"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","issue_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/647","number":647,"state":"closed","locked":false,"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},"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","created_at":"2016-04-15T00:41:19Z","updated_at":"2016-04-19T17:41:44Z","closed_at":"2016-04-19T17:41:43Z","merged_at":"2016-04-19T17:41:43Z","merge_commit_sha":"c4383dd4998c67eed5ed59ad3c7fb2047b3a1089","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/647/commits","review_comments_url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/647/comments","review_comment_url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/comments{/number}","comments_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/647/comments","statuses_url":"https://api.github.com/repos/greenplum-db/gpdb/statuses/c4383dd4998c67eed5ed59ad3c7fb2047b3a1089","head":{"label":"d:hint_join_arity_assoc_comm","ref":"hint_join_arity_assoc_comm","sha":"c4383dd4998c67eed5ed59ad3c7fb2047b3a1089","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},"repo":{"id":56258125,"name":"gpdb","full_name":"d/gpdb","owner":{"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},"private":false,"html_url":"https://github.com/d/gpdb","description":"Greenplum Database","fork":true,"url":"https://api.github.com/repos/d/gpdb","forks_url":"https://api.github.com/repos/d/gpdb/forks","keys_url":"https://api.github.com/repos/d/gpdb/keys{/key_id}","collaborators_url":"https://api.github.com/repos/d/gpdb/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/d/gpdb/teams","hooks_url":"https://api.github.com/repos/d/gpdb/hooks","issue_events_url":"https://api.github.com/repos/d/gpdb/issues/events{/number}","events_url":"https://api.github.com/repos/d/gpdb/events","assignees_url":"https://api.github.com/repos/d/gpdb/assignees{/user}","branches_url":"https://api.github.com/repos/d/gpdb/branches{/branch}","tags_url":"https://api.github.com/repos/d/gpdb/tags","blobs_url":"https://api.github.com/repos/d/gpdb/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/d/gpdb/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/d/gpdb/git/refs{/sha}","trees_url":"https://api.github.com/repos/d/gpdb/git/trees{/sha}","statuses_url":"https://api.github.com/repos/d/gpdb/statuses/{sha}","languages_url":"https://api.github.com/repos/d/gpdb/languages","stargazers_url":"https://api.github.com/repos/d/gpdb/stargazers","contributors_url":"https://api.github.com/repos/d/gpdb/contributors","subscribers_url":"https://api.github.com/repos/d/gpdb/subscribers","subscription_url":"https://api.github.com/repos/d/gpdb/subscription","commits_url":"https://api.github.com/repos/d/gpdb/commits{/sha}","git_commits_url":"https://api.github.com/repos/d/gpdb/git/commits{/sha}","comments_url":"https://api.github.com/repos/d/gpdb/comments{/number}","issue_comment_url":"https://api.github.com/repos/d/gpdb/issues/comments{/number}","contents_url":"https://api.github.com/repos/d/gpdb/contents/{+path}","compare_url":"https://api.github.com/repos/d/gpdb/compare/{base}...{head}","merges_url":"https://api.github.com/repos/d/gpdb/merges","archive_url":"https://api.github.com/repos/d/gpdb/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/d/gpdb/downloads","issues_url":"https://api.github.com/repos/d/gpdb/issues{/number}","pulls_url":"https://api.github.com/repos/d/gpdb/pulls{/number}","milestones_url":"https://api.github.com/repos/d/gpdb/milestones{/number}","notifications_url":"https://api.github.com/repos/d/gpdb/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/d/gpdb/labels{/name}","releases_url":"https://api.github.com/repos/d/gpdb/releases{/id}","deployments_url":"https://api.github.com/repos/d/gpdb/deployments","created_at":"2016-04-14T17:46:30Z","updated_at":"2016-04-14T17:46:56Z","pushed_at":"2016-04-19T17:41:14Z","git_url":"git://github.com/d/gpdb.git","ssh_url":"git@github.com:d/gpdb.git","clone_url":"https://github.com/d/gpdb.git","svn_url":"https://github.com/d/gpdb","homepage":"http://greenplum.org","size":138665,"stargazers_count":0,"watchers_count":0,"language":"PLpgSQL","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"greenplum-db:master","ref":"master","sha":"54eedb494f8824cf83aa9c2abf5a97cda524eb01","user":{"login":"greenplum-db","id":14097842,"avatar_url":"https://avatars.githubusercontent.com/u/14097842?v=3","gravatar_id":"","url":"https://api.github.com/users/greenplum-db","html_url":"https://github.com/greenplum-db","followers_url":"https://api.github.com/users/greenplum-db/followers","following_url":"https://api.github.com/users/greenplum-db/following{/other_user}","gists_url":"https://api.github.com/users/greenplum-db/gists{/gist_id}","starred_url":"https://api.github.com/users/greenplum-db/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/greenplum-db/subscriptions","organizations_url":"https://api.github.com/users/greenplum-db/orgs","repos_url":"https://api.github.com/users/greenplum-db/repos","events_url":"https://api.github.com/users/greenplum-db/events{/privacy}","received_events_url":"https://api.github.com/users/greenplum-db/received_events","type":"Organization","site_admin":false},"repo":{"id":44781140,"name":"gpdb","full_name":"greenplum-db/gpdb","owner":{"login":"greenplum-db","id":14097842,"avatar_url":"https://avatars.githubusercontent.com/u/14097842?v=3","gravatar_id":"","url":"https://api.github.com/users/greenplum-db","html_url":"https://github.com/greenplum-db","followers_url":"https://api.github.com/users/greenplum-db/followers","following_url":"https://api.github.com/users/greenplum-db/following{/other_user}","gists_url":"https://api.github.com/users/greenplum-db/gists{/gist_id}","starred_url":"https://api.github.com/users/greenplum-db/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/greenplum-db/subscriptions","organizations_url":"https://api.github.com/users/greenplum-db/orgs","repos_url":"https://api.github.com/users/greenplum-db/repos","events_url":"https://api.github.com/users/greenplum-db/events{/privacy}","received_events_url":"https://api.github.com/users/greenplum-db/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/greenplum-db/gpdb","description":"Greenplum Database","fork":false,"url":"https://api.github.com/repos/greenplum-db/gpdb","forks_url":"https://api.github.com/repos/greenplum-db/gpdb/forks","keys_url":"https://api.github.com/repos/greenplum-db/gpdb/keys{/key_id}","collaborators_url":"https://api.github.com/repos/greenplum-db/gpdb/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/greenplum-db/gpdb/teams","hooks_url":"https://api.github.com/repos/greenplum-db/gpdb/hooks","issue_events_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/events{/number}","events_url":"https://api.github.com/repos/greenplum-db/gpdb/events","assignees_url":"https://api.github.com/repos/greenplum-db/gpdb/assignees{/user}","branches_url":"https://api.github.com/repos/greenplum-db/gpdb/branches{/branch}","tags_url":"https://api.github.com/repos/greenplum-db/gpdb/tags","blobs_url":"https://api.github.com/repos/greenplum-db/gpdb/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/greenplum-db/gpdb/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/greenplum-db/gpdb/git/refs{/sha}","trees_url":"https://api.github.com/repos/greenplum-db/gpdb/git/trees{/sha}","statuses_url":"https://api.github.com/repos/greenplum-db/gpdb/statuses/{sha}","languages_url":"https://api.github.com/repos/greenplum-db/gpdb/languages","stargazers_url":"https://api.github.com/repos/greenplum-db/gpdb/stargazers","contributors_url":"https://api.github.com/repos/greenplum-db/gpdb/contributors","subscribers_url":"https://api.github.com/repos/greenplum-db/gpdb/subscribers","subscription_url":"https://api.github.com/repos/greenplum-db/gpdb/subscription","commits_url":"https://api.github.com/repos/greenplum-db/gpdb/commits{/sha}","git_commits_url":"https://api.github.com/repos/greenplum-db/gpdb/git/commits{/sha}","comments_url":"https://api.github.com/repos/greenplum-db/gpdb/comments{/number}","issue_comment_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/comments{/number}","contents_url":"https://api.github.com/repos/greenplum-db/gpdb/contents/{+path}","compare_url":"https://api.github.com/repos/greenplum-db/gpdb/compare/{base}...{head}","merges_url":"https://api.github.com/repos/greenplum-db/gpdb/merges","archive_url":"https://api.github.com/repos/greenplum-db/gpdb/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/greenplum-db/gpdb/downloads","issues_url":"https://api.github.com/repos/greenplum-db/gpdb/issues{/number}","pulls_url":"https://api.github.com/repos/greenplum-db/gpdb/pulls{/number}","milestones_url":"https://api.github.com/repos/greenplum-db/gpdb/milestones{/number}","notifications_url":"https://api.github.com/repos/greenplum-db/gpdb/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/greenplum-db/gpdb/labels{/name}","releases_url":"https://api.github.com/repos/greenplum-db/gpdb/releases{/id}","deployments_url":"https://api.github.com/repos/greenplum-db/gpdb/deployments","created_at":"2015-10-23T00:25:17Z","updated_at":"2016-04-19T17:15:59Z","pushed_at":"2016-04-19T17:41:42Z","git_url":"git://github.com/greenplum-db/gpdb.git","ssh_url":"git@github.com:greenplum-db/gpdb.git","clone_url":"https://github.com/greenplum-db/gpdb.git","svn_url":"https://github.com/greenplum-db/gpdb","homepage":"http://greenplum.org","size":151457,"stargazers_count":1401,"watchers_count":1401,"language":"PLpgSQL","has_issues":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":362,"mirror_url":null,"open_issues_count":78,"forks":362,"open_issues":78,"watchers":1401,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/greenplum-db/gpdb/pulls/647"},"html":{"href":"https://github.com/greenplum-db/gpdb/pull/647"},"issue":{"href":"https://api.github.com/repos/greenplum-db/gpdb/issues/647"},"comments":{"href":"https://api.github.com/repos/greenplum-db/gpdb/issues/647/comments"},"review_comments":{"href":"https://api.github.com/repos/greenplum-db/gpdb/pulls/647/comments"},"review_comment":{"href":"https://api.github.com/repos/greenplum-db/gpdb/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/greenplum-db/gpdb/pulls/647/commits"},"statuses":{"href":"https://api.github.com/repos/greenplum-db/gpdb/statuses/c4383dd4998c67eed5ed59ad3c7fb2047b3a1089"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"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},"comments":12,"review_comments":2,"commits":1,"additions":15,"deletions":2,"changed_files":4}}