Commit: c9e741624f1695e955413003070b8e2142f4feae - amalsyah12 (git)

firtst release

Commit MetaInfo

• Revisión: c9e741624f1695e955413003070b8e2142f4feae (tree)
• Tiempo: 2019-01-17 14:16:50
• Autor: Kyotaro Horiguchi <horiguchi.kyotaro@lab....>
• Commiter: Kyotaro Horiguchi

Log Message

Change copyright year to 2019

With some minor fixes in the document.

Cambiar Resumen

• modified: COPYRIGHT
• modified: COPYRIGHT.postgresql
• modified: Makefile
• modified: SPECS/pg_hint_plan95.spec
• modified: core.c
• modified: doc/hint_list-ja.html
• modified: doc/hint_list.html
• modified: doc/pg_hint_plan-ja.html
• modified: doc/pg_hint_plan.html
• modified: make_join_rel.c
• modified: normalize_query.h
• modified: pg_hint_plan.c
• modified: pg_stat_statements.c

Diferencia incremental

--- a/COPYRIGHT
+++ b/COPYRIGHT
@@ -1,4 +1,4 @@
-Copyright (c) 2012-2018, NIPPON TELEGRAPH AND TELEPHONE CORPORATION
+Copyright (c) 2012-2019, NIPPON TELEGRAPH AND TELEPHONE CORPORATION
 All rights reserved.
 
 Redistribution and use in source and binary forms, with or without

--- a/COPYRIGHT.postgresql
+++ b/COPYRIGHT.postgresql
@@ -2,7 +2,7 @@ core.c and make_join_rel.c are parts of PostgreSQL Database Management System.
 (formerly known as Postgres, then as Postgres95)
 Copyright holders of those files are following organizations:
 
-Portions Copyright (c) 1996-2018, PostgreSQL Global Development Group
+Portions Copyright (c) 1996-2019, PostgreSQL Global Development Group
 
 Portions Copyright (c) 1994, The Regents of the University of California
 

--- a/Makefile
+++ b/Makefile
@@ -1,7 +1,7 @@
 #
 # pg_hint_plan: Makefile
 #
-# Copyright (c) 2012-2018, NIPPON TELEGRAPH AND TELEPHONE CORPORATION
+# Copyright (c) 2012-2019, NIPPON TELEGRAPH AND TELEPHONE CORPORATION
 #
 
 MODULES = pg_hint_plan

--- a/SPECS/pg_hint_plan95.spec
+++ b/SPECS/pg_hint_plan95.spec
@@ -1,5 +1,5 @@
-# SPEC file for pg_store_plans
-# Copyright(C) 2016-2018 NIPPON TELEGRAPH AND TELEPHONE CORPORATION
+# SPEC file for pg_hint_plan
+# Copyright(C) 2019 NIPPON TELEGRAPH AND TELEPHONE CORPORATION
 
 %define _pgdir   /usr/pgsql-9.5
 %define _bindir  %{_pgdir}/bin

--- a/core.c
+++ b/core.c
@@ -20,7 +20,8 @@
  *     mark_dummy_rel()
  *     restriction_is_constant_false()
  *
- * Portions Copyright (c) 1996-2015, PostgreSQL Global Development Group
+ *
+ * Portions Copyright (c) 1996-2019, PostgreSQL Global Development Group
  * Portions Copyright (c) 1994, Regents of the University of California
  *
  *-------------------------------------------------------------------------

--- a/doc/hint_list-ja.html
+++ b/doc/hint_list-ja.html
@@ -102,6 +102,6 @@ PostgreSQL 9.2以降で動作します。</td></tr>
   <a href="hint_list-ja.html">Appendix A. ヒント句一覧</a>
 </div>
 
-<p class="footer">Copyright (c) 2012-2014, NIPPON TELEGRAPH AND TELEPHONE CORPORATION</p>
+<p class="footer">Copyright (c) 2012-2019, NIPPON TELEGRAPH AND TELEPHONE CORPORATION</p>
 </body>
 </html>

--- a/doc/hint_list.html
+++ b/doc/hint_list.html
@@ -85,6 +85,6 @@
   <a href="hint_list-ja.html">Appendix A. hints list</a>
 </div>
 
-<p class="footer">Copyright (c) 2012, NIPPON TELEGRAPH AND TELEPHONE CORPORATION</p>
+<p class="footer">Copyright (c) 2012-2019, NIPPON TELEGRAPH AND TELEPHONE CORPORATION</p>
 </body>
 </html>

--- a/doc/pg_hint_plan-ja.html
+++ b/doc/pg_hint_plan-ja.html
@@ -628,10 +628,6 @@ postgres=#   WHERE aid IN (SELECT bid FROM pgbench_accounts a2 LIMIT 10);
 
 postgres=#
 </pre>
-<<<<<<< HEAD
-一つのクエリで上記のような副問い合わせを複数使用している場合は、「ANY_subquery」と指定しても対象を特定できないため、ヒント句はエラーとなり無視されます。</br>
-=======
-
 <dt><h3>IndexOnlyScanヒント句</h3></dt>
 <dd>ヒント句の対象となるテーブルにIndex Only Scanが可能なインデックスとIndex Only Scanが不可能なインデックスが同時に存在する場合、Index Only Scanが可能なインデックスをテーブルに対してIndexOnlyScanヒント句を追加で指定しないとIndex Scanが選択されることがあります。</dd>
 
@@ -641,7 +637,6 @@ postgres=#
 
 <dt><h3>UNION に対する並列実行ヒント</h3></dt>
 <dd>UNIONは直下のサブクエリが全て並列実行可能な場合にだけ並列実行を行います。一方ですべてのサブクエリが並列実行可能な場合は、そのうちの一つで並列実行を強制するとコスト比較の結果UNION全体が並列実行されることになります。ただし並列実行ヒントによる並列実行の禁止を行った場合はそのスキャンは並列実行不可となります。
->>>>>>> c6204a7... Added a notice in the manual.
 </dd>
 <dt>IndexOnlyScanヒント句の指定(PostgreSQL 9.2以降)</dt>
 <dd>ヒント句の対象となるテーブルにIndex Only Scanが可能なインデックスとIndex Only Scanが不可能なインデックスが存在する場合、Index Only Scanが可能なインデックスをテーブルと併せてIndexOnlyScanヒント句に指定しないとIndex Scanが選択されることがあります。</dd>
@@ -697,9 +692,9 @@ postgres=#
 <h2 id="requirement">動作環境</h2>
 <dl>
 <dt>PostgreSQL</dt>
-  <dd>バージョン 9.1, 9.2, 9.3, 9.4</dd>
+  <dd>バージョン 9.5</dd>
 <dt>動作確認済みOS</dt>
-  <dd>RHEL 6.5</dd>
+  <dd>RHEL 7.5</dd>
 </dl>
 
 <h2 id="seealso">関連項目</h2>
@@ -713,19 +708,6 @@ postgres=#
   <a href="pg_hint_plan-ja.html">pg_hint_plan</a>
 </div>
 
-<p class="footer">Copyright (c) 2012-2014, NIPPON TELEGRAPH AND TELEPHONE CORPORATION</p>
-
-<!--
-<script type="text/javascript">
-var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
-document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
-</script><script src="pg_statsinfo-ja_files/ga.js" type="text/javascript"></script>
-<script type="text/javascript">
-try{
-var pageTracker = _gat._getTracker("UA-10244036-6");
-pageTracker._trackPageview();
-} catch(err) {}
-</script>
--->
+<p class="footer">Copyright (c) 2012-2019, NIPPON TELEGRAPH AND TELEPHONE CORPORATION</p>
 </body>
 </html>

--- a/doc/pg_hint_plan.html
+++ b/doc/pg_hint_plan.html
@@ -312,29 +312,6 @@ postgres-# JOIN public.t1 pt ON (st.id=pt.id);
          ->  Seq Scan on t1 pt  (cost=0.00..34.00 rows=2400 width=4)
 (5 行)
 
-<<<<<<< HEAD
-postgres=#</pre>
-</p>
-<h2 id="restrictions">Restrictions</h2>
-<h3>Limitations on multiple VALUES lists in FROM clauses</h3>
-<p>All occurences of VALUES lists in FROM clauses in a query has the same name "*VALUES*" irrespective of aliases syntactically given to them or shown in explain descriptions. So it cannot be hinted at all if appeares twice or more in a target query.  </p>
-<h3>Hinting on inheritance children</h3>
-<p>Inheritnce children cannot be hinted individually. They share the same hints on their parent.</p>
-
-<h3>Setting pg_hint_plan parameters by Set hints</h3>
-<p>pg_hint_plan paramters changes the behavior of itself so some parameters doesn't work as expected.</p>
-<ul>
-<li>Hints to change enable_hint, enable_hint_tables are ignored, but they are reported as "used hints" in debug logs.</li>
-<li>Setting debug_print and message_level works from midst of the processing of the target query.</li>
-</ul>
-
-
-<h2 id="technics">Technics to hint on desired targets</h2>
-<h3>Hinting on objecects implicitly used in the target query</h3>
-<p>Hints are effective on any objects with the target name even if they aren't aparent in the query, specifically objects in views. For that reason, you should create different views in which targetted objects have distinct aliases if you want to hint them differently from the first view.</p>
-<p>In the following examples, the first query is assigning the same name "t1" on the two occurrences of the table1 so the hint SeqScan(t1) affects both scans. On the other hand the second assignes the different name 't3' on the one of them so the hint affects only on the rest one.</p>
-<p>This mechanism also applies on rewritten queries by rules.</p>
-=======
 <h3>Underlying tables of views or rules</h3>
 <dd>Hints are not applicable on views itself, but they can affect the
 queries within if the object names match the object names in the
@@ -369,7 +346,6 @@ so it is hintable if it is the only VALUES in a query. Two or more
 VALUES expressions in a query seems distinguishable looking its
 explain result. But in reality it is mere a cosmetic and they are not
 distinguisable.
