{"action":"created","issue":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/8734","repository_url":"https://api.github.com/repos/greenplum-db/gpdb","labels_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/8734/labels{/name}","comments_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/8734/comments","events_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/8734/events","html_url":"https://github.com/greenplum-db/gpdb/pull/8734","id":500295858,"node_id":"MDExOlB1bGxSZXF1ZXN0MzIyNzk3MzE5","number":8734,"title":"Remove duplicate entry from greenplum specific gucs","user":{"login":"gkokolatos","id":46347323,"node_id":"MDQ6VXNlcjQ2MzQ3MzIz","avatar_url":"https://avatars0.githubusercontent.com/u/46347323?v=4","gravatar_id":"","url":"https://api.github.com/users/gkokolatos","html_url":"https://github.com/gkokolatos","followers_url":"https://api.github.com/users/gkokolatos/followers","following_url":"https://api.github.com/users/gkokolatos/following{/other_user}","gists_url":"https://api.github.com/users/gkokolatos/gists{/gist_id}","starred_url":"https://api.github.com/users/gkokolatos/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gkokolatos/subscriptions","organizations_url":"https://api.github.com/users/gkokolatos/orgs","repos_url":"https://api.github.com/users/gkokolatos/repos","events_url":"https://api.github.com/users/gkokolatos/events{/privacy}","received_events_url":"https://api.github.com/users/gkokolatos/received_events","type":"User","site_admin":false},"labels":[{"id":1271499630,"node_id":"MDU6TGFiZWwxMjcxNDk5NjMw","url":"https://api.github.com/repos/greenplum-db/gpdb/labels/version:%206X_STABLE","name":"version: 6X_STABLE","color":"8CFAFF","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2019-09-30T13:58:11Z","updated_at":"2019-09-30T18:14:36Z","closed_at":null,"author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/8734","html_url":"https://github.com/greenplum-db/gpdb/pull/8734","diff_url":"https://github.com/greenplum-db/gpdb/pull/8734.diff","patch_url":"https://github.com/greenplum-db/gpdb/pull/8734.patch"},"body":"Duplicates will be reported twice in pg_settings or `show all` statements.\r\n\r\nCurrent master is not affected.\r\n\r\nReported-by: Cyrille Lintz <clintz@pivotal.io>\r\n"},"comment":{"url":"https://api.github.com/repos/greenplum-db/gpdb/issues/comments/536684782","html_url":"https://github.com/greenplum-db/gpdb/pull/8734#issuecomment-536684782","issue_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/8734","id":536684782,"node_id":"MDEyOklzc3VlQ29tbWVudDUzNjY4NDc4Mg==","user":{"login":"jimmyyih","id":1973115,"node_id":"MDQ6VXNlcjE5NzMxMTU=","avatar_url":"https://avatars2.githubusercontent.com/u/1973115?v=4","gravatar_id":"","url":"https://api.github.com/users/jimmyyih","html_url":"https://github.com/jimmyyih","followers_url":"https://api.github.com/users/jimmyyih/followers","following_url":"https://api.github.com/users/jimmyyih/following{/other_user}","gists_url":"https://api.github.com/users/jimmyyih/gists{/gist_id}","starred_url":"https://api.github.com/users/jimmyyih/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jimmyyih/subscriptions","organizations_url":"https://api.github.com/users/jimmyyih/orgs","repos_url":"https://api.github.com/users/jimmyyih/repos","events_url":"https://api.github.com/users/jimmyyih/events{/privacy}","received_events_url":"https://api.github.com/users/jimmyyih/received_events","type":"User","site_admin":false},"created_at":"2019-09-30T18:14:36Z","updated_at":"2019-09-30T18:14:36Z","author_association":"MEMBER","body":"There seems to be 3 other instances of this as well:\r\n```\r\npostgres=# select * from pg_settings where name in ('gp_enable_minmax_optimization', 'autovacuum_max_workers', 'IntervalStyle', 'cursor_tuple_fraction');\r\n             name              | setting  | unit |                      category                      |                                       short_desc                                       | extra_desc |  context   | vartype | source  | min_val | max_val |                     enumvals                      | boot_val | reset_val | sourcefile | sourceline\r\n-------------------------------+----------+------+----------------------------------------------------+----------------------------------------------------------------------------------------+------------+------------+---------+---------+---------+---------+---------------------------------------------------+----------+-----------+------------+------------\r\n autovacuum_max_workers        | 3        |      | Autovacuum                                         | Sets the maximum number of simultaneously running autovacuum worker processes.         |            | postmaster | integer | default | 1       | 8388607 |                                                   | 3        | 3         |            |\r\n autovacuum_max_workers        | 3        |      | Autovacuum                                         | Sets the maximum number of simultaneously running autovacuum worker processes.         |            | postmaster | integer | default | 1       | 8388607 |                                                   | 3        | 3         |            |\r\n cursor_tuple_fraction         | 1        |      | Query Tuning / Other Planner Options               | Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved. |            | user       | real    | default | 0       | 1       |                                                   | 1        | 1         |            |\r\n cursor_tuple_fraction         | 1        |      | Query Tuning / Other Planner Options               | Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved. |            | user       | real    | default | 0       | 1       |                                                   | 1        | 1         |            |\r\n gp_enable_minmax_optimization | on       |      | Query Tuning / Planner Method Configuration        | Enables the planner's use of index scans with limit to implement MIN/MAX.              |            | user       | bool    | default |         |         |                                                   | on       | on        |            |\r\n gp_enable_minmax_optimization | on       |      | Query Tuning / Planner Method Configuration        | Enables the planner's use of index scans with limit to implement MIN/MAX.              |            | user       | bool    | default |         |         |                                                   | on       | on        |            |\r\n IntervalStyle                 | postgres |      | Client Connection Defaults / Locale and Formatting | Sets the display format for interval values.                                           |            | user       | enum    | default |         |         | {postgres,postgres_verbose,sql_standard,iso_8601} | postgres | postgres  |            |\r\n IntervalStyle                 | postgres |      | Client Connection Defaults / Locale and Formatting | Sets the display format for interval values.                                           |            | user       | enum    | default |         |         | {postgres,postgres_verbose,sql_standard,iso_8601} | postgres | postgres  |            |\r\n(8 rows)\r\n```\r\n\r\nIt seems like the GUCs above were removed in the master dev branch last month in fd72d83c31e12f32.  Not sure how backportable that commit is. Might want to wait for @weinan003's thoughts to avoid any duplicate work."}}
{"actor":{"display_login":"jimmyyih"}}