{"action":"created","comment":{"url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/comments/146952011","pull_request_review_id":71971227,"id":146952011,"diff_hunk":"@@ -1,44 +1,96 @@\n <?xml version=\"1.0\" encoding=\"UTF-8\"?>\n <!DOCTYPE topic\n   PUBLIC \"-//OASIS//DTD DITA Composite//EN\" \"ditabase.dtd\">\n-<topic id=\"topic1\"><title id=\"pj138418\">gpreload</title><body><p>Reloads Greenplum Database table data sorting the data based on specified\n-columns. </p><section id=\"section2\"><title>Synopsis</title><codeblock><b>gpreload</b> <b>-d</b> <varname>database</varname> [<b>-p</b> <varname>port</varname>] {<b>-t</b> | <b>--table-file</b>} <varname>path_to_file</varname> [<b>-a</b>]\n+<topic id=\"topic1\">\n+  <title id=\"pj138418\">gpreload</title>\n+  <body>\n+    <p>Reloads Greenplum Database table data sorting the data based on specified columns. </p>\n+    <section id=\"section2\"\n+      ><title>Synopsis</title><codeblock><b>gpreload</b> <b>-d</b> <varname>database</varname> [<b>-p</b> <varname>port</varname>] {<b>-t</b> | <b>--table-file</b>} <varname>path_to_file</varname> [<b>-a</b>]\n \n <b>gpreload</b> <b>-h</b> \n \n-<b>gpreload</b> <b>--version</b></codeblock></section><section id=\"section3\"><title>Description</title><p>The <codeph>gpreload</codeph> utility reloads table data with column\n-data sorted. For tables that were created with the table storage option\n-<codeph>APPENDONLY=TRUE</codeph> and compression enabled, reloading the\n-data with sorted data can improve table compression. You specify a list\n-of tables to be reloaded the table column to be sorted in a text file.\n-</p><p>Compression is improved by sorting data when the data in the column\n-has a relatively low number of distinct values when compared to the total\n-number of rows.</p><p>For a table being reloaded, the order of the columns to be sorted\n-might affect compression. The columns with fewest distinct values should\n-be listed first. For example, listing state then city would generally\n-result in better compression than listing city then state. </p><codeblock>public.cust_table: state, city\n-public.cust_table: city, state</codeblock><p>For information about the format of the file used with <codeph>gpreload</codeph>,\n-see the <codeph>--table-file</codeph> option.</p></section><section id=\"section4\"><title>Notes</title><p>To improve reload performance, indexes on tables being reloaded should\n-be removed before reloading the data. </p><p>Running the <codeph>ANALYZE</codeph> command after reloading table\n-data might query performance because of a change in the data distribution\n-of the reloaded data. </p></section><section id=\"section5\"><title>Options</title><parml><plentry><pt>-a (do not prompt)</pt><pd>Optional. If specified, the <codeph>gpreload</codeph> utility does\n-not prompt the user for confirmation. </pd></plentry><plentry><pt>-d <varname>database</varname></pt><pd>The database that contains the tables to be reloaded. The <codeph>gpreload</codeph>\n-utility connects to the database as the user running the utility. </pd></plentry><plentry><pt>-p <varname>port</varname></pt><pd>The Greenplum Database master port. If not specified, the value of\n-the <codeph>PGPORT</codeph> environment variable is used. If the value\n-is not available, an error is returned. </pd></plentry><plentry><pt>{-t | --table-file } <varname>path_to_file</varname></pt><pd>The location and name of file containing list of schema qualified\n-table names to reload and the column names to reorder from the Greenplum\n-Database. Only user defined tables are supported. Views or system catalog\n-tables are not supported.</pd><pd>If indexes are defined on table listed in the file, <codeph>gpreload</codeph>\n-prompts to continue.</pd><pd>Each line specifies a table name and the list of columns to sort.\n-This is the format of each line in the file:</pd><pd><codeblock>schema.table_name: column [desc] [, column2 [desc] ... ]</codeblock></pd><pd>The table name is followed by a colon ( : ) and then at least one column\n-name. If you specify more than one column, separate the column names\n-with a comma. The columns are sorted in ascending order. Specify the\n-keyword <codeph>desc</codeph> after the column name to sort the column\n-in descending order. </pd><pd>Wildcard characters are not supported.</pd><pd>If there are errors in the file, <codeph>gpreload</codeph> reports\n-the first error and exits. No data is reloaded. </pd><pd>The following example reloads three\n+<b>gpreload</b> <b>--version</b></codeblock></section>\n+    <section id=\"section3\"><title>Description</title><p>The <codeph>gpreload</codeph> utility\n+        reloads table data with column data sorted. For tables that were created with the table\n+        storage option <codeph>APPENDONLY=TRUE</codeph> and compression enabled, reloading the data\n+        with sorted data can improve table compression. You specify a list of tables to be reloaded\n+        the table column to be sorted in a text file. </p><p>Compression is improved by sorting data\n+        when the data in the column has a relatively low number of distinct values when compared to\n+        the total number of rows.</p><p>For a table being reloaded, the order of the columns to be\n+        sorted might affect compression. The columns with fewest distinct values should be listed","path":"gpdb-doc/dita/utility_guide/admin_utilities/gpreload.xml","position":53,"original_position":53,"commit_id":"a5a52f3b5e390b75d4e6d7dfec1e7abcc9c2db1d","original_commit_id":"a5a52f3b5e390b75d4e6d7dfec1e7abcc9c2db1d","user":{"login":"dyozie","id":5695830,"avatar_url":"https://avatars0.githubusercontent.com/u/5695830?v=4","gravatar_id":"","url":"https://api.github.com/users/dyozie","html_url":"https://github.com/dyozie","followers_url":"https://api.github.com/users/dyozie/followers","following_url":"https://api.github.com/users/dyozie/following{/other_user}","gists_url":"https://api.github.com/users/dyozie/gists{/gist_id}","starred_url":"https://api.github.com/users/dyozie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dyozie/subscriptions","organizations_url":"https://api.github.com/users/dyozie/orgs","repos_url":"https://api.github.com/users/dyozie/repos","events_url":"https://api.github.com/users/dyozie/events{/privacy}","received_events_url":"https://api.github.com/users/dyozie/received_events","type":"User","site_admin":false},"body":"Add \"the\" to:  \"The columns with **the** fewest distinct\"","created_at":"2017-10-25T18:48:55Z","updated_at":"2017-10-25T19:04:25Z","html_url":"https://github.com/greenplum-db/gpdb/pull/3617#discussion_r146952011","pull_request_url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/3617","author_association":"CONTRIBUTOR","_links":{"self":{"href":"https://api.github.com/repos/greenplum-db/gpdb/pulls/comments/146952011"},"html":{"href":"https://github.com/greenplum-db/gpdb/pull/3617#discussion_r146952011"},"pull_request":{"href":"https://api.github.com/repos/greenplum-db/gpdb/pulls/3617"}}},"pull_request":{"url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/3617","id":148447820,"html_url":"https://github.com/greenplum-db/gpdb/pull/3617","diff_url":"https://github.com/greenplum-db/gpdb/pull/3617.diff","patch_url":"https://github.com/greenplum-db/gpdb/pull/3617.patch","issue_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/3617","number":3617,"state":"open","locked":false,"title":"docs: gpreload - add notes about how utility works.","user":{"login":"mkiyama","id":6181658,"avatar_url":"https://avatars0.githubusercontent.com/u/6181658?v=4","gravatar_id":"","url":"https://api.github.com/users/mkiyama","html_url":"https://github.com/mkiyama","followers_url":"https://api.github.com/users/mkiyama/followers","following_url":"https://api.github.com/users/mkiyama/following{/other_user}","gists_url":"https://api.github.com/users/mkiyama/gists{/gist_id}","starred_url":"https://api.github.com/users/mkiyama/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mkiyama/subscriptions","organizations_url":"https://api.github.com/users/mkiyama/orgs","repos_url":"https://api.github.com/users/mkiyama/repos","events_url":"https://api.github.com/users/mkiyama/events{/privacy}","received_events_url":"https://api.github.com/users/mkiyama/received_events","type":"User","site_admin":false},"body":"added this information\r\n\r\nFor each table, the utility copies table data to a temporary table, truncates the existing table data, and inserts data from the temporary table to the table in the specified sort order. Each table reload is performed in a single transaction.\r\n\r\nFor a partitioned table, you can reload the data of a leaf child partition. However, data is inserted from the root partition table, which acquires a ROW EXLCUSIVE lock on the entire table.\r\n\r\napproved for 4.3.x\r\n\r\nwill be backported to 5X_STABLE","created_at":"2017-10-24T16:25:50Z","updated_at":"2017-10-25T19:04:25Z","closed_at":null,"merged_at":null,"merge_commit_sha":"097afc195b350e43d72b731e552c434b6ddb5ba5","assignee":null,"assignees":[],"requested_reviewers":[],"milestone":null,"commits_url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/3617/commits","review_comments_url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/3617/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/3617/comments","statuses_url":"https://api.github.com/repos/greenplum-db/gpdb/statuses/a5a52f3b5e390b75d4e6d7dfec1e7abcc9c2db1d","head":{"label":"mkiyama:feature/gpreload","ref":"feature/gpreload","sha":"a5a52f3b5e390b75d4e6d7dfec1e7abcc9c2db1d","user":{"login":"mkiyama","id":6181658,"avatar_url":"https://avatars0.githubusercontent.com/u/6181658?v=4","gravatar_id":"","url":"https://api.github.com/users/mkiyama","html_url":"https://github.com/mkiyama","followers_url":"https://api.github.com/users/mkiyama/followers","following_url":"https://api.github.com/users/mkiyama/following{/other_user}","gists_url":"https://api.github.com/users/mkiyama/gists{/gist_id}","starred_url":"https://api.github.com/users/mkiyama/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mkiyama/subscriptions","organizations_url":"https://api.github.com/users/mkiyama/orgs","repos_url":"https://api.github.com/users/mkiyama/repos","events_url":"https://api.github.com/users/mkiyama/events{/privacy}","received_events_url":"https://api.github.com/users/mkiyama/received_events","type":"User","site_admin":false},"repo":{"id":80677210,"name":"gpdb","full_name":"mkiyama/gpdb","owner":{"login":"mkiyama","id":6181658,"avatar_url":"https://avatars0.githubusercontent.com/u/6181658?v=4","gravatar_id":"","url":"https://api.github.com/users/mkiyama","html_url":"https://github.com/mkiyama","followers_url":"https://api.github.com/users/mkiyama/followers","following_url":"https://api.github.com/users/mkiyama/following{/other_user}","gists_url":"https://api.github.com/users/mkiyama/gists{/gist_id}","starred_url":"https://api.github.com/users/mkiyama/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mkiyama/subscriptions","organizations_url":"https://api.github.com/users/mkiyama/orgs","repos_url":"https://api.github.com/users/mkiyama/repos","events_url":"https://api.github.com/users/mkiyama/events{/privacy}","received_events_url":"https://api.github.com/users/mkiyama/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/mkiyama/gpdb","description":"Greenplum Database","fork":true,"url":"https://api.github.com/repos/mkiyama/gpdb","forks_url":"https://api.github.com/repos/mkiyama/gpdb/forks","keys_url":"https://api.github.com/repos/mkiyama/gpdb/keys{/key_id}","collaborators_url":"https://api.github.com/repos/mkiyama/gpdb/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/mkiyama/gpdb/teams","hooks_url":"https://api.github.com/repos/mkiyama/gpdb/hooks","issue_events_url":"https://api.github.com/repos/mkiyama/gpdb/issues/events{/number}","events_url":"https://api.github.com/repos/mkiyama/gpdb/events","assignees_url":"https://api.github.com/repos/mkiyama/gpdb/assignees{/user}","branches_url":"https://api.github.com/repos/mkiyama/gpdb/branches{/branch}","tags_url":"https://api.github.com/repos/mkiyama/gpdb/tags","blobs_url":"https://api.github.com/repos/mkiyama/gpdb/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/mkiyama/gpdb/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/mkiyama/gpdb/git/refs{/sha}","trees_url":"https://api.github.com/repos/mkiyama/gpdb/git/trees{/sha}","statuses_url":"https://api.github.com/repos/mkiyama/gpdb/statuses/{sha}","languages_url":"https://api.github.com/repos/mkiyama/gpdb/languages","stargazers_url":"https://api.github.com/repos/mkiyama/gpdb/stargazers","contributors_url":"https://api.github.com/repos/mkiyama/gpdb/contributors","subscribers_url":"https://api.github.com/repos/mkiyama/gpdb/subscribers","subscription_url":"https://api.github.com/repos/mkiyama/gpdb/subscription","commits_url":"https://api.github.com/repos/mkiyama/gpdb/commits{/sha}","git_commits_url":"https://api.github.com/repos/mkiyama/gpdb/git/commits{/sha}","comments_url":"https://api.github.com/repos/mkiyama/gpdb/comments{/number}","issue_comment_url":"https://api.github.com/repos/mkiyama/gpdb/issues/comments{/number}","contents_url":"https://api.github.com/repos/mkiyama/gpdb/contents/{+path}","compare_url":"https://api.github.com/repos/mkiyama/gpdb/compare/{base}...{head}","merges_url":"https://api.github.com/repos/mkiyama/gpdb/merges","archive_url":"https://api.github.com/repos/mkiyama/gpdb/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/mkiyama/gpdb/downloads","issues_url":"https://api.github.com/repos/mkiyama/gpdb/issues{/number}","pulls_url":"https://api.github.com/repos/mkiyama/gpdb/pulls{/number}","milestones_url":"https://api.github.com/repos/mkiyama/gpdb/milestones{/number}","notifications_url":"https://api.github.com/repos/mkiyama/gpdb/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/mkiyama/gpdb/labels{/name}","releases_url":"https://api.github.com/repos/mkiyama/gpdb/releases{/id}","deployments_url":"https://api.github.com/repos/mkiyama/gpdb/deployments","created_at":"2017-02-01T23:58:26Z","updated_at":"2017-02-01T23:59:59Z","pushed_at":"2017-10-25T15:16:32Z","git_url":"git://github.com/mkiyama/gpdb.git","ssh_url":"git@github.com:mkiyama/gpdb.git","clone_url":"https://github.com/mkiyama/gpdb.git","svn_url":"https://github.com/mkiyama/gpdb","homepage":"http://greenplum.org","size":226508,"stargazers_count":0,"watchers_count":0,"language":"C","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"greenplum-db:master","ref":"master","sha":"f9e02827756d627850c7dd7ae832e56549733000","user":{"login":"greenplum-db","id":14097842,"avatar_url":"https://avatars2.githubusercontent.com/u/14097842?v=4","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://avatars2.githubusercontent.com/u/14097842?v=4","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":"2017-10-25T12:39:23Z","pushed_at":"2017-10-25T18:49:09Z","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":226428,"stargazers_count":2137,"watchers_count":2137,"language":"C","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":659,"mirror_url":null,"archived":false,"open_issues_count":209,"forks":659,"open_issues":209,"watchers":2137,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/greenplum-db/gpdb/pulls/3617"},"html":{"href":"https://github.com/greenplum-db/gpdb/pull/3617"},"issue":{"href":"https://api.github.com/repos/greenplum-db/gpdb/issues/3617"},"comments":{"href":"https://api.github.com/repos/greenplum-db/gpdb/issues/3617/comments"},"review_comments":{"href":"https://api.github.com/repos/greenplum-db/gpdb/pulls/3617/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/3617/commits"},"statuses":{"href":"https://api.github.com/repos/greenplum-db/gpdb/statuses/a5a52f3b5e390b75d4e6d7dfec1e7abcc9c2db1d"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"dyozie"}}