Re: Pg10 : Client Configuration for Parallelism ?

Gunther Schadow <[email protected]> Wed, 17 Apr 2019 07:55:14 -0400

Newsgroups	gmane.comp.db.postgresql.performance
Message-ID	<[email protected]>

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