Commit271b678

Amit Kapila

committed

Back-patch "Fix parallel hash join path search."

Back-patch commit655393a to 9.6. Thissynchronizes the relavant code and helps in generating parallel paths insome cases in 9.6. This also helps in back-patch of future patches wherewe can get the same plan in all branches.Discussion:https://postgr.es/m/CAA4eK1+XK_875cJA1HPVpx9C7C8Fp7i4QzLJ17T3igfU2iadxQ@mail.gmail.com

1 parentfd4f2af commit271b678Copy full SHA for 271b678

File tree

-4

lines changed

-4

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1469,17 +1469,17 @@ hash_inner_and_outer(PlannerInfo *root,`
`1469`	`1469`	`/*`
`1470`	`1470`	`* Normally, given that the joinrel is parallel-safe, the cheapest`
`1471`	`1471`	`* total inner path will also be parallel-safe, but if not, we'll`
`1472`		`- * have to searchcheapest_parameterized_pathsfor the cheapest`
`1473`		`- *safe, unparameterized innerpath. If doing JOIN_UNIQUE_INNER,`
`1474`		`- *we can't use any alternativeinner path.`
	`1472`	`+ * have to search for the cheapest safe, unparameterized inner`
	`1473`	`+ * path. If doing JOIN_UNIQUE_INNER, we can't use any alternative`
	`1474`	`+ * inner path.`
`1475`	`1475`	`*/`
`1476`	`1476`	`if (cheapest_total_inner->parallel_safe)`
`1477`	`1477`	`cheapest_safe_inner=cheapest_total_inner;`
`1478`	`1478`	`elseif (save_jointype!=JOIN_UNIQUE_INNER)`
`1479`	`1479`	`{`
`1480`	`1480`	`ListCell*lc;`
`1481`	`1481`
`1482`		`-foreach(lc,innerrel->cheapest_parameterized_paths)`
	`1482`	`+foreach(lc,innerrel->pathlist)`
`1483`	`1483`	`{`
`1484`	`1484`	`Pathinnerpath= (Path)lfirst(lc);`
`1485`	`1485`

Comments

(0)