From: | Rafia Sabih <rafia(dot)sabih(at)enterprisedb(dot)com> |
---|---|
To: | Marwan Almaymoni <marwan(dot)mmm(at)gmail(dot)com> |
Cc: | pgsql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Parallel Aware |
Date: | 2018-07-05 11:16:09 |
Message-ID: | CAOGQiiOXO6AozCEQX-=LZgwDX4m3AKXv2GAyb3CZipZRUvVoZg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Feb 27, 2018 at 1:15 AM, Marwan Almaymoni <marwan(dot)mmm(at)gmail(dot)com> 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_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);
>
Parallel index scans/bitmap heap scans are only supported for btree indexes.
> Here's the query I tested with EXPLAIN:
> SELECT * FROM t1 INNER JOIN t2 ON t1.id = t2.fid WHERE t1.id > 100;
>
--
Regards,
Rafia Sabih
EnterpriseDB: http://www.enterprisedb.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Tom van Tilburg | 2018-07-05 12:44:31 | Re: Postgres sometimes stalling on 'percentile_cont' |
Previous Message | pinker | 2018-07-05 08:54:33 | Re: FK v.s unique indexes |