{"action":"created","comment":{"url":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/comments/82594588","pull_request_review_id":3485811,"id":82594588,"diff_hunk":"@@ -153,58 +226,89 @@ EXPLAIN SELECT * FROM pgbench_accounts WHERE filler LIKE '%x%';\n         parallel plan, because the parallel query system is unable to verify\n         that the code in the loop is safe to execute while parallel query is\n         active. \n+-->\n+クエリが実行中に一時停止するかもしれません。\n+クエリの一部あるいは増分の実行が発生するとシステムが判断すると、パラレルプランは生成されません。\n+たとえば、<link linkend=\"sql-declare\">DECLARE CURSOR</link>で作られるカーソルは、決してパラレルプランを使用しません。\n+同様に、<LITERAL>FOR X IN QUERY LOOP .. END LOOP</LITERAL>のPL/pgsqlループは、決してパラレルプランを使用しません。\n+パラレルクエリが実行中に、ループの中のコードを実行しても安全かどうか、パラレルクエリシステムが判断できないからです。\n       </para>\n     </listitem>\n \n     <listitem>\n       <para>\n+<!--\n         The query uses any function marked <literal>PARALLEL UNSAFE</literal>.\n         Most system-defined functions are <literal>PARALLEL SAFE</literal>,\n         but user-defined functions are marked <literal>PARALLEL\n         UNSAFE</literal> by default. See the discussion of\n         <xref linkend=\"parallel-safety\">.\n+-->\n+クエリが<literal>PARALLEL UNSAFE</literal>とマーク付されている関数を使っています。\n+ほとんどのシステム定義の関数は<literal>PARALLEL SAFE</literal>です。\n+しかし、ユーザ定義関数はデフォルトで<literal>PARALLEL UNSAFE</literal>とマーク付されます。\n+<xref linkend=\"parallel-safety\">の議論をご覧ください。\n       </para>\n     </listitem>\n \n     <listitem>\n       <para>\n+<!--\n         The query is running inside of another query that is already parallel.\n         For example, if a function called by a parallel query issues an SQL\n         query itself, that query will never use a parallel plan. This is a\n         limitation of the current implementation, but it may not be desirable\n         to remove this limitation, since it could result in a single query\n         using a very large number of processes. \n+-->\n+クエリが、すでにパラレル実行している別のクエリの内部で走っています。\n+たとえば、パラレルクエリから呼ばれている関数がSQLクエリ自身を発行すると、そのクエリは決してパラレルプランを使用しません。","path":"doc/src/sgml/parallel.sgml","position":235,"original_position":236,"commit_id":"fada8468f4e9979f42632b4e0c9f39a92b9833f9","original_commit_id":"fada8468f4e9979f42632b4e0c9f39a92b9833f9","user":{"login":"smatsudajp","id":9957785,"avatar_url":"https://avatars.githubusercontent.com/u/9957785?v=3","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":"itselfは無理に訳さなくても良いかも知れませんが、訳すのであれば「関数自身がSQLクエリを発行する」ですね。","created_at":"2016-10-10T12:35:28Z","updated_at":"2016-10-10T12:35:28Z","html_url":"https://github.com/pgsql-jp/jpug-doc/pull/713#discussion_r82594588","pull_request_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/713","_links":{"self":{"href":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/comments/82594588"},"html":{"href":"https://github.com/pgsql-jp/jpug-doc/pull/713#discussion_r82594588"},"pull_request":{"href":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/713"}}},"pull_request":{"url":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/713","id":88642888,"html_url":"https://github.com/pgsql-jp/jpug-doc/pull/713","diff_url":"https://github.com/pgsql-jp/jpug-doc/pull/713.diff","patch_url":"https://github.com/pgsql-jp/jpug-doc/pull/713.patch","issue_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/issues/713","number":713,"state":"open","locked":false,"title":"9.6で新規に追加されたparallel.sgmlの翻訳です。","user":{"login":"tatsuo-ishii","id":5737836,"avatar_url":"https://avatars.githubusercontent.com/u/5737836?v=3","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":"2016-10-10T10:53:49Z","updated_at":"2016-10-10T13:03:19Z","closed_at":null,"merged_at":null,"merge_commit_sha":"2acc07d7d42d9d4102ff9305d2d07259434c4533","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/713/commits","review_comments_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/713/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/713/comments","statuses_url":"https://api.github.com/repos/pgsql-jp/jpug-doc/statuses/fada8468f4e9979f42632b4e0c9f39a92b9833f9","head":{"label":"tatsuo-ishii:parallel96","ref":"parallel96","sha":"fada8468f4e9979f42632b4e0c9f39a92b9833f9","user":{"login":"tatsuo-ishii","id":5737836,"avatar_url":"https://avatars.githubusercontent.com/u/5737836?v=3","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://avatars.githubusercontent.com/u/5737836?v=3","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":"2016-10-10T13:01:39Z","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":253669,"stargazers_count":0,"watchers_count":0,"language":"C","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"doc_ja_9_6"}},"base":{"label":"pgsql-jp:doc_ja_9_6","ref":"doc_ja_9_6","sha":"979f132ebfde3ef0a0af66902f4469bd2afe01bd","user":{"login":"pgsql-jp","id":7592797,"avatar_url":"https://avatars.githubusercontent.com/u/7592797?v=3","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://avatars.githubusercontent.com/u/7592797?v=3","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":"2016-09-22T00:08:46Z","pushed_at":"2016-10-10T13:00:03Z","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":248222,"stargazers_count":60,"watchers_count":60,"language":"C","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":31,"mirror_url":null,"open_issues_count":36,"forks":31,"open_issues":36,"watchers":60,"default_branch":"doc_ja_9_6"}},"_links":{"self":{"href":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/713"},"html":{"href":"https://github.com/pgsql-jp/jpug-doc/pull/713"},"issue":{"href":"https://api.github.com/repos/pgsql-jp/jpug-doc/issues/713"},"comments":{"href":"https://api.github.com/repos/pgsql-jp/jpug-doc/issues/713/comments"},"review_comments":{"href":"https://api.github.com/repos/pgsql-jp/jpug-doc/pulls/713/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/713/commits"},"statuses":{"href":"https://api.github.com/repos/pgsql-jp/jpug-doc/statuses/fada8468f4e9979f42632b4e0c9f39a92b9833f9"}}}}
{"actor":{"display_login":"smatsudajp"}}