Re: Pg10 : Client Configuration for Parallelism ?

Wed, 17 Apr 2019 06:02:04 -0700 

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























					Reply via email to