Re: Parallel Aware

2018-07-05 Thread Rafia Sabih
On Tue, Feb 27, 2018 at 1:15 AM, Marwan Almaymoni wrote: > Hi, > > I'm trying to run my query in parallel mode. I have setup my tables with " > WITH(parallel_workers=2)" storage parameter and I've created indexes for > needed attributes. > I have also set: > max_worker_processes = 100 > max_parall

Re: Parallel Aware

2018-07-04 Thread jbrant
You're not alone - I have the same issue on PostgreSQL 10.3, even with "force_parallel_mode" enabled and a query plan that includes bitmap heap scans (which should be parallelizable). -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html