Re: Wrong plan with extra parallel workers

2018-04-27 Thread Amit Kapila
On Fri, Apr 27, 2018 at 2:48 PM, Guilherme Pereira wrote: > Hi, > > Having a strange situation, where adding extra parallel workers > (max_parallel_workers_per_gather), the planner chooses a different plan, I think I can see what is going on here. The planner chooses a different plan because the

Re: Wrong plan with extra parallel workers

2018-04-27 Thread Guilherme Pereira
Forgot to mention that I'm using the development branch of Postgres 11. Also as requested, sending the plans via the https://explain.depesz.com app. set max_parallel_workers_per_gather = 2; EXPLAIN ANALYZE SELECT "f_zendesktickets_aaeljtllr5at3el"."via_id" AS "a_1303", COUNT( DISTINCT "f_