Re: Pg10 : Client Configuration for Parallelism ? - Mailing list pgsql-performance

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