Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit655393a

Browse files
committed
Fix parallel hash join path search.
When the very cheapest path is not parallel-safe, we want to instead usethe cheapest unparameterized path that is. The old code searchedinnerrel->cheapest_parameterized_paths, but that isn't right, becausethe path we want may not be in that list. Search innerrel->pathlistinstead.Spotted by Dilip Kumar.Discussion:http://postgr.es/m/CAFiTN-szCEcZrQm0i_w4xqSaRUTOUFstNu32Zn4rxxDcoa8gnA@mail.gmail.com
1 parentb2678ef commit655393a

File tree

1 file changed

+4
-4
lines changed

1 file changed

+4
-4
lines changed

‎src/backend/optimizer/path/joinpath.c‎

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1510,17 +1510,17 @@ hash_inner_and_outer(PlannerInfo *root,
15101510
/*
15111511
* Normally, given that the joinrel is parallel-safe, the cheapest
15121512
* total inner path will also be parallel-safe, but if not, we'll
1513-
* have to searchcheapest_parameterized_pathsfor the cheapest
1514-
*safe, unparameterized innerpath. If doing JOIN_UNIQUE_INNER,
1515-
*we can't use any alternativeinner path.
1513+
* have to search for the cheapest safe, unparameterized inner
1514+
* path. If doing JOIN_UNIQUE_INNER, we can't use any alternative
1515+
* inner path.
15161516
*/
15171517
if (cheapest_total_inner->parallel_safe)
15181518
cheapest_safe_inner=cheapest_total_inner;
15191519
elseif (save_jointype!=JOIN_UNIQUE_INNER)
15201520
{
15211521
ListCell*lc;
15221522

1523-
foreach(lc,innerrel->cheapest_parameterized_paths)
1523+
foreach(lc,innerrel->pathlist)
15241524
{
15251525
Path*innerpath= (Path*)lfirst(lc);
15261526

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp