dont_reduce_cost_of_inner_unique_nested_loops.patch
application/octet-stream
Filename: dont_reduce_cost_of_inner_unique_nested_loops.patch
Type: application/octet-stream
Part: 0
Message:
Re: Perfomance bug in v10
Patch
Format: unified
| File | + | − |
|---|---|---|
| src/backend/optimizer/path/costsize.c | 2 | 4 |
diff --git a/src/backend/optimizer/path/costsize.c b/src/backend/optimizer/path/costsize.c
index cdb18d9..a187943 100644
--- a/src/backend/optimizer/path/costsize.c
+++ b/src/backend/optimizer/path/costsize.c
@@ -2118,8 +2118,7 @@ initial_cost_nestloop(PlannerInfo *root, JoinCostWorkspace *workspace,
inner_run_cost = inner_path->total_cost - inner_path->startup_cost;
inner_rescan_run_cost = inner_rescan_total_cost - inner_rescan_start_cost;
- if (jointype == JOIN_SEMI || jointype == JOIN_ANTI ||
- extra->inner_unique)
+ if (jointype == JOIN_SEMI || jointype == JOIN_ANTI)
{
/*
* With a SEMI or ANTI join, or if the innerrel is known unique, the
@@ -2204,8 +2203,7 @@ final_cost_nestloop(PlannerInfo *root, NestPath *path,
/* cost of inner-relation source data (we already dealt with outer rel) */
- if (path->jointype == JOIN_SEMI || path->jointype == JOIN_ANTI ||
- extra->inner_unique)
+ if (path->jointype == JOIN_SEMI || path->jointype == JOIN_ANTI)
{
/*
* With a SEMI or ANTI join, or if the innerrel is known unique, the