• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: コミット

firtst release


コミットメタ情報

リビジョンdd2685c5f540826a971a5d757d8a926a8c83de65 (tree)
日時2017-10-04 09:46:43
作者Kyotaro Horiguchi <horiguchi.kyotaro@lab....>
コミッターKyotaro Horiguchi

ログメッセージ

Add a regression about forcing gather-merge.

The previous commit is said to allow enforce gather merge but no
regression for that is not included. This adds that.

変更サマリ

差分

--- a/expected/ut-W.out
+++ b/expected/ut-W.out
@@ -65,6 +65,23 @@ error hint:
6565 -> Parallel Seq Scan on t1
6666 (3 rows)
6767
68+/*+Parallel(t1 4 hard) */ /* to be gather merge*/
69+EXPLAIN (COSTS false) SELECT * FROM s1.t1 ORDER BY s1.t1.c1 LIMIT 4;
70+LOG: pg_hint_plan:
71+used hint:
72+Parallel(t1 4 hard)
73+not used hint:
74+duplication hint:
75+error hint:
76+
77+ QUERY PLAN
78+---------------------------------------------------
79+ Limit
80+ -> Gather Merge
81+ Workers Planned: 4
82+ -> Parallel Index Scan using t1_i1 on t1
83+(4 rows)
84+
6885 -- Queries on inheritance tables
6986 SET parallel_setup_cost to 0;
7087 SET parallel_tuple_cost to 0;
--- a/sql/ut-W.sql
+++ b/sql/ut-W.sql
@@ -26,6 +26,9 @@ EXPLAIN (COSTS false) SELECT * FROM s1.t1;
2626 /*+Parallel(t1 8 hard)*/
2727 EXPLAIN (COSTS false) SELECT * FROM s1.t1;
2828
29+/*+Parallel(t1 4 hard) */ /* to be gather merge*/
30+EXPLAIN (COSTS false) SELECT * FROM s1.t1 ORDER BY s1.t1.c1 LIMIT 4;
31+
2932 -- Queries on inheritance tables
3033 SET parallel_setup_cost to 0;
3134 SET parallel_tuple_cost to 0;
旧リポジトリブラウザで表示