• R/O
  • HTTP
  • SSH
  • HTTPS

pg_hint_plan: コミット

firtst release


コミットメタ情報

リビジョンf5f1326abcd67640e5efc9740e961fbc1a31ec2c (tree)
日時2019-01-07 19:13:37
作者Kyotaro Horiguchi <horiguchi.kyotaro@lab....>
コミッターKyotaro Horiguchi

ログメッセージ

Adjust regression test.

Planning behavior has been changed in core. Adjust regression test.

変更サマリ

差分

--- a/output/ut-W.source
+++ b/output/ut-W.source
@@ -259,12 +259,12 @@ not used hint:
259259 duplication hint:
260260 error hint:
261261
262- QUERY PLAN
263--------------------------------------------------------
264- Hash Join
265- Hash Cond: (p1.id = p2.id)
266- -> Gather
267- Workers Planned: 1
262+ QUERY PLAN
263+-------------------------------------------------
264+ Gather
265+ Workers Planned: 1
266+ -> Hash Join
267+ Hash Cond: (p1.id = p2.id)
268268 -> Append
269269 -> Parallel Seq Scan on p1
270270 -> Parallel Seq Scan on p1_c1
@@ -275,20 +275,18 @@ error hint:
275275 -> Parallel Seq Scan on p1_c1_c2
276276 -> Parallel Seq Scan on p1_c3_c1
277277 -> Parallel Seq Scan on p1_c3_c2
278- -> Hash
279- -> Gather
280- Workers Planned: 1
278+ -> Hash
281279 -> Append
282- -> Parallel Seq Scan on p2
283- -> Parallel Seq Scan on p2_c1
284- -> Parallel Seq Scan on p2_c2
285- -> Parallel Seq Scan on p2_c3
286- -> Parallel Seq Scan on p2_c4
287- -> Parallel Seq Scan on p2_c1_c1
288- -> Parallel Seq Scan on p2_c1_c2
289- -> Parallel Seq Scan on p2_c3_c1
290- -> Parallel Seq Scan on p2_c3_c2
291-(27 rows)
280+ -> Seq Scan on p2
281+ -> Seq Scan on p2_c1
282+ -> Seq Scan on p2_c2
283+ -> Seq Scan on p2_c3
284+ -> Seq Scan on p2_c4
285+ -> Seq Scan on p2_c1_c1
286+ -> Seq Scan on p2_c1_c2
287+ -> Seq Scan on p2_c3_c1
288+ -> Seq Scan on p2_c3_c2
289+(25 rows)
292290
293291 /*+Parallel(p1 8)Parallel(p2 0)*/
294292 EXPLAIN (COSTS false) SELECT * FROM p1 join p2 on p1.id = p2.id;
旧リポジトリブラウザで表示