also set:
> max_worker_processes = 100
> max_parallel_workers_per_gather = 2
> max_parallel_workers = 100
>
> However, when I uses EXPLAIN to check the query plan, all of the nodes are
> set to "Parallel Aware"=false. Am I missing something?
>
> Here is my tables and
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
100
However, when I uses EXPLAIN to check the query plan​, *all of the nodes
are set to "Parallel Aware"=false*. *Am I missing something?*
Here is my tables and indexes:
CREATE TABLE t1(id int PRIMARY KEY, name varchar(200))
WITH(parallel_workers=2);
CREATE TABLE t2(id int PRIMARY KEY, fid