Re: Parallel Aware

2018-07-05 Thread Rafia Sabih
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

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

Parallel Aware

2018-02-26 Thread Marwan Almaymoni
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