->>>>>>> c6204a7... Added a notice in the manual.
 <pre>
 postgres=# CREATE VIEW view1 AS SELECT * FROM table1 <span class="strong">t1</span>;
 CREATE TABLE
@@ -430,18 +406,12 @@ postgres=#   WHERE aid IN (SELECT bid FROM pgbench_accounts a2 LIMIT 10);
 <h3>Using IndexOnlyScan hint (PostgreSQL 9.2 and later)</h3>
 <p>You shoud explicitly specify an index that can perform index only scan if you put IndexOnlyScan hint on a table that have other indexes that cannot perform index only scan. Or pg_hint_plan may select them. </p>
 
-<<<<<<< HEAD
-<h3>Precaution points for NoIndexScan hint (PostgreSQL 9.2 and later)</h3>
-<p>NoIndexScan hint involes NoIndexOnlyScan.</p>
-
-=======
 <h3>Parallel hint and UNION</h3>
 <dd>A UNION can run in parallel only when all underlying subqueries
 are parallel-safe. Conversely enforcing parallel on any of
 the subqueries let a parallel-executable UNION run in
 parallel. Meanwhile, a parallel hint with zero workers hinhibits a scan
 from executed in parallel.</dd>
->>>>>>> c6204a7... Added a notice in the manual.
 
 <h2 id="errors">Errors of hints</h2>
 <p>pg_hint_plan stops parsing on any error and uses hints already parsed on the most cases. Followings are the typical errors.</p>
@@ -477,9 +447,9 @@ from executed in parallel.</dd>
 <h2 id="requirement">Requirements</h2>
 <dl>
 <dt>PostgreSQL versions tested</dt>
-  <dd>Version 9.1, 9.2, 9.3, 9.4</dd>
+  <dd>Version 9.5</dd>
 <dt>OS versions tested</dt>
-  <dd>RHEL 6.5, 7.0</dd>
+  <dd>RHEL 7.5</dd>
 </dl>
 
 <h2 id="seealso">See also</h2>
@@ -493,19 +463,6 @@ from executed in parallel.</dd>
   <a href="pg_hint_plan.html">pg_hint_plan</a>
 </div>
 
-<p class="footer">Copyright (c) 2012, NIPPON TELEGRAPH AND TELEPHONE CORPORATION</p>
-
-<!--
-<script type="text/javascript">
-var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
-document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
-</script><script src="pg_statsinfo-ja_files/ga.js" type="text/javascript"></script>
-<script type="text/javascript">
-try{
-var pageTracker = _gat._getTracker("UA-10244036-6");
-pageTracker._trackPageview();
-} catch(err) {}
-</script>
--->
+<p class="footer">Copyright (c) 2012-2019, NIPPON TELEGRAPH AND TELEPHONE CORPORATION</p>
 </body>
 </html>

--- a/make_join_rel.c
+++ b/make_join_rel.c
@@ -6,8 +6,8 @@
  * src/backend/optimizer/path/joinrels.c
  *     make_join_rel()
  *
- * Portions Copyright (c) 2013-2018, NIPPON TELEGRAPH AND TELEPHONE CORPORATION
- * Portions Copyright (c) 1996-2015, PostgreSQL Global Development Group
+ * Portions Copyright (c) 2013-2019, NIPPON TELEGRAPH AND TELEPHONE CORPORATION
+ * Portions Copyright (c) 1996-2019, PostgreSQL Global Development Group
  * Portions Copyright (c) 1994, Regents of the University of California
  *
  *-------------------------------------------------------------------------

--- a/normalize_query.h
+++ b/normalize_query.h
@@ -6,7 +6,7 @@
  * This header file is created from pg_stat_statements.c to implement
  * normalization of query string.
  *
- * Portions Copyright (c) 2008-2014, PostgreSQL Global Development Group
+ * Portions Copyright (c) 2008-2019, PostgreSQL Global Development Group
  */
 #ifndef NORMALIZE_QUERY_H
 #define NORMALIZE_QUERY_H

--- a/pg_hint_plan.c
+++ b/pg_hint_plan.c
@@ -4,7 +4,7 @@
  *		  do instructions or hints to the planner using C-style block comments
  *		  of the SQL.
  *
- * Copyright (c) 2012-2014, NIPPON TELEGRAPH AND TELEPHONE CORPORATION
+ * Copyright (c) 2012-2019, NIPPON TELEGRAPH AND TELEPHONE CORPORATION
  *
  *-------------------------------------------------------------------------
  */

--- a/pg_stat_statements.c
+++ b/pg_stat_statements.c
@@ -4,7 +4,7 @@
  * 
  * Part of pg_stat_statements.c in PostgreSQL 9.5.
  *
- * Copyright (c) 2008-2015, PostgreSQL Global Development Group
+ * Copyright (c) 2008-2019, PostgreSQL Global Development Group
  *
  *-------------------------------------------------------------------------
  */