• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: コミット

firtst release


コミットメタ情報

リビジョン3c0c056b0600a143c4c33dec8a0df9f23ff48303 (tree)
日時2013-06-18 09:40:09
作者naoki_kishi_b1 <kishi_naoki_b1@lab....>
コミッターnaoki_kishi_b1

ログメッセージ

Signed-off-by: naoki_kishi_b1 <kishi_naoki_b1@lab.ntt.co.jp>

変更サマリ

差分

--- a/doc/pg_hint_plan.html
+++ b/doc/pg_hint_plan.html
@@ -34,7 +34,7 @@
3434 <p>pg_hint_plan -- Tweaking planner decisions with user's hists.</p>
3535
3636 <h2 id="synopsis">Synopsis</h2>
37-<p>PostgreSQL executes queries using cost-based optimizer, and sometimes fails to choose most optimized execution plan for some types of queries.</p>
37+<p>PostgreSQL executes queries using cost-based planner, and sometimes fails to choose most optimized execution plan for some types of queries.</p>
3838 <p>In such cases, pg_hint_plan helps users to guide the planner to choose the plans they want by putting some instructions - call them hints - in the comments prefixed to the SQL statement body. No need to rewrite statement itself nor change some GUC parameters elsewhere.</p>
3939
4040 <h2 id="description">Description</h2>
@@ -66,10 +66,11 @@ postgres-# ORDER BY a.aid;
6666 </pre>
6767
6868 <h3 id="hint-group">Tweakable operations</h3>
69-Pg_hint_plan can tweak planner for table scan methods, join methods, join orders, and temprary GUC setting during theplanner is running. For specific Hint of each group see <a href="hint_list.html">Hint list</a></p>
69+Pg_hint_plan can tweak planner for table scan methods, join methods, join orders, and temprary GUC setting during the planner is running. For specific Hint of each group, see <a href="hint_list.html">Hint list</a></p>
7070
7171 <h4>Tweaking scan method </h4>
7272 <p>The hint for scan methods takes one table name or alias and will instruct planner to prefer the specific scan method for the table. You can use (No)SeqScan, (No)IndexScan, (No)TidScan, (No)BitmapScan.</p>
73+The hint for scan methods takes one table name or alias and will instruct planner to prefer the specific scan method for the table. You can use (No)SeqScan, (No)IndexScan, (No)TidScan, (No)BitmapScan.
7374 <p>These hints are applicable for ordinary tables including unlogged or temporary ones, and system catalogues. Other objects, for example, external tables, table functions, Views, CTE, or subquery results are not covered.</p>
7475
7576 <h4>Tweaking join method</h4>
旧リポジトリブラウザで表示