{"action":"created","comment":{"url":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/comments/148954511","pull_request_review_id":74278347,"id":148954511,"diff_hunk":"@@ -1543,19 +1586,33 @@ WHERE tablename = 'road';\n      Even in a fully normalized database, there may be partial correlation\n      between some columns, which can be expressed as partial functional\n      dependency.\n+-->\n+もっとも単純な拡張統計情報は、データベースの正規形の定義で使われる考え方である、<firstterm>関数従属性</>を追跡します。\n+<structfield>a</>の値に関する知識が<structfield>b</>の値を決定するのに十分であるとき、列<structfield>b</>は列<structfield>a</>に関数的に従属していると言います。\n+これはすなわち、同じ<structfield>a</>の値を持ちながら、異なる<structfield>b</>の値を持つ二つの行は存在しないということです。\n+完全に正規化されたデータベースでは、関数従属性は主キーと超キーにのみ存在します。\n+実際には様々な理由でデータの集合は完全には正規化されません。\n+性能上の理由により非正規化するというのが典型的な例です。\n+完全に正規化されたデータベースにおいても、ある列の間に部分的な相関関係が存在することがあり、これは部分的関数従属性として表現されます。\n     </para>\n \n     <para>\n+<!--\n      The existence of functional dependencies directly affects the accuracy\n      of estimates in certain queries.  If a query contains conditions on\n      both the independent and the dependent column(s), the\n      conditions on the dependent columns do not further reduce the result\n      size; but without knowledge of the functional dependency, the query\n      planner will assume that the conditions are independent, resulting\n      in underestimating the result size.\n+-->\n+あるクエリでは、関数従属性が存在することが直接見積もりの精度に影響を与えます。","path":"doc/src/sgml/perform.sgml","position":145,"original_position":145,"commit_id":"84780af936b984b4ddefe32ba5d80d5154575ff7","original_commit_id":"84780af936b984b4ddefe32ba5d80d5154575ff7","user":{"login":"smatsudajp","id":9957785,"avatar_url":"https://avatars1.githubusercontent.com/u/9957785?v=4","gravatar_id":"","url":"https://api.github.com/users/smatsudajp","html_url":"https://github.com/smatsudajp","followers_url":"https://api.github.com/users/smatsudajp/followers","following_url":"https://api.github.com/users/smatsudajp/following{/other_user}","gists_url":"https://api.github.com/users/smatsudajp/gists{/gist_id}","starred_url":"https://api.github.com/users/smatsudajp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/smatsudajp/subscriptions","organizations_url":"https://api.github.com/users/smatsudajp/orgs","repos_url":"https://api.github.com/users/smatsudajp/repos","events_url":"https://api.github.com/users/smatsudajp/events{/privacy}","received_events_url":"https://api.github.com/users/smatsudajp/received_events","type":"User","site_admin":false},"body":"「直接見積もり」という用語があるかのように誤読されるかもしれないので、読点を入れるか、「直接」を「影響」の直前に移すのが良いです。\r\nまた「クエリ」はこのマニュアル内では基本的に「問い合わせ」と訳していますね（次の文も）。","created_at":"2017-11-05T11:16:24Z","updated_at":"2017-11-05T11:46:19Z","html_url":"https://github.com/pgsql-jp/jpug-doc/pull/1104#discussion_r148954511","pull_request_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/1104","author_association":"MEMBER","_links":{"self":{"href":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/comments/148954511"},"html":{"href":"https://github.com/pgsql-jp/jpug-doc/pull/1104#discussion_r148954511"},"pull_request":{"href":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/1104"}}},"pull_request":{"url":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/1104","id":150677738,"html_url":"https://github.com/pgsql-jp/jpug-doc/pull/1104","diff_url":"https://github.com/pgsql-jp/jpug-doc/pull/1104.diff","patch_url":"https://github.com/pgsql-jp/jpug-doc/pull/1104.patch","issue_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/issues/1104","number":1104,"state":"open","locked":false,"title":"perform.sgmlのPostgreSQL 10対応です。","user":{"login":"tatsuo-ishii","id":5737836,"avatar_url":"https://avatars1.githubusercontent.com/u/5737836?v=4","gravatar_id":"","url":"https://api.github.com/users/tatsuo-ishii","html_url":"https://github.com/tatsuo-ishii","followers_url":"https://api.github.com/users/tatsuo-ishii/followers","following_url":"https://api.github.com/users/tatsuo-ishii/following{/other_user}","gists_url":"https://api.github.com/users/tatsuo-ishii/gists{/gist_id}","starred_url":"https://api.github.com/users/tatsuo-ishii/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tatsuo-ishii/subscriptions","organizations_url":"https://api.github.com/users/tatsuo-ishii/orgs","repos_url":"https://api.github.com/users/tatsuo-ishii/repos","events_url":"https://api.github.com/users/tatsuo-ishii/events{/privacy}","received_events_url":"https://api.github.com/users/tatsuo-ishii/received_events","type":"User","site_admin":false},"body":"","created_at":"2017-11-04T14:00:11Z","updated_at":"2017-11-05T11:46:19Z","closed_at":null,"merged_at":null,"merge_commit_sha":"08f585156f261f0ea088855098e9cfb9bd033aac","assignee":null,"assignees":[],"requested_reviewers":[],"milestone":null,"commits_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/1104/commits","review_comments_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/1104/comments","review_comment_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/comments{/number}","comments_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/issues/1104/comments","statuses_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/statuses/84780af936b984b4ddefe32ba5d80d5154575ff7","head":{"label":"tatsuo-ishii:perform10","ref":"perform10","sha":"84780af936b984b4ddefe32ba5d80d5154575ff7","user":{"login":"tatsuo-ishii","id":5737836,"avatar_url":"https://avatars1.githubusercontent.com/u/5737836?v=4","gravatar_id":"","url":"https://api.github.com/users/tatsuo-ishii","html_url":"https://github.com/tatsuo-ishii","followers_url":"https://api.github.com/users/tatsuo-ishii/followers","following_url":"https://api.github.com/users/tatsuo-ishii/following{/other_user}","gists_url":"https://api.github.com/users/tatsuo-ishii/gists{/gist_id}","starred_url":"https://api.github.com/users/tatsuo-ishii/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tatsuo-ishii/subscriptions","organizations_url":"https://api.github.com/users/tatsuo-ishii/orgs","repos_url":"https://api.github.com/users/tatsuo-ishii/repos","events_url":"https://api.github.com/users/tatsuo-ishii/events{/privacy}","received_events_url":"https://api.github.com/users/tatsuo-ishii/received_events","type":"User","site_admin":false},"repo":{"id":48461241,"name":"jpug-doc","full_name":"tatsuo-ishii/jpug-doc","owner":{"login":"tatsuo-ishii","id":5737836,"avatar_url":"https://avatars1.githubusercontent.com/u/5737836?v=4","gravatar_id":"","url":"https://api.github.com/users/tatsuo-ishii","html_url":"https://github.com/tatsuo-ishii","followers_url":"https://api.github.com/users/tatsuo-ishii/followers","following_url":"https://api.github.com/users/tatsuo-ishii/following{/other_user}","gists_url":"https://api.github.com/users/tatsuo-ishii/gists{/gist_id}","starred_url":"https://api.github.com/users/tatsuo-ishii/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tatsuo-ishii/subscriptions","organizations_url":"https://api.github.com/users/tatsuo-ishii/orgs","repos_url":"https://api.github.com/users/tatsuo-ishii/repos","events_url":"https://api.github.com/users/tatsuo-ishii/events{/privacy}","received_events_url":"https://api.github.com/users/tatsuo-ishii/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/tatsuo-ishii/jpug-doc","description":"PostgreSQL database manual Japanese translation by Japan PostgreSQL Users Group","fork":true,"url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc","forks_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/forks","keys_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/keys{/key_id}","collaborators_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/teams","hooks_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/hooks","issue_events_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/issues/events{/number}","events_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/events","assignees_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/assignees{/user}","branches_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/branches{/branch}","tags_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/tags","blobs_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/git/refs{/sha}","trees_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/git/trees{/sha}","statuses_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/statuses/{sha}","languages_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/languages","stargazers_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/stargazers","contributors_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/contributors","subscribers_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/subscribers","subscription_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/subscription","commits_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/commits{/sha}","git_commits_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/git/commits{/sha}","comments_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/comments{/number}","issue_comment_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/issues/comments{/number}","contents_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/contents/{+path}","compare_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/compare/{base}...{head}","merges_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/merges","archive_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/downloads","issues_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/issues{/number}","pulls_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/pulls{/number}","milestones_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/milestones{/number}","notifications_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/labels{/name}","releases_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/releases{/id}","deployments_url":"https://api.github.com/repos/tatsuo-ishii/jpug-doc/deployments","created_at":"2015-12-23T00:55:32Z","updated_at":"2016-07-06T23:09:22Z","pushed_at":"2017-11-05T07:22:47Z","git_url":"git://github.com/tatsuo-ishii/jpug-doc.git","ssh_url":"git@github.com:tatsuo-ishii/jpug-doc.git","clone_url":"https://github.com/tatsuo-ishii/jpug-doc.git","svn_url":"https://github.com/tatsuo-ishii/jpug-doc","homepage":null,"size":284899,"stargazers_count":0,"watchers_count":0,"language":"C","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"doc_ja_10"}},"base":{"label":"pgsql-jp:doc_ja_10","ref":"doc_ja_10","sha":"70481c06c8bc53c5b92d7f661d0befa5f4dfc9ed","user":{"login":"pgsql-jp","id":7592797,"avatar_url":"https://avatars0.githubusercontent.com/u/7592797?v=4","gravatar_id":"","url":"https://api.github.com/users/pgsql-jp","html_url":"https://github.com/pgsql-jp","followers_url":"https://api.github.com/users/pgsql-jp/followers","following_url":"https://api.github.com/users/pgsql-jp/following{/other_user}","gists_url":"https://api.github.com/users/pgsql-jp/gists{/gist_id}","starred_url":"https://api.github.com/users/pgsql-jp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pgsql-jp/subscriptions","organizations_url":"https://api.github.com/users/pgsql-jp/orgs","repos_url":"https://api.github.com/users/pgsql-jp/repos","events_url":"https://api.github.com/users/pgsql-jp/events{/privacy}","received_events_url":"https://api.github.com/users/pgsql-jp/received_events","type":"Organization","site_admin":false},"repo":{"id":21112786,"name":"jpug-doc","full_name":"pgsql-jp/jpug-doc","owner":{"login":"pgsql-jp","id":7592797,"avatar_url":"https://avatars0.githubusercontent.com/u/7592797?v=4","gravatar_id":"","url":"https://api.github.com/users/pgsql-jp","html_url":"https://github.com/pgsql-jp","followers_url":"https://api.github.com/users/pgsql-jp/followers","following_url":"https://api.github.com/users/pgsql-jp/following{/other_user}","gists_url":"https://api.github.com/users/pgsql-jp/gists{/gist_id}","starred_url":"https://api.github.com/users/pgsql-jp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pgsql-jp/subscriptions","organizations_url":"https://api.github.com/users/pgsql-jp/orgs","repos_url":"https://api.github.com/users/pgsql-jp/repos","events_url":"https://api.github.com/users/pgsql-jp/events{/privacy}","received_events_url":"https://api.github.com/users/pgsql-jp/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/pgsql-jp/jpug-doc","description":"PostgreSQL database manual Japanese translation by Japan PostgreSQL Users Group","fork":false,"url":"https://api.github.com/repos/pgsql-jp/jpug-doc","forks_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/forks","keys_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/keys{/key_id}","collaborators_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/teams","hooks_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/hooks","issue_events_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/issues/events{/number}","events_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/events","assignees_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/assignees{/user}","branches_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/branches{/branch}","tags_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/tags","blobs_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/git/refs{/sha}","trees_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/git/trees{/sha}","statuses_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/statuses/{sha}","languages_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/languages","stargazers_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/stargazers","contributors_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/contributors","subscribers_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/subscribers","subscription_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/subscription","commits_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/commits{/sha}","git_commits_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/git/commits{/sha}","comments_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/comments{/number}","issue_comment_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/issues/comments{/number}","contents_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/contents/{+path}","compare_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/compare/{base}...{head}","merges_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/merges","archive_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/downloads","issues_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/issues{/number}","pulls_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls{/number}","milestones_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/milestones{/number}","notifications_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/labels{/name}","releases_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/releases{/id}","deployments_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/deployments","created_at":"2014-06-23T03:27:30Z","updated_at":"2017-09-26T08:05:33Z","pushed_at":"2017-11-05T10:53:08Z","git_url":"git://github.com/pgsql-jp/jpug-doc.git","ssh_url":"git@github.com:pgsql-jp/jpug-doc.git","clone_url":"https://github.com/pgsql-jp/jpug-doc.git","svn_url":"https://github.com/pgsql-jp/jpug-doc","homepage":null,"size":280139,"stargazers_count":67,"watchers_count":67,"language":"C","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":39,"mirror_url":null,"archived":false,"open_issues_count":80,"forks":39,"open_issues":80,"watchers":67,"default_branch":"doc_ja_10"}},"_links":{"self":{"href":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/1104"},"html":{"href":"https://github.com/pgsql-jp/jpug-doc/pull/1104"},"issue":{"href":"https://api.github.com/repos/pgsql-jp/jpug-doc/issues/1104"},"comments":{"href":"https://api.github.com/repos/pgsql-jp/jpug-doc/issues/1104/comments"},"review_comments":{"href":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/1104/comments"},"review_comment":{"href":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/1104/commits"},"statuses":{"href":"https://api.github.com/repos/pgsql-jp/jpug-doc/statuses/84780af936b984b4ddefe32ba5d80d5154575ff7"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"smatsudajp"}}