Postgres Pro
Downloads
Home   >   mailing lists

Parallel Query - Mailing list pgsql-general

From Krithika Venkatesh
Subject Parallel Query
Date
Msg-id CAP7eca0a80n2X4jn7rn9mDRFOb7CdonX_G9USytwfdihGOAbow@mail.gmail.com
Whole thread Raw
Responses Re: Parallel Query
List pgsql-general
Tree view
Hi All,

I was reading about parallel queries in postgresql 10.

I came across the property max_parallel_workers_per_gather. It sets the maximum number of workers that can be started by a single Gather or Gather Merge node. 

I am not able to understand gather and gather merge node. 

What is the difference between max_parallel_workers_per_gather and max_parallel_processes. What is meant by gather node.

Please let me know.

Thanks,
Krithika

pgsql-general by date:

Previous
From: Andreas 'ads' Scherbaum
Date:
Subject: FOSDEM booth volunteer
Next
From: Durumdara
Date:
Subject: Re: String comparison problem in select - too many results