Andy Fan writes:
Hi,
After some coding with this subject, I think it is better redefining
the problem and solution.
Problem:
Supplan is common to be ineffective *AND* recently I find it is hard to
work with parallel framework. e.g.
create table bigt (a int, b int, c int);
insert into
t
>Filter: (c = o.c)
> (8 rows)
>
> because:
>
> (1). During the planning of the SubPlan, we use is_parallel_safe() to
> set the "bigt i"'s consider_parallel to false because of the above
> "PARAM_EXEC" reason.
>
> (2). The
to
set the "bigt i"'s consider_parallel to false because of the above
"PARAM_EXEC" reason.
(2). The parallel_safe of the final SubPlan is set to false due to
rel->consider_parallel.
(3). During the planning of "bigt o", it calls is_parallel_safe an
