On Tue, Jan 9, 2018 at 5:41 AM, Amit Khandekar wrote:
> This subplan should not be there. It looks like that's because when
> we add up subpaths while preparing Parallel Append path containing mix of
> partial and non-partial child paths, in accumulate_append_subpath(),
> the subpath being added i
Thanks Rajkumar for catching this.
There is indeed is an extra child subplan showing up in the Parallel Append :
-> Parallel Append
-> Seq Scan on rm38941_inherit_t1
-> Parallel Seq Scan on rm38941_inherit
Hi,
I am getting extra subplan when using parallel append with multi-level
hierarchy, leading to data corruption.
Please see below test case.
-- set below parameters to encourage use of parallel plans
SET parallel_setup_cost=0;
SET parallel_tuple_cost=0;
SET min_parallel_table_scan_size=0;
SET m
