Re: Pg10 : Client Configuration for Parallelism ?

[Gunther Schadow <gunther@xxxxxxxxxxxxxxxxx>]

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