Re: Pg10 : Client Configuration for Parallelism ?

From: Gunther Schadow <gunther(at)pragmaticdata(dot)com>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Pg10 : Client Configuration for Parallelism ?
Date: 2019-04-17 11:55:14
Message-ID: 01889de3-4507-a496-caa6-1ae138e3eb69@pragmaticdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 4/17/2019 4:33, Thomas Kellerer wrote:
> A CTE would prevent parallelism.

You mean like always? His

SELECT count(1) FROM BigTable

would be parallel if run alone but as

WITH Data AS (SELECT count(1) FROM BigTable) SELECT * FROM Data

nothing would be parallel any more? How about:

SELECT * FROM (SELECT count(1) FROM BigTable) x

Parallel or not?

-Gunther

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Gunther Schadow 2019-04-17 11:58:58 Re: Pg10 : Client Configuration for Parallelism ?
Previous Message laurent.dechambe 2019-04-17 11:26:07 RE: Pg10 : Client Configuration for Parallelism ?