From: | Marwan Almaymoni <marwan(dot)mmm(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Parallel Aware |
Date: | 2018-02-26 19:45:25 |
Message-ID: | CAE8pKtm54a1Maz0ws0iKxgJC0wtTdxUEA49Rk8kfn+TX3Vmtxw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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_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 indexes:
CREATE TABLE t1(id int PRIMARY KEY, name varchar(200))
WITH(parallel_workers=2);
CREATE TABLE t2(id int PRIMARY KEY, fid int, value varchar(200))
WITH(parallel_workers=2);
CREATE INDEX ind_t1_id ON t1 USING HASH (id);
CREATE INDEX ind_t2_fid ON t2 USING HASH (fid);
Here's the query I tested with EXPLAIN:
SELECT * FROM t1 INNER JOIN t2 ON t1.id = t2.fid WHERE t1.id > 100;
From | Date | Subject | |
---|---|---|---|
Next Message | geoff hoffman | 2018-02-26 20:45:35 | Re: Creating complex track changes database - challenge! |
Previous Message | David G. Johnston | 2018-02-26 17:05:37 | Re: psql '\copy to' and unicode escapes |