On Wed, Apr 26, 2017 at 07:38:05PM +0530, Amit Kapila wrote:
> >> I have already mentioned the commit id (5e6d8d2b). Text can be "Allow
> >> queries containing subplans to execute in parallel". We should also
> >> mention in some way that this applies only when the query contains
> >> uncorrelated subplan.
> >
> > Sorry but I don't know what that means, and if I don't know, others
> > might not either.
> >
>
> regression=# explain (costs off) select count(*) from tenk1 where
> (two, four) not in (select hundred, thousand from tenk2 where
> thousand > 100);
> QUERY PLAN
> ------------------------------------------------------
> Finalize Aggregate
> -> Gather
> Workers Planned: 2
> -> Partial Aggregate
> -> Parallel Seq Scan on tenk1
> Filter: (NOT (hashed SubPlan 1))
> SubPlan 1
> -> Seq Scan on tenk2
> Filter: (thousand > 100)
> (9 rows)
>
Oh, so non-correlated subqueries can be run in parallel. Yes, that is
something we should have in the release notes. How is this?
Author: Robert Haas <rh...@postgresql.org>
2017-02-14 [5e6d8d2bb] Allow parallel workers to execute subplans.
Allow non-correlated subqueries to be run in parallel (Amit Kapila)
--
Bruce Momjian <br...@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
