Hi, just caught another InitPlan below Gather with the recent patches in (master as of 4cc6a3f). Recipe below.
regards, andreas set max_parallel_workers_per_gather = 2; set min_parallel_relation_size = 0; set parallel_setup_cost = 0; set parallel_tuple_cost = 0; explain select 1 from public.quad_point_tbl as ref_0, lateral (select ref_0.p as c3, sample_0.d as c5 from public.nv_child_2010 as sample_0 left join public.mvtest_tvv as ref_1 on ('x'< (select contype from pg_catalog.pg_constraint limit 1)) limit 82) as subq_0; -- QUERY PLAN -- -------------------------------------------------------------------------------------------------------- -- Gather (cost=0.19..13727.52 rows=902246 width=4) -- Workers Planned: 2 -- -> Nested Loop (cost=0.19..13727.52 rows=902246 width=4) -- -> Parallel Seq Scan on quad_point_tbl ref_0 (cost=0.00..105.85 rows=4585 width=16) -- -> Limit (cost=0.19..1.33 rows=82 width=20) -- InitPlan 1 (returns $0) -- -> Limit (cost=0.00..0.19 rows=1 width=1) -- -> Gather (cost=0.00..10.22 rows=54 width=1) -- Workers Planned: 2 -- -> Parallel Seq Scan on pg_constraint (cost=0.00..10.22 rows=22 width=1) -- -> Seq Scan on nv_child_2010 sample_0 (cost=0.00..35.50 rows=2550 width=20) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers