{"action":"created","issue":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5745","repository_url":"https://api.github.com/repos/greenplum-db/gpdb","labels_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5745/labels{/name}","comments_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5745/comments","events_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5745/events","html_url":"https://github.com/greenplum-db/gpdb/pull/5745","id":359238480,"node_id":"MDExOlB1bGxSZXF1ZXN0MjE0Nzc4MTI1","number":5745,"title":"Update default value of optimizer_force_XXX gucs","user":{"login":"vraghavan78","id":12649877,"node_id":"MDQ6VXNlcjEyNjQ5ODc3","avatar_url":"https://avatars1.githubusercontent.com/u/12649877?v=4","gravatar_id":"","url":"https://api.github.com/users/vraghavan78","html_url":"https://github.com/vraghavan78","followers_url":"https://api.github.com/users/vraghavan78/followers","following_url":"https://api.github.com/users/vraghavan78/following{/other_user}","gists_url":"https://api.github.com/users/vraghavan78/gists{/gist_id}","starred_url":"https://api.github.com/users/vraghavan78/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vraghavan78/subscriptions","organizations_url":"https://api.github.com/users/vraghavan78/orgs","repos_url":"https://api.github.com/users/vraghavan78/repos","events_url":"https://api.github.com/users/vraghavan78/events{/privacy}","received_events_url":"https://api.github.com/users/vraghavan78/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-09-11T21:53:52Z","updated_at":"2018-09-12T17:47:16Z","closed_at":null,"author_association":"MEMBER","pull_request":{"url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/5745","html_url":"https://github.com/greenplum-db/gpdb/pull/5745","diff_url":"https://github.com/greenplum-db/gpdb/pull/5745.diff","patch_url":"https://github.com/greenplum-db/gpdb/pull/5745.patch"},"body":"In 2015, to avoid generating plans single stage aggregations due to cardinality misestimation we force the generation of multi-stage aggregation even when such a plan is sub-optimal. Since then we have fixed several of the cardinality estimation bugs. This PR reverts the default to be based on cost rather than a hint.\r\n\r\nIn cases, when the cardinality is still wrong user will have the opportunity to force it."},"comment":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/comments/420738024","html_url":"https://github.com/greenplum-db/gpdb/pull/5745#issuecomment-420738024","issue_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/5745","id":420738024,"node_id":"MDEyOklzc3VlQ29tbWVudDQyMDczODAyNA==","user":{"login":"bhuvnesh2703","id":10293569,"node_id":"MDQ6VXNlcjEwMjkzNTY5","avatar_url":"https://avatars1.githubusercontent.com/u/10293569?v=4","gravatar_id":"","url":"https://api.github.com/users/bhuvnesh2703","html_url":"https://github.com/bhuvnesh2703","followers_url":"https://api.github.com/users/bhuvnesh2703/followers","following_url":"https://api.github.com/users/bhuvnesh2703/following{/other_user}","gists_url":"https://api.github.com/users/bhuvnesh2703/gists{/gist_id}","starred_url":"https://api.github.com/users/bhuvnesh2703/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bhuvnesh2703/subscriptions","organizations_url":"https://api.github.com/users/bhuvnesh2703/orgs","repos_url":"https://api.github.com/users/bhuvnesh2703/repos","events_url":"https://api.github.com/users/bhuvnesh2703/events{/privacy}","received_events_url":"https://api.github.com/users/bhuvnesh2703/received_events","type":"User","site_admin":false},"created_at":"2018-09-12T17:47:16Z","updated_at":"2018-09-12T17:47:16Z","author_association":"MEMBER","body":"we should run perf pipeline to verify. LGTM otherwise"}}
{"actor":{"display_login":"bhuvnesh2703"}}